explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hKQ1

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 88.092 ↓ 0.0 0 1

ModifyTable (cost=0.43..43,200.69 rows=2 width=6) (actual time=88.092..88.092 rows=0 loops=1)

  • Buffers: shared hit=17617
2. 88.082 88.082 ↓ 0.0 0 1

Index Scan using price_generated_sale_price_generated_id_sale_id_key on sale_price sale_price (cost=0.43..43,200.69 rows=2 width=6) (actual time=88.082..88.082 rows=0 loops=1)

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