explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wO03

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 48.649 ↑ 1.0 1 1

Aggregate (cost=929.90..930.00 rows=1 width=8) (actual time=48.649..48.649 rows=1 loops=1)

2. 48.629 48.629 ↑ 3.7 113 1

Index Scan using idx_route_created_date_worker_id on route (cost=0.57..928.84 rows=423 width=8) (actual time=2.357..48.629 rows=113 loops=1)

  • 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)
  • Rows Removed by Filter: 25
Planning time : 0.131 ms
Execution time : 48.674 ms