explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gC7S

Settings
# exclusive inclusive rows x rows loops node
1. 1,021.994 1,069.050 ↑ 1.4 8,835 1

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

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

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

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

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

  • Hash Cond: (d.publisher_orgref = publisher.swa_org_ref)
4. 19.502 23.964 ↑ 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=5.192..23.964 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.462 ↓ 0.0 0 1

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

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

  • Index Cond: (works_state = ANY ('{0,2,3,4,5,6,7,8}'::integer[]))
7. 1.737 1.737 ↑ 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.737..1.737 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.500 1.050 ↑ 1.0 1,309 1

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

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

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

10. 0.493 1.061 ↑ 1.0 1,309 1

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

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

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