explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2Rq9

Settings
# exclusive inclusive rows x rows loops node
1. 0.024 2.642 ↓ 0.0 0 1

ModifyTable (cost=0.43..3.45 rows=1 width=6) (actual time=2.642..2.642 rows=0 loops=1)

  • Buffers: shared hit=4 read=2 dirtied=1
2. 2.618 2.618 ↑ 1.0 1 1

Index Scan using sale_pkey on sale sale (cost=0.43..3.45 rows=1 width=6) (actual time=2.616..2.618 rows=1 loops=1)

  • Index Cond: (sale.sale_id = 'd94829d7-a513-4614-b5ea-8103c277cc41'::uuid)
  • Buffers: shared hit=2 read=2