explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BWwc

Settings
# exclusive inclusive rows x rows loops node
1. 33.114 8,703.132 ↑ 6.6 80,010 1

Gather (cost=1,334.00..225,160.47 rows=526,419 width=78) (actual time=26.238..8,703.132 rows=80,010 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 4,531.509 8,670.018 ↑ 8.2 26,670 3

Hash Join (cost=334.00..171,518.57 rows=219,341 width=78) (actual time=26.512..8,670.018 rows=26,670 loops=3)

  • Hash Cond: ((a.alias = yo.key) AND (a.value = yo.val))
3. 4,112.511 4,112.511 ↑ 1.2 3,376,419 3

Parallel Seq Scan on syn_observation_observed_item_id_ref a (cost=0.00..137,337.23 rows=4,220,523 width=43) (actual time=0.010..4,112.511 rows=3,376,419 loops=3)

4. 13.467 25.998 ↑ 1.0 10,000 3

Hash (cost=184.00..184.00 rows=10,000 width=35) (actual time=25.997..25.998 rows=10,000 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 832kB
5. 12.531 12.531 ↑ 1.0 10,000 3

Seq Scan on composite_key_components yo (cost=0.00..184.00 rows=10,000 width=35) (actual time=0.023..12.531 rows=10,000 loops=3)

Planning time : 0.310 ms
Execution time : 8,797.678 ms