explain.depesz.com

PostgreSQL's explain analyze made readable

Result: deoX

Settings
# exclusive inclusive rows x rows loops node
1. 0.135 0.229 ↓ 0.0 0 1

Delete on sale_order (cost=0.28..8.29 rows=1 width=6) (actual time=0.229..0.229 rows=0 loops=1)

2. 0.094 0.094 ↑ 1.0 1 1

Index Scan using sale_order_pkey on sale_order (cost=0.28..8.29 rows=1 width=6) (actual time=0.089..0.094 rows=1 loops=1)

  • Index Cond: (id = 887)
Planning time : 0.554 ms
Execution time : 13,343.016 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint account_analytic_account_order_id_fkey on sale_order 0.677 ms 1 0.677 ms
for constraint contract_report_template_order_id_fkey on sale_order 0.149 ms 1 0.149 ms
for constraint payment_transaction_sale_order_id_fkey on sale_order 0.147 ms 1 0.147 ms
for constraint res_partner_last_website_so_id_fkey on sale_order 2.860 ms 1 2.860 ms
for constraint sale_order_line_order_id_fkey on sale_order 4.741 ms 1 4.741 ms
for constraint sale_order_tag_rel_order_id_fkey on sale_order 0.203 ms 1 0.203 ms
for constraint account_analytic_line_so_line_fkey on sale_order_line 12.702 ms 320 0.040 ms
for constraint account_analytic_tag_sale_order_line_re_sale_order_line_id_fkey on sale_order_line 6.199 ms 320 0.019 ms
for constraint account_tax_sale_order_line_rel_sale_order_line_id_fkey on sale_order_line 6.594 ms 320 0.021 ms
for constraint procurement_order_sale_line_id_fkey on sale_order_line 8,054.994 ms 320 25.172 ms
for constraint sale_order_line_invoice_rel_order_line_id_fkey on sale_order_line 8.696 ms 320 0.027 ms
for constraint sale_order_line_parent_id_fkey on sale_order_line 5,243.999 ms 320 16.387 ms