explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yuyQ

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

Aggregate (cost=12,429.51..12,429.61 rows=1 width=32) (actual time=17.952..17.952 rows=1 loops=1)

2. 14.864 17.941 ↓ 3.0 3 1

Bitmap Heap Scan on order_customer_restaurant_hour (cost=1,421.05..12,429.50 rows=1 width=8) (actual time=13.152..17.941 rows=3 loops=1)

  • Recheck Cond: (order_created_at > (now() - '01:00:00'::interval))
  • Filter: (((customer_id)::text = '9899e310-3c1c-4732-bbf9-21f341506d5b'::text) AND ((restaurant_id)::text = '1763f92a-d15f-45e7-945e-2dd57589b4f7'::text))
  • Rows Removed by Filter: 63486
  • Heap Blocks: exact=1291
3. 3.077 3.077 ↓ 1.0 63,493 1

Bitmap Index Scan on hour_order_created_at_idx (cost=0.00..1,421.05 rows=61,684 width=0) (actual time=3.077..3.077 rows=63,493 loops=1)

  • Index Cond: (order_created_at > (now() - '01:00:00'::interval))
Planning time : 0.070 ms
Execution time : 17.988 ms