explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ywzI

Settings
# exclusive inclusive rows x rows loops node
1. 3,149.624 3,149.624 ↑ 1.0 1 1

Aggregate (cost=5,095.17..5,095.18 rows=1 width=8) (actual time=3,149.624..3,149.624 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=70 read=883
  • -> Index Only Scan using queue_workitem_queue_id_ce27d6a5 on public.queue_workitem (cost=0.42..4749.59 rows=138235 width=0) (ac
  • Output: queue_id
  • Index Cond: (queue_workitem.queue_id = 17)
  • Heap Fetches: 1600
  • Buffers: shared hit=70 read=883