explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YGv8

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 172.364 ↓ 0.0 0 1

Delete on sale_price (cost=0.43..43,200.69 rows=2 width=6) (actual time=172.364..172.364 rows=0 loops=1)

  • Buffers: shared hit=28 read=17589
2. 172.361 172.361 ↓ 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=172.361..172.361 rows=0 loops=1)

  • Index Cond: (sale_price.sale_id = 'd94829d7-a513-4614-b5ea-8103c277cc41'::uuid)
  • Buffers: shared hit=28 read=17589
Planning time : 1.224 ms
Execution time : 172.606 ms