explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hYZA

Settings
# exclusive inclusive rows x rows loops node
1. 878.491 919.385 ↑ 1.4 8,835 1

Hash Join (cost=1,191.58..46,027.45 rows=12,157 width=684) (actual time=7.203..919.385 rows=8,835 loops=1)

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

Hash Join (cost=1,173.93..30,386.13 rows=12,157 width=405) (actual time=6.582..40.883 rows=8,835 loops=1)

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

Hash Join (cost=1,121.48..30,301.67 rows=12,157 width=383) (actual time=5.722..32.406 rows=8,835 loops=1)

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

Bitmap Heap Scan on entity_eton_agg d (cost=1,069.03..30,217.20 rows=12,157 width=361) (actual time=4.931..20.673 rows=8,835 loops=1)

  • Recheck Cond: ((works_state = ANY ('{0,2,3,4,5,6,7,8}'::integer[])) AND (start_date <= ((CURRENT_DATE + '1 day'::interval) - '00:00:01'::interval)) AND (end_date >= LOCALTIMESTAMP) AND (end_date >= (CURRENT_DATE)::timestamp without time zone))
  • Filter: active
  • Rows Removed by Filter: 39
  • Heap Blocks: exact=5424
5. 0.527 4.200 ↓ 0.0 0 1

BitmapAnd (cost=1,069.03..1,069.03 rows=12,179 width=0) (actual time=4.200..4.200 rows=0 loops=1)

6. 1.900 1.900 ↑ 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.900..1.900 rows=21,034 loops=1)

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

Bitmap Index Scan on idx_entity_eton_agg_dates_impact (cost=0.00..704.12 rows=19,825 width=0) (actual time=1.773..1.773 rows=18,939 loops=1)

  • Index Cond: ((start_date <= ((CURRENT_DATE + '1 day'::interval) - '00:00:01'::interval)) AND (end_date >= LOCALTIMESTAMP) AND (end_date >= (CURRENT_DATE)::timestamp without time zone))
8. 0.387 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
9. 0.396 0.396 ↑ 1.0 1,309 1

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

10. 0.397 0.854 ↑ 1.0 1,309 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 82kB
11. 0.457 0.457 ↑ 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.457 rows=1,309 loops=1)

12. 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
13. 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)