explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ECey

Settings
# exclusive inclusive rows x rows loops node
1. 0.034 0.052 ↓ 0.0 0 1

Delete on account_report_standard_ledger_report_inv (cost=0.27..4.58 rows=2 width=6) (actual time=0.052..0.052 rows=0 loops=1)

2. 0.018 0.018 ↑ 1.0 2 1

Index Scan using account_report_standard_ledger_report_inv_pkey on account_report_standard_ledger_report_inv (cost=0.27..4.58 rows=2 width=6) (actual time=0.015..0.018 rows=2 loops=1)

  • Index Cond: (id = ANY ('{3,4}'::integer[]))
Planning time : 0.066 ms
Execution time : 3,794.895 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint account_report_standard_ledger_inv_report_id_fkey 0.662 ms 2 0.331 ms
for constraint account_report_standard_ledger_line_inv_report_id_fkey 3,008.203 ms 2 1,504.101 ms
for constraint account_report_standard_ledger_report_object_inv_report_id_fkey 780.415 ms 2 390.207 ms
for constraint table_standard_report_line_to_account_report_standard_ledg_fkey 5.527 ms 2 2.764 ms