explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ks5f

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=0.57..2.77 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Index Scan using idx_route_created_date_worker_id on route (cost=0.57..927.03 rows=422 width=8) (actual rows= loops=)

  • Index Cond: ((worker_id = 645,245) AND (created_date >= '2020-02-01 00:00:00'::timestamp without time zone))
  • Filter: ((route_state)::text = 'COMPLETED'::text)