#	exclusive	inclusive	rows x	rows	loops	node
1.	0.020	4119.206	↑ 1.0	1	1	→ Result (cost=932078.920..932078.930 rows=1 width=0) (actual time=4119.205..4119.206 rows=1 loops=1)
2.						Initplan (forResult)
3.	22.222	821.467	↑ 1.0	1	1	→ Aggregate (cost=463041.020..463041.030 rows=1 width=0) (actual time=821.466..821.467 rows=1 loops=1)
4.	799.245	799.245	↓ 1339.7	25455	1	→ Index Scan using golf on foxtrot (cost=0.010..463040.970 rows=19 width=0) (actual time=0.276..799.245 rows=25455 loops=1) Index Cond: ((xray = false) AND (india >= (zulu() - 'seven'::interval))) Filter: (NOT xray)
5.	801.290	3297.719	↑ 1.0	1	1	→ Aggregate (cost=469037.880..469037.890 rows=1 width=0) (actual time=3297.718..3297.719 rows=1 loops=1)
6.	2496.429	2496.429	↓ 529.8	931342	1	→ Index Scan using golf on foxtrot (cost=0.010..469033.490 rows=1758 width=0) (actual time=33.963..2496.429 rows=931342 loops=1) Index Cond: ((xray = true) AND (india >= (zulu() - 'seven'::interval))) Filter: xray

Result  (cost=932078.920..932078.930 rows=1 width=0) (actual time=4119.205..4119.206 rows=1 loops=1)
  InitPlan
    ->  Aggregate  (cost=463041.020..463041.030 rows=1 width=0) (actual time=821.466..821.467 rows=1 loops=1)
          ->  Index Scan using golf on foxtrot  (cost=0.010..463040.970 rows=19 width=0) (actual time=0.276..799.245 rows=25455 loops=1)
                  Index Cond: ((xray = false) AND (india >= (zulu() - 'seven'::interval)))
                  Filter: (NOT xray)
  InitPlan
    ->  Aggregate  (cost=469037.880..469037.890 rows=1 width=0) (actual time=3297.718..3297.719 rows=1 loops=1)
          ->  Index Scan using golf on foxtrot  (cost=0.010..469033.490 rows=1758 width=0) (actual time=33.963..2496.429 rows=931342 loops=1)
                  Index Cond: ((xray = true) AND (india >= (zulu() - 'seven'::interval)))
                  Filter: xray

Per node type stats

node type	count	sum of times	% of query
Aggregate	2	823.512 ms	20.0 %
Index Scan	2	3295.674 ms	80.0 %
Result	1	0.020 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
foxtrot	2	3295.674 ms	80.0 %
Index Scan	2	3295.674 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: fTn : slow

Colorize:

Columns visibility:

Per node type stats

Per table stats