explain.depesz.com

PostgreSQL's explain analyze made readable

Result: I072

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.155 ↓ 0.0 0 1

Limit (cost=4.59..20.15 rows=1 width=40) (actual time=0.155..0.155 rows=0 loops=1)

2. 0.010 0.154 ↓ 0.0 0 1

Nested Loop (cost=4.59..20.15 rows=1 width=40) (actual time=0.154..0.154 rows=0 loops=1)

3. 0.019 0.137 ↑ 1.0 1 1

Bitmap Heap Scan on order_users (cost=4.31..11.84 rows=1 width=40) (actual time=0.136..0.137 rows=1 loops=1)

  • Recheck Cond: (user_id = 9,552,695)
  • Filter: (status <> 'cancel'::order_status_enum)
  • Heap Blocks: exact=1
4. 0.118 0.118 ↑ 2.0 1 1

Bitmap Index Scan on order_users_user_id_idx (cost=0.00..4.30 rows=2 width=0) (actual time=0.118..0.118 rows=1 loops=1)

  • Index Cond: (user_id = 9,552,695)
5. 0.007 0.007 ↓ 0.0 0 1

Index Only Scan using order_promotions_order_id_promotion_id_idx on order_promotions (cost=0.28..8.30 rows=1 width=4) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (order_id = order_users.order_id)
  • Heap Fetches: 0
Planning time : 0.547 ms
Execution time : 0.224 ms