explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fBya

Settings
# exclusive inclusive rows x rows loops node
1. 44.857 5,386.289 ↑ 1.0 1 1

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

  • Output: count(queue_id)
  • Buffers: shared read=31125
2. 5,324.624 5,341.432 ↑ 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=20.540..5,341.432 rows=140,348 loops=1)

  • Output: queue_id, x
  • Recheck Cond: (badorder.queue_id = 17)
  • Heap Blocks: exact=30738
  • Buffers: shared read=31125
3. 16.808 16.808 ↑ 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=16.808..16.808 rows=140,348 loops=1)

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