explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DZkN

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 8,847.607 ↑ 1.2 887 1

Finalize GroupAggregate (cost=399,040.29..399,866.76 rows=1,088 width=82) (actual time=8,834.701..8,847.607 rows=887 loops=1)

  • Group Key: staging_radarview_profileclass.type, staging_radarview_profileclass.attr1, staging_radarview_profileclass.attr2, staging_radarview_profileclass.attr3, staging_radarview_profileclass.attr4, staging_radarview_profileclass.attr5, staging_radarview_profileclass.attr6, staging_radarview_profileclass.name
2. 91.754 8,916.812 ↑ 1.0 5,194 1

Gather Merge (cost=399,040.29..399,698.12 rows=5,440 width=154) (actual time=8,834.664..8,916.812 rows=5,194 loops=1)

  • Workers Planned: 5
  • Workers Launched: 5
3. 4.692 8,825.058 ↑ 1.3 866 6 / 6

Sort (cost=398,040.21..398,042.93 rows=1,088 width=154) (actual time=8,824.926..8,825.058 rows=866 loops=6)

  • Sort Key: staging_radarview_profileclass.type, staging_radarview_profileclass.attr1, staging_radarview_profileclass.attr2, staging_radarview_profileclass.attr3, staging_radarview_profileclass.attr4, staging_radarview_profileclass.attr5, staging_radarview_profileclass.attr6, staging_radarview_profileclass.name
  • Sort Method: quicksort Memory: 255kB
  • Worker 0: Sort Method: quicksort Memory: 255kB
  • Worker 1: Sort Method: quicksort Memory: 254kB
  • Worker 2: Sort Method: quicksort Memory: 253kB
  • Worker 3: Sort Method: quicksort Memory: 255kB
  • Worker 4: Sort Method: quicksort Memory: 254kB
4. 3,376.025 8,820.366 ↑ 1.3 866 6 / 6

Partial HashAggregate (cost=397,974.46..397,985.34 rows=1,088 width=154) (actual time=8,819.528..8,820.366 rows=866 loops=6)

  • Group Key: staging_radarview_profileclass.type, staging_radarview_profileclass.attr1, staging_radarview_profileclass.attr2, staging_radarview_profileclass.attr3, staging_radarview_profileclass.attr4, staging_radarview_profileclass.attr5, staging_radarview_profileclass.attr6, staging_radarview_profileclass.name
5. 2,089.797 5,444.341 ↑ 1.2 2,971,422 6 / 6

Hash Join (cost=10,027.17..295,920.11 rows=3,711,067 width=82) (actual time=190.554..5,444.341 rows=2,971,422 loops=6)

  • Hash Cond: (staging_radarview_profiledata_es_2020_04.asset_id = u0.cartodb_id)
6. 1,654.338 3,165.647 ↑ 1.2 3,092,409 6 / 6

Hash Join (cost=47.06..276,197.52 rows=3,711,067 width=86) (actual time=1.209..3,165.647 rows=3,092,409 loops=6)

  • Hash Cond: (staging_radarview_profiledata_es_2020_04.clazz_id = staging_radarview_profileclass.id)
7. 1,510.167 1,510.167 ↑ 1.2 3,092,409 6 / 6

Parallel Seq Scan on staging_radarview_profiledata_es_2020_04 (cost=0.00..266,378.00 rows=3,711,067 width=32) (actual time=0.032..1,510.167 rows=3,092,409 loops=6)

  • Filter: ((week = 4) AND (year = 2,020))
8. 0.594 1.142 ↓ 1.0 1,341 6 / 6

Hash (cost=30.36..30.36 rows=1,336 width=62) (actual time=1.141..1.142 rows=1,341 loops=6)

  • Buckets: 2,048 Batches: 1 Memory Usage: 147kB
9. 0.548 0.548 ↓ 1.0 1,341 6 / 6

Seq Scan on staging_radarview_profileclass (cost=0.00..30.36 rows=1,336 width=62) (actual time=0.035..0.548 rows=1,341 loops=6)

10. 14.925 188.897 ↓ 1.2 52,789 6 / 6

Hash (cost=9,427.22..9,427.22 rows=44,231 width=4) (actual time=188.897..188.897 rows=52,789 loops=6)

  • Buckets: 65,536 Batches: 1 Memory Usage: 2,368kB
11. 46.453 173.972 ↓ 1.2 52,789 6 / 6

HashAggregate (cost=8,542.60..8,984.91 rows=44,231 width=4) (actual time=158.184..173.972 rows=52,789 loops=6)

  • Group Key: u0.cartodb_id
12. 34.002 127.519 ↓ 1.2 52,789 6 / 6

Hash Join (cost=6,356.76..8,432.03 rows=44,231 width=4) (actual time=72.494..127.519 rows=52,789 loops=6)

  • Hash Cond: (u1.asset_id = u0.cartodb_id)
13. 21.964 21.964 ↓ 1.2 55,172 6 / 6

Seq Scan on staging_radarview_asset_countries u1 (cost=0.00..1,950.17 rows=47,652 width=4) (actual time=0.037..21.964 rows=55,172 loops=6)

  • Filter: ((country_id = 194) OR (country_id = 198))
  • Rows Removed by Filter: 40,373
14. 29.457 71.553 ↑ 1.0 90,461 6 / 6

Hash (cost=5,225.24..5,225.24 rows=90,522 width=4) (actual time=71.552..71.553 rows=90,461 loops=6)

  • Buckets: 131,072 Batches: 1 Memory Usage: 4,205kB
15. 42.096 42.096 ↑ 1.0 90,461 6 / 6

Seq Scan on staging_radarview_asset u0 (cost=0.00..5,225.24 rows=90,522 width=4) (actual time=0.025..42.096 rows=90,461 loops=6)

  • Filter: (NOT is_digital)
  • Rows Removed by Filter: 7,063