explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WTSL

Settings
# exclusive inclusive rows x rows loops node
1. 23,482.694 24,028.882 ↓ 1.0 135,518 1

Hash Join (cost=2,191.28..368,969.80 rows=134,427 width=1,064) (actual time=12.723..24,028.882 rows=135,518 loops=1)

  • Hash Cond: (d.impact_score = ei.impact_score)
2. 135.042 546.177 ↓ 1.0 135,518 1

Hash Join (cost=2,190.17..195,914.09 rows=134,427 width=783) (actual time=12.018..546.177 rows=135,518 loops=1)

  • Hash Cond: (d.responsible_org_orgref = resporg.swa_org_ref)
3. 204.442 410.316 ↓ 1.0 135,518 1

Hash Join (cost=2,137.72..195,507.63 rows=134,427 width=565) (actual time=11.193..410.316 rows=135,518 loops=1)

  • Hash Cond: (d.publisher_orgref = publisher.swa_org_ref)
4. 197.444 205.084 ↓ 1.0 135,518 1

Bitmap Heap Scan on entity_eton_agg d (cost=2,085.27..195,101.16 rows=134,427 width=347) (actual time=10.395..205.084 rows=135,518 loops=1)

  • Recheck Cond: (works_state = ANY ('{0,2,3,4,5,6,7,8}'::integer[]))
  • Filter: active
  • Rows Removed by Filter: 43
  • Heap Blocks: exact=19082
5. 7.640 7.640 ↓ 1.0 136,091 1

Bitmap Index Scan on idx_entity_eton_agg_works_state (cost=0.00..2,051.66 rows=134,439 width=0) (actual time=7.640..7.640 rows=136,091 loops=1)

  • Index Cond: (works_state = ANY ('{0,2,3,4,5,6,7,8}'::integer[]))
6. 0.390 0.790 ↑ 1.0 1,309 1

Hash (cost=36.09..36.09 rows=1,309 width=222) (actual time=0.790..0.790 rows=1,309 loops=1)

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

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

8. 0.390 0.819 ↑ 1.0 1,309 1

Hash (cost=36.09..36.09 rows=1,309 width=222) (actual time=0.819..0.819 rows=1,309 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 82kB
9. 0.429 0.429 ↑ 1.0 1,309 1

Seq Scan on orgref resporg (cost=0.00..36.09 rows=1,309 width=222) (actual time=0.004..0.429 rows=1,309 loops=1)

10. 0.004 0.011 ↑ 1.0 5 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
11. 0.007 0.007 ↑ 1.0 5 1

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