explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Fq8T

Settings
# exclusive inclusive rows x rows loops node
1. 55.766 55.766 ↑ 11.1 4,412 1

CTE Scan on tm_items_nonspatial (cost=267,996.02..268,974.88 rows=48,943 width=8) (actual time=0.058..55.766 rows=4,412 loops=1)

2.          

CTE tm_items_nonspatial

3. 54.529 54.529 ↑ 11.1 4,412 1

Index Scan using idx_item_et_type_coords_datee on item i (cost=0.56..267,996.02 rows=48,943 width=8) (actual time=0.056..54.529 rows=4,412 loops=1)

  • Index Cond: ((item_entity_type = 2) AND ((item_type)::text = ANY ('{RC,DC}'::text[])) AND (start_date <= to_date('15/09/2020 00:00:00'::text, 'DD/MM/YYYY HH24:MI:SS'::text)) AND (end_date >= to_date('14/09/2020 00:00:00'::text, 'DD/MM/YYYY HH24:MI:SS'::text)))
  • Filter: active
  • Rows Removed by Filter: 140
Planning time : 0.257 ms
Execution time : 56.069 ms