explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4lns : routes with limit 10

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.031 ↑ 1.0 10 1

Limit (cost=0.57..22.92 rows=10 width=8) (actual time=0.018..0.031 rows=10 loops=1)

2. 0.029 0.029 ↑ 183.7 10 1

Index Scan using idx_route_created_date_worker_id on route r (cost=0.57..4,106.97 rows=1,837 width=8) (actual time=0.017..0.029 rows=10 loops=1)

  • Index Cond: ((worker_id = 799) AND (created_date >= '2020-06-30 00:00:00'::timestamp without time zone))
  • Filter: ((route_state)::text = 'COMPLETED'::text)
Planning time : 0.122 ms
Execution time : 0.046 ms