explain.depesz.com

PostgreSQL's explain analyze made readable

Result: U7mS : Testing

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 628.224 628.231 ↓ 0.0 0 1

Update on pgbench_branches (cost=0.14..8.16 rows=1 width=370) (actual time=628.230..628.231 rows=0 loops=1)

  • Buffers: shared hit=8
2. 0.007 0.007 ↑ 1.0 1 1

Index Scan using pgbench_branches_pkey on pgbench_branches (cost=0.14..8.16 rows=1 width=370) (actual time=0.005..0.007 rows=1 loops=1)

  • Index Cond: (bid = 19)
  • Buffers: shared hit=2