explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ebSU

Settings
# exclusive inclusive rows x rows loops node
1. 2,185.162 2,293.748 ↑ 1.0 20,991 1

Hash Join (cost=122.56..79,994.25 rows=21,077 width=684) (actual time=2.255..2,293.748 rows=20,991 loops=1)

  • Hash Cond: (d.impact_score = ei.impact_score)
2. 18.504 108.575 ↑ 1.0 20,991 1

Hash Join (cost=104.91..52,889.34 rows=21,077 width=405) (actual time=1.618..108.575 rows=20,991 loops=1)

  • Hash Cond: (d.responsible_org_orgref = resporg.swa_org_ref)
3. 27.059 89.251 ↑ 1.0 20,991 1

Hash Join (cost=52.45..52,781.38 rows=21,077 width=383) (actual time=0.793..89.251 rows=20,991 loops=1)

  • Hash Cond: (d.publisher_orgref = publisher.swa_org_ref)
4. 61.410 61.410 ↑ 1.0 20,991 1

Seq Scan on entity_eton_agg d (cost=0.00..52,673.42 rows=21,077 width=361) (actual time=0.003..61.410 rows=20,991 loops=1)

  • Filter: (active AND (works_state = ANY ('{0,2,3,4,5,6,7,8}'::integer[])))
  • Rows Removed by Filter: 13792
5. 0.388 0.782 ↑ 1.0 1,309 1

Hash (cost=36.09..36.09 rows=1,309 width=26) (actual time=0.782..0.782 rows=1,309 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 82kB
6. 0.394 0.394 ↑ 1.0 1,309 1

Seq Scan on orgref publisher (cost=0.00..36.09 rows=1,309 width=26) (actual time=0.002..0.394 rows=1,309 loops=1)

7. 0.388 0.820 ↑ 1.0 1,309 1

Hash (cost=36.09..36.09 rows=1,309 width=26) (actual time=0.820..0.820 rows=1,309 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 82kB
8. 0.432 0.432 ↑ 1.0 1,309 1

Seq Scan on orgref resporg (cost=0.00..36.09 rows=1,309 width=26) (actual time=0.002..0.432 rows=1,309 loops=1)

9. 0.004 0.011 ↑ 68.0 5 1

Hash (cost=13.40..13.40 rows=340 width=92) (actual time=0.011..0.011 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
10. 0.007 0.007 ↑ 68.0 5 1

Seq Scan on eton_impact ei (cost=0.00..13.40 rows=340 width=92) (actual time=0.004..0.007 rows=5 loops=1)