explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ntsf

Settings
# exclusive inclusive rows x rows loops node
1. 0.043 7.188 ↓ 0.0 0 1

Delete on sale (cost=0.56..3.58 rows=1 width=6) (actual time=7.188..7.188 rows=0 loops=1)

  • Buffers: shared hit=2 read=5 dirtied=1
2. 7.145 7.145 ↑ 1.0 1 1

Index Scan using sale_pkey on sale sale (cost=0.56..3.58 rows=1 width=6) (actual time=7.141..7.145 rows=1 loops=1)

  • Index Cond: (sale.sale_id = '1559fb04-5d5f-468a-aefb-3d1082c8254d'::uuid)
  • Buffers: shared read=5
Planning time : 0.183 ms
Execution time : 8.358 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
RI_ConstraintTrigger_a_272439516 0.517 ms 1 0.517 ms
RI_ConstraintTrigger_a_272439721 0.113 ms 1 0.113 ms
RI_ConstraintTrigger_a_272439816 0.072 ms 1 0.072 ms
RI_ConstraintTrigger_a_299084213 0.360 ms 1 0.360 ms