explain-analyze.info | query-plan-1147

Summary

Time Node

Node (ms) Percent

Time	Node
Node (ms)	Percent
11001.651	100.00%	¶	`Limit (cost=0.0..377.0 rows=40 width=47) (actual time=11000.002..11001.651 rows=40 loops=1)`
11001.617	100.00%	¶	`-> Index Scan using voevents_general_event_starttime on voevents_general (cost=0.0..1736671.71 rows=184261 width=47) (actual time=10999.995..11001.617 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)`

11001.651

100.00%

 Limit (cost=0.0..377.0 rows=40 width=47) (actual time=11000.002..11001.651 rows=40 loops=1)

11001.617

100.00%

   -> Index Scan using voevents_general_event_starttime on voevents_general (cost=0.0..1736671.71 rows=184261 width=47) (actual time=10999.995..11001.617 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

11.001767 seconds (11001.767 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.