explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9uYN

Settings
# exclusive inclusive rows x rows loops node
1. 2.129 4.389 ↓ 0.0 0 1

ModifyTable (cost=0.56..12.68 rows=7 width=6) (actual time=4.389..4.389 rows=0 loops=1)

  • Buffers: shared hit=16 read=9 dirtied=7
2. 2.260 2.260 ↑ 1.0 7 1

Index Scan using sale_attributes_pkey on sale_attribute sale_attribute (cost=0.56..12.68 rows=7 width=6) (actual time=0.929..2.26 rows=7 loops=1)

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