#	exclusive	inclusive	rows x	rows	loops	node
1.	200.269	23459.387	↓ 114657.0	114657	1	→ Unique (cost=77379.380..77379.520 rows=1 width=271) (actual time=23150.292..23459.387 rows=114657 loops=1)
2.	533.190	23259.118	↓ 114657.0	114657	1	→ Sort (cost=77379.380..77379.380 rows=1 width=271) (actual time=23150.289..23259.118 rows=114657 loops=1) Sort Key: romeo_xray.quebec_seven, juliet.sierra_charlie, juliet.quebec_two, juliet.golf_foxtrot_xray, juliet.tango_charlie, alpha_whiskey.two_uniform, seven_november.four_yankee, india_whiskey.two_five, six_whiskey.india_papa, (mike_zulu((charlie_four.india_delta)::text)), mike_hotel.hotel_charlie.zulu_alpha, mike_hotel.hotel_charlie.sierra_kilo_foxtrot, romeo_xray.foxtrot_kilo, romeo_xray.romeo_victor, romeo_xray.kilo_quebec, romeo_xray.three_two, juliet.charlie_alpha, romeo_xray.xray, romeo_xray.romeo_six, three_echo.echo_sierra, three_echo.romeo_tango, golf_romeo.six_lima_zulu, seven_november.romeo_romeo, papa_lima.quebec_seven, papa_lima.romeo_papa, papa_lima.kilo_juliet, papa_lima.november_romeo2, papa_lima.mike_three, papa_lima.six_lima_xray, papa_lima.sierra_kilo_echo, papa_lima.six_delta, papa_lima.papa_zulu, papa_lima.november_uniform, papa_lima.foxtrot_juliet, papa_lima.two_zulu, papa_lima.six_sierra, papa_lima.tango_uniform, papa_lima.sierra_uniform, papa_lima.lima_echo, papa_lima.uniform_zulu, papa_lima.victor, papa_lima.alpha_foxtrot, papa_lima.seven_quebec, papa_lima.kilo_two, papa_lima.sierra_lima, papa_lima.three_zulu, papa_lima.hotel_xray, papa_lima.uniform_november, papa_lima.uniform_delta, papa_lima.hotel_bravo, papa_lima.three_whiskey, papa_lima.bravo_charlie, papa_lima.seven_sierra, papa_lima.lima_sierra Sort Method: external merge Disk: 19192kB
3.	2405.894	22725.928	↓ 114657.0	114657	1	→ HashAggregate (cost=77379.350..77379.370 rows=1 width=271) (actual time=22383.609..22725.928 rows=114657 loops=1)
4.	131.662	20320.034	↓ 123963.0	123963	1	→ Nested Loop (cost=68010.340..77379.220 rows=1 width=271) (actual time=15454.506..20320.034 rows=123963 loops=1)
5.	202.874	19390.906	↓ 132911.0	132911	1	→ Nested Loop (cost=68010.340..77374.910 rows=1 width=279) (actual time=15454.474..19390.906 rows=132911 loops=1)
6.	204.594	18644.780	↓ 135813.0	135813	1	→ Nested Loop (cost=68010.340..77370.620 rows=1 width=271) (actual time=15454.434..18644.780 rows=135813 loops=1)
7.	207.032	17896.934	↓ 135813.0	135813	1	→ Nested Loop (cost=68010.340..77370.280 rows=1 width=258) (actual time=15454.359..17896.934 rows=135813 loops=1)
8.	1166.798	17177.446	↓ 128114.0	128114	1	→ Hash Join (cost=68010.340..77369.980 rows=1 width=258) (actual time=15454.261..17177.446 rows=128114 loops=1) Hash Cond: (seven_november.mike_kilo = golf_romeo.mike_kilo)
9.	471.733	765.258	↑ 1.0	199579	1	→ Hash Join (cost=6379.530..14990.740 rows=199579 width=57) (actual time=208.786..765.258 rows=199579 loops=1) Hash Cond: (juliet.quebec_seven = seven_november.mike_kilo)
10.	85.367	85.367	↑ 1.0	202021	1	→ Seq Scan on juliet (cost=0.000..4595.210 rows=202021 width=44) (actual time=0.016..85.367 rows=202021 loops=1)
11.	111.487	208.158	↑ 1.0	199579	1	→ Hash (cost=3884.790..3884.790 rows=199579 width=13) (actual time=208.158..208.158 rows=199579 loops=1)
12.	96.671	96.671	↑ 1.0	199579	1	→ Seq Scan on seven_november (cost=0.000..3884.790 rows=199579 width=13) (actual time=0.026..96.671 rows=199579 loops=1)
13.	325.616	15245.390	↓ 128114.0	128114	1	→ Hash (cost=61630.800..61630.800 rows=1 width=217) (actual time=15245.390..15245.390 rows=128114 loops=1)
14.	355.938	14919.774	↓ 128114.0	128114	1	→ Nested Loop (cost=37946.220..61630.800 rows=1 width=217) (actual time=1704.229..14919.774 rows=128114 loops=1)
15.	260.907	13677.780	↓ 295352.0	295352	1	→ Nested Loop (cost=37946.220..61630.500 rows=1 width=211) (actual time=1703.730..13677.780 rows=295352 loops=1)
16.	324.129	11940.113	↓ 295352.0	295352	1	→ Nested Loop (cost=37946.220..61630.200 rows=1 width=211) (actual time=1703.666..11940.113 rows=295352 loops=1)
17.	6641.716	9843.884	↓ 295350.0	295350	1	→ Hash Join (cost=37946.220..61629.900 rows=1 width=203) (actual time=1703.534..9843.884 rows=295350 loops=1) Hash Cond: (romeo_xray.quebec_seven = mike_hotel.hotel_charlie.romeo_papa)
18.	1228.297	1584.378	↓ 1.0	575693	1	→ Hash Left Join (cost=1402.920..22927.810 rows=575674 width=179) (actual time=85.483..1584.378 rows=575693 loops=1) Hash Cond: (romeo_xray.quebec_seven = papa_lima.romeo_papa)
19.	270.722	270.722	↑ 1.0	575674	1	→ Seq Scan on romeo_xray (cost=0.000..13246.740 rows=575674 width=54) (actual time=0.048..270.722 rows=575674 loops=1)
20.	46.417	85.359	↑ 1.0	36263	1	→ Hash (cost=949.630..949.630 rows=36263 width=125) (actual time=85.359..85.359 rows=36263 loops=1)
21.	38.942	38.942	↑ 1.0	36263	1	→ Seq Scan on papa_lima (cost=0.000..949.630 rows=36263 width=125) (actual time=0.023..38.942 rows=36263 loops=1)
22.	274.554	1617.790	↓ 295331.0	295331	1	→ Hash (cost=36543.290..36543.290 rows=1 width=24) (actual time=1617.790..1617.790 rows=295331 loops=1)
23.	614.136	1343.236	↓ 295331.0	295331	1	→ Hash Join (cost=23069.580..36543.290 rows=1 width=24) (actual time=640.336..1343.236 rows=295331 loops=1) Hash Cond: ((mike_hotel.hotel_charlie.romeo_papa = mike_hotel.hotel_charlie.romeo_papa) AND (mike_hotel.hotel_charlie.quebec_seven = (alpha_four(mike_hotel.hotel_charlie.quebec_seven))))
24.	89.307	89.307	↑ 1.0	295592	1	→ Seq Scan on hotel_charlie (cost=0.000..5344.920 rows=295592 width=24) (actual time=0.018..89.307 rows=295592 loops=1)
25.	158.840	639.793	↑ 1.0	295331	1	→ Hash (cost=18635.700..18635.700 rows=295592 width=8) (actual time=639.793..639.793 rows=295331 loops=1)
26.	218.691	480.953	↑ 1.0	295331	1	→ GroupAggregate (cost=0.000..15679.780 rows=295592 width=8) (actual time=0.062..480.953 rows=295331 loops=1)
27.	262.262	262.262	↑ 1.0	295592	1	→ Index Scan using yankee on hotel_charlie (cost=0.000..10506.920 rows=295592 width=8) (actual time=0.038..262.262 rows=295592 loops=1)
28.	1772.100	1772.100	↑ 1.0	1	295350	→ Index Scan using zulu_hotel on delta (cost=0.000..0.290 rows=1 width=8) (actual time=0.005..0.006 rows=1 loops=295350) Index Cond: ((delta.romeo_two = romeo_xray.romeo_two) AND (delta.bravo_november = 'zulu_five'::bpchar))
29.	1476.760	1476.760	↑ 1.0	1	295352	→ Index Scan using echo_victor on golf_romeo (cost=0.000..0.280 rows=1 width=12) (actual time=0.004..0.005 rows=1 loops=295352) Index Cond: (golf_romeo.quebec_seven = romeo_xray.romeo_two)
30.	886.056	886.056	↓ 0.0	0	295352	→ Index Scan using kilo_november on alpha_whiskey (cost=0.000..0.290 rows=1 width=6) (actual time=0.003..0.003 rows=0 loops=295352) Index Cond: (alpha_whiskey.mike_kilo = golf_romeo.mike_kilo) Filter: (alpha_whiskey.two_uniform = ANY ('whiskey'::bpchar[]))
31.	512.456	512.456	↑ 1.0	1	128114	→ Index Scan using quebec_charlie on charlie_four (cost=0.000..0.280 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=128114) Index Cond: (charlie_four.november_bravo = seven_november.quebec_seven)
32.	543.252	543.252	↑ 1.0	1	135813	→ Index Scan using quebec_victor on three_echo (cost=0.000..0.330 rows=1 width=21) (actual time=0.004..0.004 rows=1 loops=135813) Index Cond: (three_echo.quebec_seven = delta.four_sierra)
33.	543.252	543.252	↑ 1.0	1	135813	→ Index Scan using golf_foxtrot_two on india_whiskey (cost=0.000..4.280 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=135813) Index Cond: (india_whiskey.romeo_papa = romeo_xray.quebec_seven)
34.	797.466	797.466	↑ 1.0	1	132911	→ Index Scan using quebec_papa on six_whiskey (cost=0.000..4.300 rows=1 width=8) (actual time=0.005..0.006 rows=1 loops=132911) Index Cond: ((six_whiskey.romeo_papa = romeo_xray.quebec_seven) AND (six_whiskey.bravo_romeo = 'kilo_zulu'::bpchar))

Unique  (cost=77379.380..77379.520 rows=1 width=271) (actual time=23150.292..23459.387 rows=114657 loops=1)
  ->  Sort  (cost=77379.380..77379.380 rows=1 width=271) (actual time=23150.289..23259.118 rows=114657 loops=1)
          Sort Key: romeo_xray.quebec_seven, juliet.sierra_charlie, juliet.quebec_two, juliet.golf_foxtrot_xray, juliet.tango_charlie, alpha_whiskey.two_uniform, seven_november.four_yankee, india_whiskey.two_five, six_whiskey.india_papa, (mike_zulu((charlie_four.india_delta)::text)), mike_hotel.hotel_charlie.zulu_alpha, mike_hotel.hotel_charlie.sierra_kilo_foxtrot, romeo_xray.foxtrot_kilo, romeo_xray.romeo_victor, romeo_xray.kilo_quebec, romeo_xray.three_two, juliet.charlie_alpha, romeo_xray.xray, romeo_xray.romeo_six, three_echo.echo_sierra, three_echo.romeo_tango, golf_romeo.six_lima_zulu, seven_november.romeo_romeo, papa_lima.quebec_seven, papa_lima.romeo_papa, papa_lima.kilo_juliet, papa_lima.november_romeo2, papa_lima.mike_three, papa_lima.six_lima_xray, papa_lima.sierra_kilo_echo, papa_lima.six_delta, papa_lima.papa_zulu, papa_lima.november_uniform, papa_lima.foxtrot_juliet, papa_lima.two_zulu, papa_lima.six_sierra, papa_lima.tango_uniform, papa_lima.sierra_uniform, papa_lima.lima_echo, papa_lima.uniform_zulu, papa_lima.victor, papa_lima.alpha_foxtrot, papa_lima.seven_quebec, papa_lima.kilo_two, papa_lima.sierra_lima, papa_lima.three_zulu, papa_lima.hotel_xray, papa_lima.uniform_november, papa_lima.uniform_delta, papa_lima.hotel_bravo, papa_lima.three_whiskey, papa_lima.bravo_charlie, papa_lima.seven_sierra, papa_lima.lima_sierra
          Sort Method:  external merge  Disk: 19192kB
        ->  HashAggregate  (cost=77379.350..77379.370 rows=1 width=271) (actual time=22383.609..22725.928 rows=114657 loops=1)
              ->  Nested Loop  (cost=68010.340..77379.220 rows=1 width=271) (actual time=15454.506..20320.034 rows=123963 loops=1)
                    ->  Nested Loop  (cost=68010.340..77374.910 rows=1 width=279) (actual time=15454.474..19390.906 rows=132911 loops=1)
                          ->  Nested Loop  (cost=68010.340..77370.620 rows=1 width=271) (actual time=15454.434..18644.780 rows=135813 loops=1)
                                ->  Nested Loop  (cost=68010.340..77370.280 rows=1 width=258) (actual time=15454.359..17896.934 rows=135813 loops=1)
                                      ->  Hash Join  (cost=68010.340..77369.980 rows=1 width=258) (actual time=15454.261..17177.446 rows=128114 loops=1)
                                              Hash Cond: (seven_november.mike_kilo = golf_romeo.mike_kilo)
                                            ->  Hash Join  (cost=6379.530..14990.740 rows=199579 width=57) (actual time=208.786..765.258 rows=199579 loops=1)
                                                    Hash Cond: (juliet.quebec_seven = seven_november.mike_kilo)
                                                  ->  Seq Scan on juliet  (cost=0.000..4595.210 rows=202021 width=44) (actual time=0.016..85.367 rows=202021 loops=1)
                                                  ->  Hash  (cost=3884.790..3884.790 rows=199579 width=13) (actual time=208.158..208.158 rows=199579 loops=1)
                                                        ->  Seq Scan on seven_november  (cost=0.000..3884.790 rows=199579 width=13) (actual time=0.026..96.671 rows=199579 loops=1)
                                            ->  Hash  (cost=61630.800..61630.800 rows=1 width=217) (actual time=15245.390..15245.390 rows=128114 loops=1)
                                                  ->  Nested Loop  (cost=37946.220..61630.800 rows=1 width=217) (actual time=1704.229..14919.774 rows=128114 loops=1)
                                                        ->  Nested Loop  (cost=37946.220..61630.500 rows=1 width=211) (actual time=1703.730..13677.780 rows=295352 loops=1)
                                                              ->  Nested Loop  (cost=37946.220..61630.200 rows=1 width=211) (actual time=1703.666..11940.113 rows=295352 loops=1)
                                                                    ->  Hash Join  (cost=37946.220..61629.900 rows=1 width=203) (actual time=1703.534..9843.884 rows=295350 loops=1)
                                                                            Hash Cond: (romeo_xray.quebec_seven = mike_hotel.hotel_charlie.romeo_papa)
                                                                          ->  Hash Left Join  (cost=1402.920..22927.810 rows=575674 width=179) (actual time=85.483..1584.378 rows=575693 loops=1)
                                                                                  Hash Cond: (romeo_xray.quebec_seven = papa_lima.romeo_papa)
                                                                                ->  Seq Scan on romeo_xray  (cost=0.000..13246.740 rows=575674 width=54) (actual time=0.048..270.722 rows=575674 loops=1)
                                                                                ->  Hash  (cost=949.630..949.630 rows=36263 width=125) (actual time=85.359..85.359 rows=36263 loops=1)
                                                                                      ->  Seq Scan on papa_lima  (cost=0.000..949.630 rows=36263 width=125) (actual time=0.023..38.942 rows=36263 loops=1)
                                                                          ->  Hash  (cost=36543.290..36543.290 rows=1 width=24) (actual time=1617.790..1617.790 rows=295331 loops=1)
                                                                                ->  Hash Join  (cost=23069.580..36543.290 rows=1 width=24) (actual time=640.336..1343.236 rows=295331 loops=1)
                                                                                        Hash Cond: ((mike_hotel.hotel_charlie.romeo_papa = mike_hotel.hotel_charlie.romeo_papa) AND (mike_hotel.hotel_charlie.quebec_seven = (alpha_four(mike_hotel.hotel_charlie.quebec_seven))))
                                                                                      ->  Seq Scan on hotel_charlie  (cost=0.000..5344.920 rows=295592 width=24) (actual time=0.018..89.307 rows=295592 loops=1)
                                                                                      ->  Hash  (cost=18635.700..18635.700 rows=295592 width=8) (actual time=639.793..639.793 rows=295331 loops=1)
                                                                                            ->  GroupAggregate  (cost=0.000..15679.780 rows=295592 width=8) (actual time=0.062..480.953 rows=295331 loops=1)
                                                                                                  ->  Index Scan using yankee on hotel_charlie  (cost=0.000..10506.920 rows=295592 width=8) (actual time=0.038..262.262 rows=295592 loops=1)
                                                                    ->  Index Scan using zulu_hotel on delta  (cost=0.000..0.290 rows=1 width=8) (actual time=0.005..0.006 rows=1 loops=295350)
                                                                            Index Cond: ((delta.romeo_two = romeo_xray.romeo_two) AND (delta.bravo_november = 'zulu_five'::bpchar))
                                                              ->  Index Scan using echo_victor on golf_romeo  (cost=0.000..0.280 rows=1 width=12) (actual time=0.004..0.005 rows=1 loops=295352)
                                                                      Index Cond: (golf_romeo.quebec_seven = romeo_xray.romeo_two)
                                                        ->  Index Scan using kilo_november on alpha_whiskey  (cost=0.000..0.290 rows=1 width=6) (actual time=0.003..0.003 rows=0 loops=295352)
                                                                Index Cond: (alpha_whiskey.mike_kilo = golf_romeo.mike_kilo)
                                                                Filter: (alpha_whiskey.two_uniform = ANY ('whiskey'::bpchar[]))
                                      ->  Index Scan using quebec_charlie on charlie_four  (cost=0.000..0.280 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=128114)
                                              Index Cond: (charlie_four.november_bravo = seven_november.quebec_seven)
                                ->  Index Scan using quebec_victor on three_echo  (cost=0.000..0.330 rows=1 width=21) (actual time=0.004..0.004 rows=1 loops=135813)
                                        Index Cond: (three_echo.quebec_seven = delta.four_sierra)
                          ->  Index Scan using golf_foxtrot_two on india_whiskey  (cost=0.000..4.280 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=135813)
                                  Index Cond: (india_whiskey.romeo_papa = romeo_xray.quebec_seven)
                    ->  Index Scan using quebec_papa on six_whiskey  (cost=0.000..4.300 rows=1 width=8) (actual time=0.005..0.006 rows=1 loops=132911)
                            Index Cond: ((six_whiskey.romeo_papa = romeo_xray.quebec_seven) AND (six_whiskey.bravo_romeo = 'kilo_zulu'::bpchar))

Per node type stats

node type	count	sum of times	% of query
GroupAggregate	1	218.691 ms	0.9 %
Hash	5	916.914 ms	3.9 %
Hash Join	4	8894.383 ms	37.9 %
Hash Left Join	1	1228.297 ms	5.2 %
HashAggregate	1	2405.894 ms	10.3 %
Index Scan	8	6793.604 ms	29.0 %
Nested Loop	7	1687.136 ms	7.2 %
Seq Scan	5	581.009 ms	2.5 %
Sort	1	533.190 ms	2.3 %
Unique	1	200.269 ms	0.9 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
alpha_whiskey	1	886.056 ms	3.8 %
Index Scan	1	886.056 ms	100.0 %
charlie_four	1	512.456 ms	2.2 %
Index Scan	1	512.456 ms	100.0 %
delta	1	1772.100 ms	7.6 %
Index Scan	1	1772.100 ms	100.0 %
golf_romeo	1	1476.760 ms	6.3 %
Index Scan	1	1476.760 ms	100.0 %
hotel_charlie	2	351.569 ms	1.5 %
Index Scan	1	262.262 ms	74.6 %
Seq Scan	1	89.307 ms	25.4 %
india_whiskey	1	543.252 ms	2.3 %
Index Scan	1	543.252 ms	100.0 %
juliet	1	85.367 ms	0.4 %
Seq Scan	1	85.367 ms	100.0 %
papa_lima	1	38.942 ms	0.2 %
Seq Scan	1	38.942 ms	100.0 %
romeo_xray	1	270.722 ms	1.2 %
Seq Scan	1	270.722 ms	100.0 %
seven_november	1	96.671 ms	0.4 %
Seq Scan	1	96.671 ms	100.0 %
six_whiskey	1	797.466 ms	3.4 %
Index Scan	1	797.466 ms	100.0 %
three_echo	1	543.252 ms	2.3 %
Index Scan	1	543.252 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 8T8

Colorize:

Columns visibility:

Per node type stats

Per table stats