explain.depesz.com

PostgreSQL's explain analyze made readable

Result: m2Ic

Settings
# exclusive inclusive rows x rows loops node
1. 0.356 0.356 ↑ 1.5 289 1

Index Scan using idx_route_created_date_worker_id on route (cost=0.57..945.14 rows=431 width=8) (actual time=0.014..0.356 rows=289 loops=1)

  • Index Cond: ((worker_id = 16) AND (created_date >= '2020-02-01 00:00:00'::timestamp without time zone))
  • Filter: ((route_state)::text = 'COMPLETED'::text)
  • Rows Removed by Filter: 13
Planning time : 0.137 ms
Execution time : 0.378 ms