#	exclusive	inclusive	rows x	rows	loops	node
1.	0.262	22112.308	↑ 1.0	1	1	→ Unique (cost=932495.000..932514.790 rows=1 width=40) (actual time=22111.958..22112.308 rows=1 loops=1)
2.	4.039	22112.046	↑ 2.0	1333	1	→ Sort (cost=932495.000..932501.590 rows=2639 width=40) (actual time=22111.957..22112.046 rows=1333 loops=1) Sort Key: five_sierra0kilo_oscar.echo, five_sierra0kilo_oscar.quebec Sort Method: quicksort Memory: 153kB
3.	0.210	22108.007	↑ 2.0	1333	1	→ Nested Loop (cost=0.000..932345.030 rows=2639 width=40) (actual time=21647.238..22108.007 rows=1333 loops=1)
4.	0.003	22107.547	↑ 1.0	1	1	→ Nested Loop (cost=0.000..932190.250 rows=1 width=40) (actual time=21647.233..22107.547 rows=1 loops=1)
5.	0.003	22107.507	↑ 1.0	1	1	→ Nested Loop (cost=0.000..932185.970 rows=1 width=48) (actual time=21647.194..22107.507 rows=1 loops=1)
6.	6.275	22107.458	↑ 1.0	1	1	→ Nested Loop (cost=0.000..932185.440 rows=1 width=64) (actual time=21647.147..22107.458 rows=1 loops=1)
7.	676.485	22061.256	↓ 831.8	13309	1	→ Nested Loop (cost=0.000..932180.730 rows=16 width=48) (actual time=0.087..22061.256 rows=13309 loops=1) Join Filter: (five_sierra0kilo_oscar.xray = papa5kilo_oscar.xray)
8.	4.527	4.527	↓ 1187.0	1187	1	→ Seq Scan on four_xray romeo_two (cost=0.000..177.870 rows=1 width=48) (actual time=0.017..4.527 rows=1187 loops=1) Filter: ((tango five_romeo NULL) AND ((juliet)::text = 'victor_delta'::text) AND (victor_alpha = ANY ('alpha_two'::bigint[])))
9.	5047.124	21380.244	↓ 1.1	3438	1187	→ Seq Scan on kilo_romeo two_victor (cost=0.000..931962.990 rows=3190 width=16) (actual time=0.014..18.012 rows=3438 loops=1187) Filter: ((two_tango) > 0)
10.						SubPlan (forSeq Scan)
11.	4083.280	16333.120	↑ 1.0	1	4083280	→ Aggregate (cost=97.350..97.360 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=4083280)
12.	4083.280	12249.840	↑ 37.0	3	4083280	→ Bitmap Heap Scan on four_lima mike (cost=3.110..97.070 rows=111 width=8) (actual time=0.003..0.003 rows=3 loops=4083280) Recheck Cond: ($0 = yankee)
13.	8166.560	8166.560	↑ 37.0	3	4083280	→ Bitmap Index Scan on seven_hotel (cost=0.000..3.080 rows=111 width=0) (actual time=0.002..0.002 rows=3 loops=4083280) Index Cond: ($0 = yankee)
14.	39.927	39.927	↓ 0.0	0	13309	→ Index Scan using six on india_five india_three (cost=0.000..0.280 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=13309) Index Cond: ((alpha_november3kilo_oscar.romeo_four = 413) AND (alpha_november3kilo_oscar.whiskey_november = papa5kilo_oscar.whiskey_november))
15.	0.046	0.046	↑ 1.0	1	1	→ Index Scan using november on alpha_november foxtrot (cost=0.000..0.520 rows=1 width=8) (actual time=0.045..0.046 rows=1 loops=1) Index Cond: (romeo_xray4kilo_oscar.quebec = alpha_november3kilo_oscar.whiskey_november)
16.	0.037	0.037	↑ 1.0	1	1	→ Index Scan using whiskey_delta on golf_juliet two_charlie (cost=0.000..4.270 rows=1 width=8) (actual time=0.036..0.037 rows=1 loops=1) Index Cond: (golf_yankee2kilo_oscar.quebec = 413)
17.	0.250	0.250	↑ 2.0	1333	1	→ Seq Scan on four_xray seven_four (cost=0.000..128.390 rows=2639 width=0) (actual time=0.002..0.250 rows=1333 loops=1)

Unique  (cost=932495.000..932514.790 rows=1 width=40) (actual time=22111.958..22112.308 rows=1 loops=1)
  ->  Sort  (cost=932495.000..932501.590 rows=2639 width=40) (actual time=22111.957..22112.046 rows=1333 loops=1)
          Sort Key: five_sierra0kilo_oscar.echo, five_sierra0kilo_oscar.quebec
          Sort Method:  quicksort  Memory: 153kB
        ->  Nested Loop  (cost=0.000..932345.030 rows=2639 width=40) (actual time=21647.238..22108.007 rows=1333 loops=1)
              ->  Nested Loop  (cost=0.000..932190.250 rows=1 width=40) (actual time=21647.233..22107.547 rows=1 loops=1)
                    ->  Nested Loop  (cost=0.000..932185.970 rows=1 width=48) (actual time=21647.194..22107.507 rows=1 loops=1)
                          ->  Nested Loop  (cost=0.000..932185.440 rows=1 width=64) (actual time=21647.147..22107.458 rows=1 loops=1)
                                ->  Nested Loop  (cost=0.000..932180.730 rows=16 width=48) (actual time=0.087..22061.256 rows=13309 loops=1)
                                        Join Filter: (five_sierra0kilo_oscar.xray = papa5kilo_oscar.xray)
                                      ->  Seq Scan on four_xray romeo_two  (cost=0.000..177.870 rows=1 width=48) (actual time=0.017..4.527 rows=1187 loops=1)
                                              Filter: ((tango five_romeo NULL) AND ((juliet)::text = 'victor_delta'::text) AND (victor_alpha = ANY ('alpha_two'::bigint[])))
                                      ->  Seq Scan on kilo_romeo two_victor  (cost=0.000..931962.990 rows=3190 width=16) (actual time=0.014..18.012 rows=3438 loops=1187)
                                              Filter: ((two_tango) > 0)
                                            SubPlan
                                              ->  Aggregate  (cost=97.350..97.360 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=4083280)
                                                    ->  Bitmap Heap Scan on four_lima mike  (cost=3.110..97.070 rows=111 width=8) (actual time=0.003..0.003 rows=3 loops=4083280)
                                                            Recheck Cond: ($0 = yankee)
                                                          ->  Bitmap Index Scan on seven_hotel  (cost=0.000..3.080 rows=111 width=0) (actual time=0.002..0.002 rows=3 loops=4083280)
                                                                  Index Cond: ($0 = yankee)
                                ->  Index Scan using six on india_five india_three  (cost=0.000..0.280 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=13309)
                                        Index Cond: ((alpha_november3kilo_oscar.romeo_four = 413) AND (alpha_november3kilo_oscar.whiskey_november = papa5kilo_oscar.whiskey_november))
                          ->  Index Scan using november on alpha_november foxtrot  (cost=0.000..0.520 rows=1 width=8) (actual time=0.045..0.046 rows=1 loops=1)
                                  Index Cond: (romeo_xray4kilo_oscar.quebec = alpha_november3kilo_oscar.whiskey_november)
                    ->  Index Scan using whiskey_delta on golf_juliet two_charlie  (cost=0.000..4.270 rows=1 width=8) (actual time=0.036..0.037 rows=1 loops=1)
                            Index Cond: (golf_yankee2kilo_oscar.quebec = 413)
              ->  Seq Scan on four_xray seven_four  (cost=0.000..128.390 rows=2639 width=0) (actual time=0.002..0.250 rows=1333 loops=1)

Per node type stats

node type	count	sum of times	% of query
Aggregate	1	4083.280 ms	18.5 %
Bitmap Heap Scan	1	4083.280 ms	18.5 %
Bitmap Index Scan	1	8166.560 ms	36.9 %
Index Scan	3	40.010 ms	0.2 %
Nested Loop	5	682.976 ms	3.1 %
Seq Scan	3	5051.901 ms	22.8 %
Sort	1	4.039 ms	0.0 %
Unique	1	0.262 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
alpha_november	1	0.046 ms	0.0 %
Index Scan	1	0.046 ms	100.0 %
four_lima	1	4083.280 ms	18.5 %
Bitmap Heap Scan	1	4083.280 ms	100.0 %
four_xray	2	4.777 ms	0.0 %
Seq Scan	2	4.777 ms	100.0 %
golf_juliet	1	0.037 ms	0.0 %
Index Scan	1	0.037 ms	100.0 %
india_five	1	39.927 ms	0.2 %
Index Scan	1	39.927 ms	100.0 %
kilo_romeo	1	5047.124 ms	22.8 %
Seq Scan	1	5047.124 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: rEK

Colorize:

Columns visibility:

Per node type stats

Per table stats