#	exclusive	inclusive	rows x	rows	loops	node
1.	0.190	11937.995	↓ 2.5	80	1	→ Sort (cost=113153.83..113153.91 rows=32 width=68) (actual time=11937.985..11937.995 rows=80 loops=1) Sort Key: dwm.week_date Sort Method: quicksort Memory: 46kB
2.	7033.762	11937.805	↓ 2.5	80	1	→ HashAggregate (cost=113152.55..113153.03 rows=32 width=68) (actual time=11461.256..11937.805 rows=80 loops=1)
3.	1273.356	4904.043	↓ 25.9	2251404	1	→ Hash Join (cost=839.38..109244.66 rows=86842 width=68) (actual time=16.404..4904.043 rows=2251404 loops=1) Hash Cond: (ad.plan_dep_date = dwm.day_date)
4.	1423.563	3630.378	↓ 25.9	2251404	1	→ Hash Join (cost=825.52..108036.73 rows=86842 width=68) (actual time=16.088..3630.378 rows=2251404 loops=1) Hash Cond: (ad.dipla_city_code = cr_dipla.city_code)
5.	1620.919	2191.287	↓ 16.1	1717382	1	→ Hash Join (cost=158.47..103306.31 rows=106498 width=70) (actual time=0.522..2191.287 rows=1717382 loops=1) Hash Cond: (ad.lopfi_city_code = cr_lopfi.city_code)
6.	569.909	569.909	↑ 1.0	3504621	1	→ Seq Scan on aggregated_demands ad (cost=0.00..75798.21 rows=3504621 width=72) (actual time=0.003..569.909 rows=3504621 loops=1)
7.	0.153	0.459	↑ 1.0	447	1	→ Hash (cost=152.77..152.77 rows=456 width=10) (actual time=0.459..0.459 rows=447 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 19kB
8.	0.306	0.306	↑ 1.0	447	1	→ Index Scan using region_code_idx on city_country_cluster_region cr_lopfi (cost=0.00..152.77 rows=456 width=10) (actual time=0.034..0.306 rows=447 loops=1) Index Cond: (region_code = 'APA'::text)
9.	5.793	15.528	↓ 1.0	15024	1	→ Hash (cost=480.01..480.01 rows=14964 width=10) (actual time=15.528..15.528 rows=15024 loops=1) Buckets: 2048 Batches: 1 Memory Usage: 617kB
10.	9.735	9.735	↓ 1.0	15024	1	→ Index Scan using region_code_idx on city_country_cluster_region cr_dipla (cost=0.00..480.01 rows=14964 width=10) (actual time=0.015..9.735 rows=15024 loops=1) Index Cond: (region_code = 'NEU'::text)
11.	0.159	0.309	↑ 1.0	549	1	→ Hash (cost=6.99..6.99 rows=549 width=8) (actual time=0.309..0.309 rows=549 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 22kB
12.	0.150	0.150	↑ 1.0	549	1	→ Seq Scan on day_week_month dwm (cost=0.00..6.99 rows=549 width=8) (actual time=0.009..0.150 rows=549 loops=1)

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Sort  (cost=113153.83..113153.91 rows=32 width=68) (actual time=11937.985..11937.995 rows=80 loops=1)
   Sort Key: dwm.week_date
   Sort Method: quicksort  Memory: 46kB
   ->  HashAggregate  (cost=113152.55..113153.03 rows=32 width=68) (actual time=11461.256..11937.805 rows=80 loops=1)
         ->  Hash Join  (cost=839.38..109244.66 rows=86842 width=68) (actual time=16.404..4904.043 rows=2251404 loops=1)
               Hash Cond: (ad.plan_dep_date = dwm.day_date)
               ->  Hash Join  (cost=825.52..108036.73 rows=86842 width=68) (actual time=16.088..3630.378 rows=2251404 loops=1)
                     Hash Cond: (ad.dipla_city_code = cr_dipla.city_code)
                     ->  Hash Join  (cost=158.47..103306.31 rows=106498 width=70) (actual time=0.522..2191.287 rows=1717382 loops=1)
                           Hash Cond: (ad.lopfi_city_code = cr_lopfi.city_code)
                           ->  Seq Scan on aggregated_demands ad  (cost=0.00..75798.21 rows=3504621 width=72) (actual time=0.003..569.909 rows=3504621 loops=1)
                           ->  Hash  (cost=152.77..152.77 rows=456 width=10) (actual time=0.459..0.459 rows=447 loops=1)
                                 Buckets: 1024  Batches: 1  Memory Usage: 19kB
                                 ->  Index Scan using region_code_idx on city_country_cluster_region cr_lopfi  (cost=0.00..152.77 rows=456 width=10) (actual time=0.034..0.306 rows=447 loops=1)
                                       Index Cond: (region_code = 'APA'::text)
                     ->  Hash  (cost=480.01..480.01 rows=14964 width=10) (actual time=15.528..15.528 rows=15024 loops=1)
                           Buckets: 2048  Batches: 1  Memory Usage: 617kB
                           ->  Index Scan using region_code_idx on city_country_cluster_region cr_dipla  (cost=0.00..480.01 rows=14964 width=10) (actual time=0.015..9.735 rows=15024 loops=1)
                                 Index Cond: (region_code = 'NEU'::text)
               ->  Hash  (cost=6.99..6.99 rows=549 width=8) (actual time=0.309..0.309 rows=549 loops=1)
                     Buckets: 1024  Batches: 1  Memory Usage: 22kB
                     ->  Seq Scan on day_week_month dwm  (cost=0.00..6.99 rows=549 width=8) (actual time=0.009..0.150 rows=549 loops=1)
 Total runtime: 11940.412 ms

Per node type stats

node type	count	sum of times	% of query
Hash	3	6.105 ms	0.1 %
Hash Join	3	4317.838 ms	36.2 %
HashAggregate	1	7033.762 ms	58.9 %
Index Scan	2	10.041 ms	0.1 %
Seq Scan	2	570.059 ms	4.8 %
Sort	1	0.190 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
aggregated_demands	1	569.909 ms	4.8 %
Seq Scan	1	569.909 ms	100.0 %
city_country_cluster_region	2	10.041 ms	0.1 %
Index Scan	2	10.041 ms	100.0 %
day_week_month	1	0.150 ms	0.0 %
Seq Scan	1	0.150 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: QsX

Colorize:

Columns visibility:

Per node type stats

Per table stats