explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OVm1 : current impl

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

Limit (cost=1.12..3.47 rows=1 width=8) (actual time=0.030..0.031 rows=1 loops=1)

2. 0.001 0.030 ↑ 545.0 1 1

Nested Loop (cost=1.12..1,278.78 rows=545 width=8) (actual time=0.030..0.030 rows=1 loops=1)

3. 0.017 0.017 ↑ 1.0 1 1

Index Only Scan using worker_id_last_modified_date_worker_state_idx on worker worker1_ (cost=0.56..4.66 rows=1 width=8) (actual time=0.017..0.017 rows=1 loops=1)

  • Index Cond: (id = 16)
  • Heap Fetches: 0
4. 0.012 0.012 ↑ 545.0 1 1

Index Scan using idx_route_created_date_worker_id on route route0_ (cost=0.57..1,219.62 rows=545 width=16) (actual time=0.012..0.012 rows=1 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)
Planning time : 0.220 ms
Execution time : 0.049 ms