explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4JmY

Settings
# exclusive inclusive rows x rows loops node
1. 1,735.634 1,820.537 ↑ 1.0 20,991 1

Hash Join (cost=104.91..69,382.09 rows=21,077 width=652) (actual time=2.201..1,820.537 rows=20,991 loops=1)

  • Hash Cond: (d.responsible_org_orgref = resporg.swa_org_ref)
2. 24.631 84.077 ↑ 1.0 20,991 1

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

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

Seq Scan on entity_eton_agg d (cost=0.00..52,673.42 rows=21,077 width=320) (actual time=0.003..58.664 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
4. 0.387 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
5. 0.395 0.395 ↑ 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.395 rows=1,309 loops=1)

6. 0.391 0.826 ↑ 1.0 1,309 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 82kB
7. 0.435 0.435 ↑ 1.0 1,309 1

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