explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QPIHg

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 0.080 ↑ 2.0 1 1

Bitmap Heap Scan on user_devices (cost=8.56..13.76 rows=2 width=69) (actual time=0.079..0.080 rows=1 loops=1)

  • Recheck Cond: ((user_id = ANY ('{9552695,9552696}'::integer[])) AND (deleted_at IS NULL))
  • Heap Blocks: exact=2
2. 0.060 0.060 ↓ 1.5 3 1

Bitmap Index Scan on unique_user_devices_user_id_device_id_idx (cost=0.00..8.56 rows=2 width=0) (actual time=0.060..0.060 rows=3 loops=1)

  • Index Cond: (user_id = ANY ('{9552695,9552696}'::integer[]))
Planning time : 0.339 ms
Execution time : 0.460 ms