explain.depesz.com

PostgreSQL's explain analyze made readable

Result: COZ5

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 60.569 ↑ 1.0 1 1

Aggregate (cost=95,068.32..95,068.42 rows=1 width=32) (actual time=60.569..60.569 rows=1 loops=1)

2. 60.558 60.558 ↓ 2.0 2 1

Index Scan using pk_day_created_at_customer_id_restaurant_id on order_customer_restaurant_day (cost=0.56..95,068.32 rows=1 width=8) (actual time=9.950..60.558 rows=2 loops=1)

  • Index Cond: ((order_created_at > (now() - '1 day'::interval)) AND ((customer_id)::text = '9899e310-3c1c-4732-bbf9-21f341506d5b'::text) AND ((restaurant_id)::text = '1763f92a-d15f-45e7-945e-2dd57589b4f7'::text))
Planning time : 0.074 ms
Execution time : 60.589 ms