explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ytvg

Settings
# exclusive inclusive rows x rows loops node
1. 5.362 5.362 ↓ 1.7 1,000 1

Index Scan using cursor_row_pkey on public.cursor_row (cost=0.69..346.84 rows=601 width=420) (actual time=1.657..5.362 rows=1,000 loops=1)

  • Output: id, value
  • Index Cond: (((cursor_row.business_id)::text = '5285'::text) AND ((cursor_row.cid)::text = 'a19769ca89e065ce3b14a38929062ca0'::text) AND (cursor_row.id >= 291001
  • Buffers: shared hit=92 read=28
Planning time : 1.439 ms
Execution time : 5.550 ms