explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UedO

Settings
# exclusive inclusive rows x rows loops node
1. 9.331 147.205 ↑ 1.0 1 1

Aggregate (cost=36,226.35..36,226.36 rows=1 width=8) (actual time=147.205..147.205 rows=1 loops=1)

  • Output: count(queue_id)
  • Buffers: shared read=31125 written=7
2. 102.519 137.874 ↑ 1.1 140,348 1

Bitmap Heap Scan on public.badorder (cost=2,873.65..35,842.73 rows=153,447 width=4) (actual time=42.606..137.874 rows=140,348 loops=1)

  • Output: queue_id, x
  • Recheck Cond: (badorder.queue_id = 17)
  • Heap Blocks: exact=30738
  • Buffers: shared read=31125 written=7
3. 35.355 35.355 ↑ 1.1 140,348 1

Bitmap Index Scan on badorder_queue_id_idx (cost=0.00..2,835.28 rows=153,447 width=0) (actual time=35.355..35.355 rows=140,348 loops=1)

  • Index Cond: (badorder.queue_id = 17)
  • Buffers: shared read=387