explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jteN

Settings
# exclusive inclusive rows x rows loops node
1. 8.027 563.841 ↓ 363.9 3,639 1

Nested Loop Left Join (cost=0.57..316,485.87 rows=10 width=3,027) (actual time=0.672..563.841 rows=3,639 loops=1)

  • Join Filter: (i_cte.item_id = sche.item_id)
  • Filter: (NOT COALESCE(sche.cancelled, false))
2. 555.814 555.814 ↓ 181.9 3,639 1

Index Scan using idx_item_coords_dates_item_type on item i_cte (cost=0.57..316,426.11 rows=20 width=3,025) (actual time=0.664..555.814 rows=3,639 loops=1)

  • Index Cond: ((location_point_easting >= 393214) AND (location_point_easting <= 480509) AND (location_point_northing >= 245607) AND (location_point_northing <= 308006) AND (start_date >= to_timestamp('09/08/2018 23:39:39'::text, 'DD/MM/YYYY HH24:MI:SS'::text)) AND (end_date >= to_timestamp('09/08/2018 00:00:00'::text, 'DD/MM/YYYY HH24:MI:SS'::text)))
  • Filter: (active AND ((item_type)::text = ANY ('{RC,DR,HDR,O,BC}'::text[])))
  • Rows Removed by Filter: 84506
3. 0.000 0.000 ↓ 0.0 0 3,639

Materialize (cost=0.00..29.12 rows=103 width=11) (actual time=0.000..0.000 rows=0 loops=3,639)

4. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on schedule sche (cost=0.00..28.60 rows=103 width=11) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((actual_start_date < to_timestamp('09/08/2018 23:39:39'::text, 'DD/MM/YYYY HH24:MI:SS'::text)) AND (actual_end_date > to_timestamp('09/08/2018 00:00:00'::text, 'DD/MM/YYYY HH24:MI:SS'::text)))