explain.depesz.com

A tool for finding a real cause for slow queries.

Result: QsX

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# 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)