explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rhjv

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

Delete on sale_price (cost=0.42..4.96 rows=2 width=6) (actual time=0.023..0.023 rows=0 loops=1)

  • Buffers: shared hit=3
2. 0.020 0.020 ↓ 0.0 0 1

Index Scan using tmp_sale_price on sale_price sale_price (cost=0.42..4.96 rows=2 width=6) (actual time=0.02..0.02 rows=0 loops=1)

  • Index Cond: (sale_price.sale_id = '1559fb04-5d5f-468a-aefb-3d1082c8254d'::uuid)
  • Buffers: shared hit=3
Planning time : 0.161 ms
Execution time : 0.086 ms