explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Hr7h : new impl

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 0.058 ↑ 118.0 1 1

GroupAggregate (cost=0.57..279.44 rows=118 width=8) (actual time=0.058..0.058 rows=1 loops=1)

  • Group Key: worker_id
  • Filter: (count(id) > 9)
2. 0.051 0.051 ↑ 11.8 10 1

Index Scan using idx_route_created_date_worker_id on route r (cost=0.57..267.05 rows=118 width=16) (actual time=0.029..0.051 rows=10 loops=1)

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