explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d7N

Settings
# exclusive inclusive rows x rows loops node
1. 887.690 948.152 ↑ 1.4 8,835 1

Hash Join (cost=484.17..56,931.68 rows=12,157 width=684) (actual time=5.373..948.152 rows=8,835 loops=1)

  • Hash Cond: (d.impact_score = ei.impact_score)
2. 7.099 60.451 ↑ 1.4 8,835 1

Hash Join (cost=466.52..41,290.36 rows=12,157 width=405) (actual time=4.748..60.451 rows=8,835 loops=1)

  • Hash Cond: (d.responsible_org_orgref = resporg.swa_org_ref)
3. 10.529 52.522 ↑ 1.4 8,835 1

Hash Join (cost=414.07..41,205.90 rows=12,157 width=383) (actual time=3.912..52.522 rows=8,835 loops=1)

  • Hash Cond: (d.publisher_orgref = publisher.swa_org_ref)
4. 39.308 41.210 ↑ 1.4 8,835 1

Bitmap Heap Scan on entity_eton_agg d (cost=361.62..41,121.43 rows=12,157 width=361) (actual time=3.121..41.210 rows=8,835 loops=1)

  • Recheck Cond: (works_state = ANY ('{0,2,3,4,5,6,7,8}'::integer[]))
  • Filter: (active AND (end_date >= LOCALTIMESTAMP) AND (end_date >= (CURRENT_DATE)::timestamp without time zone) AND (start_date <= ((CURRENT_DATE + '1 day'::interval) - '00:00:01'::interval)))
  • Rows Removed by Filter: 12199
  • Heap Blocks: exact=8878
5. 1.902 1.902 ↑ 1.0 21,034 1

Bitmap Index Scan on idx_entity_eton_agg_works_state (cost=0.00..358.58 rows=21,368 width=0) (actual time=1.902..1.902 rows=21,034 loops=1)

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

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

  • Buckets: 2048 Batches: 1 Memory Usage: 82kB
7. 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)

8. 0.393 0.830 ↑ 1.0 1,309 1

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

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

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

10. 0.005 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
11. 0.006 0.006 ↑ 68.0 5 1

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