explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5GXw

Settings
# exclusive inclusive rows x rows loops node
1. 0.094 0.273 ↓ 0.0 0 1

Delete on gp_account_movement (cost=0.56..8.58 rows=1 width=6) (actual time=0.273..0.273 rows=0 loops=1)

2. 0.179 0.179 ↑ 1.0 1 1

Index Scan using gp_account_movement_pkey on gp_account_movement (cost=0.56..8.58 rows=1 width=6) (actual time=0.176..0.179 rows=1 loops=1)

  • Index Cond: (account_movement_id = 8050561156::bigint)
Planning time : 0.241 ms
Execution time : 252,985.329 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint fk941c288898bf4376 102,373.135 ms 1 102,373.135 ms
for constraint fk941c2888b4559b85 68,749.142 ms 1 68,749.142 ms
for constraint fk941c2888df7417aa 81,862.636 ms 1 81,862.636 ms