Is there a tutorial or reference to the different terms that appear on the explain output?

Items such as "Nested Loop", "Hash"..

Also is there a way to easily tell which of two explains is "worse". Example I am running a query with "set enable_seqscan to off;" and i see the explain now shows index scans, but not sure if is any faster now.

I tried "explain analyze" and the "total runtime" for the one with seq_scan off was faster, but after repeathing them they both dropped in time, likely due to data getting cached. Even after the time drops for both the one with seqscan off was always faster.

Is there any disadvantage of having the enable_seqscan off?

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
     subscribe-nomail command to [EMAIL PROTECTED] so that your
     message can get through to the mailing list cleanly

Reply via email to