#	exclusive	inclusive	rows x	rows	loops	node
1.	0.003	3128.525	↑ 1.0	1	1	→ Limit (cost=2036257.190..2036257.320 rows=1 width=36) (actual time=3128.524..3128.525 rows=1 loops=1) Total runtime: 3128.763 ms
2.	0.024	3128.522	↑ 25.0	1	1	→ Subquery Scan on sq3 (cost=2036257.190..2036260.560 rows=25 width=36) (actual time=3128.522..3128.522 rows=1 loops=1)
3.	0.007	3128.498	↑ 25.0	1	1	→ WindowAgg (cost=2036257.190..2036257.940 rows=25 width=40) (actual time=3128.498..3128.498 rows=1 loops=1)
4.	0.019	3128.491	↑ 25.0	1	1	→ Sort (cost=2036257.190..2036257.250 rows=25 width=40) (actual time=3128.491..3128.491 rows=1 loops=1) Sort Key: delta_zulu2.mike, delta_zulu2.juliet_papa Sort Method: quicksort Memory: 26kB
5.	0.110	3128.472	↑ 1.5	17	1	→ WindowAgg (cost=3.340..2036256.610 rows=25 width=40) (actual time=3128.461..3128.472 rows=17 loops=1)
6.	0.029	3128.362	↑ 1.5	17	1	→ Subquery Scan on sq2 (cost=3.340..2036256.300 rows=25 width=40) (actual time=1066.735..3128.362 rows=17 loops=1)
7.	0.671	3128.333	↑ 1.5	17	1	→ WindowAgg (cost=3.340..2036256.050 rows=25 width=34) (actual time=1066.734..3128.333 rows=17 loops=1)
8.	0.084	1032.324	↑ 1.5	17	1	→ Sort (cost=3.340..3.400 rows=25 width=34) (actual time=1032.304..1032.324 rows=17 loops=1) Sort Key: ((four.foxtrot_whiskey - (delta_four 5))) Sort Method: quicksort Memory: 26kB
9.	0.170	1032.240	↑ 1.5	17	1	→ Seq Scan on three_five four (cost=0.000..2.760 rows=25 width=34) (actual time=6.349..1032.240 rows=17 loops=1) Filter: (foxtrot_oscar AND echo)zulu_lima, SubPlan 5k_rank) as total_sent,
10.	1.071	1032.070	↑ 1.0	1	17	→ Aggregate (cost=20892.390..20892.400 rows=1 width=4) (actual time=60.710..60.710 rows=1 loops=17)
11.	34.303	1030.999	↑ 21.9	165	17	→ Nested Loop (cost=31.910..20883.360 rows=3612 width=4) (actual time=60.300..60.647 rows=165 loops=17)
12.	48.518	55.624	↓ 2.3	3460	17	→ Bitmap Heap Scan on uniform alpha (cost=31.910..2680.770 rows=1501 width=4) (actual time=0.595..3.272 rows=3460 loops=17) Recheck Cond: (oscar = four.oscar)
13.	7.106	7.106	↓ 2.3	3460	17	→ Bitmap Index Scan on whiskey (cost=0.000..31.540 rows=1501 width=0) (actual time=0.418..0.418 rows=3460 loops=17) Index Cond: (oscar = four.oscar)
14.	941.072	941.072	↓ 0.0	0	58817	→ Index Scan using quebec on zulu_xray juliet_xray (cost=0.000..11.980 rows=12 width=8) (actual time=0.016..0.016 rows=0 loops=58817) Index Cond: (delta_hotel = alpha.delta_hotel) Filter: (two >= (papa('six'::text, (zulu_golf() - (four.juliet_sierra)::interval)) + (four.juliet_sierra)::interval))
15.						SubPlan (forWindowAgg)
16.	1.078	982.828	↑ 1.0	1	14	→ Aggregate (cost=20892.390..20892.400 rows=1 width=4) (actual time=70.201..70.202 rows=1 loops=14)
17.	53.240	981.750	↑ 18.1	200	14	→ Nested Loop (cost=31.910..20883.360 rows=3612 width=4) (actual time=69.713..70.125 rows=200 loops=14)
18.	48.258	55.300	↓ 2.8	4158	14	→ Bitmap Heap Scan on uniform alpha (cost=31.910..2680.770 rows=1501 width=4) (actual time=0.715..3.950 rows=4158 loops=14) Recheck Cond: (oscar = four.oscar)
19.	7.042	7.042	↓ 2.8	4158	14	→ Bitmap Index Scan on whiskey (cost=0.000..31.540 rows=1501 width=0) (actual time=0.503..0.503 rows=4158 loops=14) Index Cond: (oscar = four.oscar)bravo
20.	873.210	873.210	↓ 0.0	0	58214	→ Index Scan using quebec on zulu_xray juliet_xray (cost=0.000..11.980 rows=12 width=8) (actual time=0.015..0.015 rows=0 loops=58214) Index Cond: (delta_hotel = alpha.delta_hotel) Filter: (two >= (papa('six'::text, (zulu_golf() - (four.juliet_sierra)::interval)) + (four.juliet_sierra)::interval))
21.	3.411	17.421	↑ 1.0	1	3	→ Aggregate (cost=9386.390..9386.400 rows=1 width=4) (actual time=5.807..5.807 rows=1 loops=3)
22.	6.869	14.010	↑ 1.1	3275	3	→ Nested Loop (cost=31.660..9377.370 rows=3609 width=4) (actual time=0.194..4.670 rows=3275 loops=3)
23.	0.555	0.648	↓ 0.0	0	3	→ Bitmap Heap Scan on uniform alpha (cost=31.660..2699.290 rows=500 width=4) (actual time=0.181..0.216 rows=0 loops=3) Recheck Cond: (oscar = four.oscar) Filter: (delta_sierra >= (zulu_golf() - ((lima(four.three_tango, 0))::double precision * 'november'::interval)))
24.	0.093	0.093	↑ 7.5	201	3	→ Bitmap Index Scan on whiskey (cost=0.000..31.540 rows=1501 width=0) (actual time=0.031..0.031 rows=201 loops=3) Index Cond: (oscar = four.oscar)
25.	6.493	6.493	↓ 265.6	9826	1	→ Index Scan using quebec on zulu_xray juliet_xray (cost=0.000..12.890 rows=37 width=8) (actual time=0.014..6.493 rows=9826 loops=1) Index Cond: (delta_hotel = alpha.delta_hotel)
26.	1.071	1018.266	↑ 1.0	1	17	→ Aggregate (cost=20892.390..20892.400 rows=1 width=4) (actual time=59.898..59.898 rows=1 loops=17)
27.	79.435	1017.195	↑ 21.9	165	17	→ Nested Loop (cost=31.910..20883.360 rows=3612 width=4) (actual time=59.499..59.835 rows=165 loops=17)
28.	48.399	55.505	↓ 2.3	3460	17	→ Bitmap Heap Scan on uniform alpha (cost=31.910..2680.770 rows=1501 width=4) (actual time=0.593..3.265 rows=3460 loops=17) Recheck Cond: (oscar = four.oscar)
29.	7.106	7.106	↓ 2.3	3460	17	→ Bitmap Index Scan on whiskey (cost=0.000..31.540 rows=1501 width=0) (actual time=0.418..0.418 rows=3460 loops=17) Index Cond: (oscar = four.oscar)
30.	882.255	882.255	↓ 0.0	0	58817	→ Index Scan using quebec on zulu_xray juliet_xray (cost=0.000..11.980 rows=12 width=8) (actual time=0.015..0.015 rows=0 loops=58817) Index Cond: (delta_hotel = alpha.delta_hotel) Filter: (two >= (papa('six'::text, (zulu_golf() - (four.juliet_sierra)::interval)) + (four.juliet_sierra)::interval))
31.	3.536	76.823	↑ 1.0	1	17	→ Aggregate (cost=9386.390..9386.400 rows=1 width=4) (actual time=4.519..4.519 rows=1 loops=17)
32.	7.023	73.287	↑ 6.2	578	17	→ Nested Loop (cost=31.660..9377.370 rows=3609 width=4) (actual time=3.520..4.311 rows=578 loops=17)
33.	52.564	59.704	↓ 0.0	0	17	→ Bitmap Heap Scan on uniform alpha (cost=31.660..2699.290 rows=500 width=4) (actual time=3.506..3.512 rows=0 loops=17) Recheck Cond: (oscar = four.oscar) Filter: (delta_sierra >= (zulu_golf() - ((lima(four.three_tango, 0))::double precision * 'november'::interval)))
34.	7.140	7.140	↓ 2.3	3460	17	→ Bitmap Index Scan on whiskey (cost=0.000..31.540 rows=1501 width=0) (actual time=0.420..0.420 rows=3460 loops=17) Index Cond: (oscar = four.oscar)
35.	6.560	6.560	↓ 265.6	9826	1	→ Index Scan using quebec on zulu_xray juliet_xray (cost=0.000..12.890 rows=37 width=8) (actual time=0.014..6.560 rows=9826 loops=1) Index Cond: (delta_hotel = alpha.delta_hotel)

Limit  (cost=2036257.190..2036257.320 rows=1 width=36) (actual time=3128.524..3128.525 rows=1 loops=1)
    Total runtime: 3128.763 ms
  ->  Subquery Scan on sq3  (cost=2036257.190..2036260.560 rows=25 width=36) (actual time=3128.522..3128.522 rows=1 loops=1)
        ->  WindowAgg  (cost=2036257.190..2036257.940 rows=25 width=40) (actual time=3128.498..3128.498 rows=1 loops=1)
              ->  Sort  (cost=2036257.190..2036257.250 rows=25 width=40) (actual time=3128.491..3128.491 rows=1 loops=1)
                      Sort Key: delta_zulu2.mike, delta_zulu2.juliet_papa
                      Sort Method: quicksort  Memory: 26kB
                    ->  WindowAgg  (cost=3.340..2036256.610 rows=25 width=40) (actual time=3128.461..3128.472 rows=17 loops=1)
                          ->  Subquery Scan on sq2  (cost=3.340..2036256.300 rows=25 width=40) (actual time=1066.735..3128.362 rows=17 loops=1)
                                ->  WindowAgg  (cost=3.340..2036256.050 rows=25 width=34) (actual time=1066.734..3128.333 rows=17 loops=1)
                                      ->  Sort  (cost=3.340..3.400 rows=25 width=34) (actual time=1032.304..1032.324 rows=17 loops=1)
                                              Sort Key: ((four.foxtrot_whiskey - (delta_four 5)))
                                              Sort Method: quicksort  Memory: 26kB
                                            ->  Seq Scan on three_five four  (cost=0.000..2.760 rows=25 width=34) (actual time=6.349..1032.240 rows=17 loops=1)
                                                    Filter: (foxtrot_oscar AND echo)zulu_lima,
                                                    SubPlan 5k_rank) as total_sent,
                                                  ->  Aggregate  (cost=20892.390..20892.400 rows=1 width=4) (actual time=60.710..60.710 rows=1 loops=17)
                                                        ->  Nested Loop  (cost=31.910..20883.360 rows=3612 width=4) (actual time=60.300..60.647 rows=165 loops=17)
                                                              ->  Bitmap Heap Scan on uniform alpha  (cost=31.910..2680.770 rows=1501 width=4) (actual time=0.595..3.272 rows=3460 loops=17)
                                                                      Recheck Cond: (oscar = four.oscar)
                                                                    ->  Bitmap Index Scan on whiskey  (cost=0.000..31.540 rows=1501 width=0) (actual time=0.418..0.418 rows=3460 loops=17)
                                                                            Index Cond: (oscar = four.oscar)
                                                              ->  Index Scan using quebec on zulu_xray juliet_xray  (cost=0.000..11.980 rows=12 width=8) (actual time=0.016..0.016 rows=0 loops=58817)
                                                                      Index Cond: (delta_hotel = alpha.delta_hotel)
                                                                      Filter: (two >= (papa('six'::text, (zulu_golf() - (four.juliet_sierra)::interval)) + (four.juliet_sierra)::interval))
                                      SubPlan
                                        ->  Aggregate  (cost=20892.390..20892.400 rows=1 width=4) (actual time=70.201..70.202 rows=1 loops=14)
                                              ->  Nested Loop  (cost=31.910..20883.360 rows=3612 width=4) (actual time=69.713..70.125 rows=200 loops=14)
                                                    ->  Bitmap Heap Scan on uniform alpha  (cost=31.910..2680.770 rows=1501 width=4) (actual time=0.715..3.950 rows=4158 loops=14)
                                                            Recheck Cond: (oscar = four.oscar)
                                                          ->  Bitmap Index Scan on whiskey  (cost=0.000..31.540 rows=1501 width=0) (actual time=0.503..0.503 rows=4158 loops=14)
                                                                  Index Cond: (oscar = four.oscar)bravo
                                                    ->  Index Scan using quebec on zulu_xray juliet_xray  (cost=0.000..11.980 rows=12 width=8) (actual time=0.015..0.015 rows=0 loops=58214)
                                                            Index Cond: (delta_hotel = alpha.delta_hotel)
                                                            Filter: (two >= (papa('six'::text, (zulu_golf() - (four.juliet_sierra)::interval)) + (four.juliet_sierra)::interval))
                                      SubPlan
                                        ->  Aggregate  (cost=9386.390..9386.400 rows=1 width=4) (actual time=5.807..5.807 rows=1 loops=3)
                                              ->  Nested Loop  (cost=31.660..9377.370 rows=3609 width=4) (actual time=0.194..4.670 rows=3275 loops=3)
                                                    ->  Bitmap Heap Scan on uniform alpha  (cost=31.660..2699.290 rows=500 width=4) (actual time=0.181..0.216 rows=0 loops=3)
                                                            Recheck Cond: (oscar = four.oscar)
                                                            Filter: (delta_sierra >= (zulu_golf() - ((lima(four.three_tango, 0))::double precision * 'november'::interval)))
                                                          ->  Bitmap Index Scan on whiskey  (cost=0.000..31.540 rows=1501 width=0) (actual time=0.031..0.031 rows=201 loops=3)
                                                                  Index Cond: (oscar = four.oscar)
                                                    ->  Index Scan using quebec on zulu_xray juliet_xray  (cost=0.000..12.890 rows=37 width=8) (actual time=0.014..6.493 rows=9826 loops=1)
                                                            Index Cond: (delta_hotel = alpha.delta_hotel)
                                      SubPlan
                                        ->  Aggregate  (cost=20892.390..20892.400 rows=1 width=4) (actual time=59.898..59.898 rows=1 loops=17)
                                              ->  Nested Loop  (cost=31.910..20883.360 rows=3612 width=4) (actual time=59.499..59.835 rows=165 loops=17)
                                                    ->  Bitmap Heap Scan on uniform alpha  (cost=31.910..2680.770 rows=1501 width=4) (actual time=0.593..3.265 rows=3460 loops=17)
                                                            Recheck Cond: (oscar = four.oscar)
                                                          ->  Bitmap Index Scan on whiskey  (cost=0.000..31.540 rows=1501 width=0) (actual time=0.418..0.418 rows=3460 loops=17)
                                                                  Index Cond: (oscar = four.oscar)
                                                    ->  Index Scan using quebec on zulu_xray juliet_xray  (cost=0.000..11.980 rows=12 width=8) (actual time=0.015..0.015 rows=0 loops=58817)
                                                            Index Cond: (delta_hotel = alpha.delta_hotel)
                                                            Filter: (two >= (papa('six'::text, (zulu_golf() - (four.juliet_sierra)::interval)) + (four.juliet_sierra)::interval))
                                      SubPlan
                                        ->  Aggregate  (cost=9386.390..9386.400 rows=1 width=4) (actual time=4.519..4.519 rows=1 loops=17)
                                              ->  Nested Loop  (cost=31.660..9377.370 rows=3609 width=4) (actual time=3.520..4.311 rows=578 loops=17)
                                                    ->  Bitmap Heap Scan on uniform alpha  (cost=31.660..2699.290 rows=500 width=4) (actual time=3.506..3.512 rows=0 loops=17)
                                                            Recheck Cond: (oscar = four.oscar)
                                                            Filter: (delta_sierra >= (zulu_golf() - ((lima(four.three_tango, 0))::double precision * 'november'::interval)))
                                                          ->  Bitmap Index Scan on whiskey  (cost=0.000..31.540 rows=1501 width=0) (actual time=0.420..0.420 rows=3460 loops=17)
                                                                  Index Cond: (oscar = four.oscar)
                                                    ->  Index Scan using quebec on zulu_xray juliet_xray  (cost=0.000..12.890 rows=37 width=8) (actual time=0.014..6.560 rows=9826 loops=1)
                                                            Index Cond: (delta_hotel = alpha.delta_hotel)

Per node type stats

node type	count	sum of times	% of query
Aggregate	5	10.167 ms	0.3 %
Bitmap Heap Scan	5	198.294 ms	6.3 %
Bitmap Index Scan	5	28.487 ms	0.9 %
Index Scan	5	2709.590 ms	86.6 %
Limit	1	0.003 ms	0.0 %
Nested Loop	5	180.870 ms	5.8 %
Seq Scan	1	0.170 ms	0.0 %
Sort	2	0.103 ms	0.0 %
Subquery Scan on sq2	1	0.029 ms	0.0 %
Subquery Scan on sq3	1	0.024 ms	0.0 %
WindowAgg	3	0.788 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
three_five	1	0.170 ms	0.0 %
Seq Scan	1	0.170 ms	100.0 %
uniform	5	198.294 ms	6.3 %
Bitmap Heap Scan	5	198.294 ms	100.0 %
zulu_xray	5	2709.590 ms	86.6 %
Index Scan	5	2709.590 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: GWC

Colorize:

Columns visibility:

Per node type stats

Per table stats