explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jLl8

Settings
# exclusive inclusive rows x rows loops node
1. 255,058.005 255,058.005 ↑ 1.0 1 1

Limit (cost=0.43..2.84 rows=1 width=1,272) (actual time=255,058.002..255,058.005 rows=1 loops=1)

  • Output: id, name, description, meta, stage, namespace, kind, priority, queue_id, created_dt, updated_dt, unique_identifier
  • Buffers: shared hit=46839 read=11276
  • -> Index Scan using queue_workitem_created_dt_502c27a6 on public.queue_workitem (cost=0.43..395512.23 rows=163691 width=1272) (
  • Output: id, name, description, meta, stage, namespace, kind, priority, queue_id, created_dt, updated_dt, unique_identifier
  • Filter: ((queue_workitem.queue_id = 30) AND ((queue_workitem.stage)::text = 'unassigned'::text))
  • Rows Removed by Filter: 63822
  • Buffers: shared hit=46839 read=11276
  • Planning time: 1.224 ms
  • Execution time: 255058.056 ms