explain-analyze.info

Summary

Time Node

Node (ms) Percent

Time	Node
Node (ms)	Percent
9529.207	100.00%	¶	`Limit (cost=0.0..368.32 rows=40 width=47) (actual time=9527.367..9529.207 rows=40 loops=1)`
9529.170	100.00%	¶	`-> Index Scan using voevents_general_event_starttime on voevents_general (cost=0.0..1692126.42 rows=183769 width=47) (actual time=9527.361..9529.170 rows=40 loops=1) Filter: "overlaps"(event_starttime, event_endtime, '2004-07-11 00:00:00'::timestamp without time zone, '2004-12-11 23:59:59'::timestamp without time zone)`

9529.207

100.00%

 Limit (cost=0.0..368.32 rows=40 width=47) (actual time=9527.367..9529.207 rows=40 loops=1)

9529.170

100.00%

   -> Index Scan using voevents_general_event_starttime on voevents_general (cost=0.0..1692126.42 rows=183769 width=47) (actual time=9527.361..9529.170 rows=40 loops=1)
         Filter: "overlaps"(event_starttime, event_endtime, '2004-07-11 00:00:00'::timestamp without time zone, '2004-12-11 23:59:59'::timestamp without time zone)

Run-time

9.529332 seconds (9529.332 ms)

Highlighted rows indicate a disparity between the number of rows estimated and actually returned. You may want to run ANALYZE to update the server's statistics.
For more information on using EXPLAIN and interpreting its output, see the Postgres documentation, in particular the EXPLAIN and ANALYZE references pages, and Using Explain.

asdf