explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lIoP

Settings
# exclusive inclusive rows x rows loops node
1. 150.019 173.855 ↑ 1.1 1,073 1

Hash Join (cost=10,187.23..26,304.65 rows=1,210 width=851) (actual time=7.646..173.855 rows=1,073 loops=1)

  • Hash Cond: (d.responsible_org_orgref = resporg.swa_org_ref)
2. 0.595 23.359 ↑ 1.1 1,073 1

Hash Join (cost=10,131.31..24,687.67 rows=1,210 width=815) (actual time=6.821..23.359 rows=1,073 loops=1)

  • Hash Cond: (d.publisher_orgref = publisher.swa_org_ref)
3. 0.611 22.343 ↑ 1.1 1,073 1

Hash Join (cost=10,075.40..24,628.56 rows=1,210 width=597) (actual time=6.393..22.343 rows=1,073 loops=1)

  • Hash Cond: (d.impact_score = ei.impact_score)
4. 0.826 21.725 ↑ 1.1 1,073 1

Hash Left Join (cost=10,074.28..24,621.58 rows=1,210 width=509) (actual time=6.381..21.725 rows=1,073 loops=1)

  • Hash Cond: (d.impact_score = ei_lang.impact_score)
5. 14.963 20.895 ↑ 1.1 1,073 1

Bitmap Heap Scan on entity_eton_agg d (cost=10,073.21..24,614.64 rows=1,210 width=291) (actual time=6.370..20.895 rows=1,073 loops=1)

  • Recheck Cond: ((location_point_easting >= 338465) AND (location_point_easting <= 439629) AND (location_point_northing >= 315609) AND (location_point_northing <= 379249))
  • Filter: (active AND (publisher_swtype = 1) AND (impact_score = ANY ('{1,2,3,4}'::integer[])) AND (start_date <= to_timestamp('04/02/2020 23:59:59'::text, 'DD/MM/YYYY HH24:MI:SS'::text)) AND (end_date >= to_timestamp('04/02/2020 00:00:00'::text, 'DD/MM/YYYY HH24:MI:SS'::text)) AND (works_state = ANY ('{0,2,3,4,5,6,7,8}'::integer[])))
  • Rows Removed by Filter: 4208
  • Heap Blocks: exact=3607
6. 5.932 5.932 ↓ 1.3 5,281 1

Bitmap Index Scan on idx_entity_eton_agg_eastingnorthing (cost=0.00..10,072.91 rows=4,197 width=0) (actual time=5.932..5.932 rows=5,281 loops=1)

  • Index Cond: ((location_point_easting >= 338465) AND (location_point_easting <= 439629) AND (location_point_northing >= 315609) AND (location_point_northing <= 379249))
7. 0.001 0.004 ↓ 0.0 0 1

Hash (cost=1.06..1.06 rows=1 width=222) (actual time=0.004..0.004 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
8. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on eton_impact_lang ei_lang (cost=0.00..1.06 rows=1 width=222) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((code)::text = 'en'::text)
  • Rows Removed by Filter: 5
9. 0.004 0.007 ↑ 1.0 5 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
10. 0.003 0.003 ↑ 1.0 5 1

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

11. 0.222 0.421 ↑ 1.1 1,344 1

Hash (cost=37.63..37.63 rows=1,463 width=222) (actual time=0.421..0.421 rows=1,344 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 84kB
12. 0.199 0.199 ↑ 1.1 1,344 1

Seq Scan on orgref publisher (cost=0.00..37.63 rows=1,463 width=222) (actual time=0.001..0.199 rows=1,344 loops=1)

13. 0.227 0.477 ↑ 1.1 1,344 1

Hash (cost=37.63..37.63 rows=1,463 width=222) (actual time=0.477..0.477 rows=1,344 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 84kB
14. 0.250 0.250 ↑ 1.1 1,344 1

Seq Scan on orgref resporg (cost=0.00..37.63 rows=1,463 width=222) (actual time=0.004..0.250 rows=1,344 loops=1)

Planning time : 0.648 ms
Execution time : 174.156 ms