explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8NB

Settings
# exclusive inclusive rows x rows loops node
1. 0.103 0.638 ↑ 1.0 1 1

Aggregate (cost=70.84..70.85 rows=1 width=8) (actual time=0.638..0.638 rows=1 loops=1)

  • Buffers: shared hit=151
2. 0.535 0.535 ↓ 28.5 1,253 1

Index Only Scan using idx_comp_stats on tasks (cost=0.55..70.73 rows=44 width=0) (actual time=0.031..0.535 rows=1,253 loops=1)

  • Index Cond: ((task_type = 'Pick'::text) AND (completed_at IS NULL) AND (assigned_to IS NULL) AND (defer_until IS NULL))
  • Heap Fetches: 1,253
  • Buffers: shared hit=151