explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AyFV

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

Limit (cost=1.01..3.31 rows=1 width=8) (actual time=0.028..0.029 rows=1 loops=1)

2. 0.000 0.027 ↑ 431.0 1 1

Nested Loop (cost=1.01..992.78 rows=431 width=8) (actual time=0.027..0.027 rows=1 loops=1)

3. 0.014 0.014 ↑ 1.0 1 1

Index Only Scan using pk_worker on worker worker1_ (cost=0.44..4.54 rows=1 width=8) (actual time=0.014..0.014 rows=1 loops=1)

  • Index Cond: (id = 16)
  • Heap Fetches: 1
4. 0.013 0.013 ↑ 431.0 1 1

Index Scan using idx_route_created_date_worker_id on route route0_ (cost=0.57..945.14 rows=431 width=16) (actual time=0.013..0.013 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.221 ms
Execution time : 0.050 ms