explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1ojR

Settings
# exclusive inclusive rows x rows loops node
1. 0.951 120.397 ↑ 1.0 1,801 1

Limit (cost=1.27..70,184.73 rows=1,801 width=491) (actual time=0.200..120.397 rows=1,801 loops=1)

2. 67.424 119.446 ↑ 6.2 1,801 1

Nested Loop Left Join (cost=1.27..434,507.44 rows=11,150 width=491) (actual time=0.199..119.446 rows=1,801 loops=1)

  • Join Filter: (d.impact_score = ei_lang.impact_score)
3. 4.731 52.022 ↑ 6.2 1,801 1

Nested Loop (cost=1.27..422,994.00 rows=11,150 width=446) (actual time=0.054..52.022 rows=1,801 loops=1)

  • Join Filter: (d.impact_score = ei.impact_score)
  • Rows Removed by Join Filter: 7201
4. 1.447 45.490 ↑ 6.2 1,801 1

Nested Loop (cost=1.27..422,156.69 rows=11,150 width=358) (actual time=0.043..45.490 rows=1,801 loops=1)

5. 1.798 40.441 ↑ 6.2 1,801 1

Nested Loop (cost=0.99..408,188.75 rows=11,151 width=336) (actual time=0.040..40.441 rows=1,801 loops=1)

6. 2.695 35.041 ↑ 6.2 1,801 1

Nested Loop (cost=0.71..394,184.48 rows=11,180 width=314) (actual time=0.034..35.041 rows=1,801 loops=1)

7. 25.629 25.629 ↑ 13.8 2,239 1

Index Scan using idx_entity_agg_repopulate_coords_dates_impact on entity_agg_repopulate d (cost=0.57..388,850.14 rows=30,831 width=322) (actual time=0.026..25.629 rows=2,239 loops=1)

  • Index Cond: ((location_point_easting >= 500000) AND (location_point_easting <= 550000) AND (location_point_northing >= 200000) AND (location_point_northing <= 250000) AND (start_date <= to_timestamp('31/12/2018 23:59:59'::text, 'DD/MM/YYYY HH24:MI:SS'::text)) AND (end_date >= to_timestamp('01/09/2018 00:00:00'::text, 'DD/MM/YYYY HH24:MI:SS'::text)))
  • Filter: (impact_score = ANY ('{1,2,3,4}'::integer[]))
  • Rows Removed by Filter: 14
8. 6.717 6.717 ↑ 1.0 1 2,239

Index Scan using entity_category_pkey on entity_category ec (cost=0.14..0.16 rows=1 width=7) (actual time=0.002..0.003 rows=1 loops=2,239)

  • Index Cond: ((nsa_code)::text = (d.entity_category)::text)
  • Filter: ((entitygroupid)::text = 'RW'::text)
  • Rows Removed by Filter: 0
9. 3.602 3.602 ↑ 1.0 1 1,801

Index Scan using pk_orgref on orgref resporg (cost=0.28..1.24 rows=1 width=26) (actual time=0.001..0.002 rows=1 loops=1,801)

  • Index Cond: (swa_org_ref = d.responsible_org_orgref)
10. 3.602 3.602 ↑ 1.0 1 1,801

Index Scan using pk_orgref on orgref publisher (cost=0.28..1.24 rows=1 width=26) (actual time=0.001..0.002 rows=1 loops=1,801)

  • Index Cond: (swa_org_ref = d.publisher_orgref)
11. 1.794 1.801 ↑ 1.0 5 1,801

Materialize (cost=0.00..1.07 rows=5 width=92) (actual time=0.000..0.001 rows=5 loops=1,801)

12. 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.005..0.007 rows=5 loops=1)

13. 0.000 0.000 ↓ 0.0 0 1,801

Materialize (cost=0.00..1.07 rows=1 width=222) (actual time=0.000..0.000 rows=0 loops=1,801)

14. 0.004 0.004 ↓ 0.0 0 1

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

  • Filter: ((code)::text = 'en'::text)
  • Rows Removed by Filter: 5