explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vC6x

Settings
# exclusive inclusive rows x rows loops node
1. 0.034 0.139 ↑ 3.0 1 1

GroupAggregate (cost=4.43..63.45 rows=3 width=12) (actual time=0.138..0.139 rows=1 loops=1)

  • Group Key: user_id
2. 0.029 0.105 ↓ 1.1 20 1

Bitmap Heap Scan on order_users (cost=4.43..63.15 rows=18 width=12) (actual time=0.088..0.105 rows=20 loops=1)

  • Recheck Cond: (user_id = 9,552,306)
  • Heap Blocks: exact=4
3. 0.076 0.076 ↓ 1.1 20 1

Bitmap Index Scan on order_users_user_id_idx (cost=0.00..4.42 rows=18 width=0) (actual time=0.076..0.076 rows=20 loops=1)

  • Index Cond: (user_id = 9,552,306)
Planning time : 0.672 ms
Execution time : 0.227 ms