explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HLjG

Settings
# exclusive inclusive rows x rows loops node
1. 0.047 79.911 ↑ 6.8 72 1

Limit (cost=1.12..76,788.10 rows=493 width=491) (actual time=0.277..79.911 rows=72 loops=1)

2. 3.248 79.864 ↑ 6.8 72 1

Nested Loop (cost=1.12..76,788.10 rows=493 width=491) (actual time=0.276..79.864 rows=72 loops=1)

3. 0.084 76.472 ↑ 6.8 72 1

Nested Loop Left Join (cost=0.84..75,573.25 rows=493 width=642) (actual time=0.150..76.472 rows=72 loops=1)

  • Join Filter: (d.impact_score = ei_lang.impact_score)
4. 0.205 76.388 ↑ 6.8 72 1

Nested Loop (cost=0.84..75,564.79 rows=493 width=424) (actual time=0.144..76.388 rows=72 loops=1)

  • Join Filter: (d.impact_score = ei.impact_score)
  • Rows Removed by Join Filter: 288
5. 0.120 76.111 ↑ 6.8 72 1

Nested Loop (cost=0.84..75,526.75 rows=493 width=336) (actual time=0.135..76.111 rows=72 loops=1)

6. 75.775 75.775 ↑ 6.9 72 1

Index Scan using idx_entity_agg_repopulate_coords_dates_impact on entity_agg_repopulate d (cost=0.57..74,812.08 rows=494 width=314) (actual time=0.129..75.775 rows=72 loops=1)

  • Index Cond: ((location_point_easting >= 300000) AND (location_point_easting <= 350000) AND (location_point_northing >= 500000) AND (location_point_northing <= 550000) AND (start_date <= to_timestamp('31/11/2018 23:59:59'::text, 'DD/MM/YYYY HH24:MI:SS'::text)) AND (end_date >= to_timestamp('01/11/2018 00:00:00'::text, 'DD/MM/YYYY HH24:MI:SS'::text)))
  • Filter: ((entity_type = 1) AND (impact_score = ANY ('{1,2,3,4}'::integer[])))
  • Rows Removed by Filter: 60
7. 0.216 0.216 ↑ 1.0 1 72

Index Scan using pk_orgref on orgref resporg (cost=0.28..1.44 rows=1 width=26) (actual time=0.002..0.003 rows=1 loops=72)

  • Index Cond: (swa_org_ref = d.responsible_org_orgref)
8. 0.065 0.072 ↑ 1.0 5 72

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

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

10. 0.000 0.000 ↓ 0.0 0 72

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

11. 0.005 0.005 ↓ 0.0 0 1

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

  • Filter: ((code)::text = 'en'::text)
  • Rows Removed by Filter: 5
12. 0.144 0.144 ↑ 1.0 1 72

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

  • Index Cond: (swa_org_ref = d.publisher_orgref)