explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KlCZU

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.008 ↓ 0.0 0 1

Bitmap Heap Scan on autocomplete_tasks (cost=4.13..9.47 rows=2 width=91) (actual time=0.008..0.008 rows=0 loops=1)

  • Recheck Cond: ((batch_id = 583) AND (NOT is_complete))
2. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on idx__actask_complete_false (cost=0.00..4.13 rows=2 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (batch_id = 583)
Planning time : 0.155 ms
Execution time : 0.061 ms