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

Delete on sale (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
Planning time : 0.121 ms
Execution time : 93.56 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
RI_ConstraintTrigger_a_221648 88.417 ms 1 88.417 ms
RI_ConstraintTrigger_a_221728 0.138 ms 1 0.138 ms
RI_ConstraintTrigger_a_221773 0.599 ms 1 0.599 ms
RI_ConstraintTrigger_a_299084231 0.081 ms 1 0.081 ms
sale_dw_log 1.627 ms 1 1.627 ms