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 11,937.995 ↓ 2.5 80 1

Sort (cost=113,153.83..113,153.91 rows=32 width=68) (actual time=11,937.985..11,937.995 rows=80 loops=1)

  • Sort Key: dwm.week_date
  • Sort Method: quicksort Memory: 46kB
2. 7,033.762 11,937.805 ↓ 2.5 80 1

HashAggregate (cost=113,152.55..113,153.03 rows=32 width=68) (actual time=11,461.256..11,937.805 rows=80 loops=1)

3. 1,273.356 4,904.043 ↓ 25.9 2,251,404 1

Hash Join (cost=839.38..109,244.66 rows=86,842 width=68) (actual time=16.404..4,904.043 rows=2,251,404 loops=1)

  • Hash Cond: (ad.plan_dep_date = dwm.day_date)
4. 1,423.563 3,630.378 ↓ 25.9 2,251,404 1

Hash Join (cost=825.52..108,036.73 rows=86,842 width=68) (actual time=16.088..3,630.378 rows=2,251,404 loops=1)

  • Hash Cond: (ad.dipla_city_code = cr_dipla.city_code)
5. 1,620.919 2,191.287 ↓ 16.1 1,717,382 1

Hash Join (cost=158.47..103,306.31 rows=106,498 width=70) (actual time=0.522..2,191.287 rows=1,717,382 loops=1)

  • Hash Cond: (ad.lopfi_city_code = cr_lopfi.city_code)
6. 569.909 569.909 ↑ 1.0 3,504,621 1

Seq Scan on aggregated_demands ad (cost=0.00..75,798.21 rows=3,504,621 width=72) (actual time=0.003..569.909 rows=3,504,621 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 15,024 1

Hash (cost=480.01..480.01 rows=14,964 width=10) (actual time=15.528..15.528 rows=15,024 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 617kB
10. 9.735 9.735 ↓ 1.0 15,024 1

Index Scan using region_code_idx on city_country_cluster_region cr_dipla (cost=0.00..480.01 rows=14,964 width=10) (actual time=0.015..9.735 rows=15,024 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)