explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TD5I

Settings
# exclusive inclusive rows x rows loops node
1. 14,969.852 14,969.852 ↑ 1.0 1 1

Aggregate (cost=105,486.65..105,486.66 rows=1 width=8) (actual time=14,969.852..14,969.852 rows=1 loops=1)

  • Buffers: shared hit=18 read=2663
  • -> Index Only Scan using queue_workitem_queue_id_ce27d6a5 on queue_workitem (cost=0.42..105137.75 rows=139563 width=0) (actual time
  • Index Cond: (queue_id = 17)
  • Heap Fetches: 5215
  • Buffers: shared hit=18 read=2663