explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HjbM

Settings
# exclusive inclusive rows x rows loops node
1. 0.137 14.224 ↓ 0.0 0 1

Delete on missioni_punti_percorso (cost=0.00..4,314.95 rows=61 width=6) (actual time=14.224..14.224 rows=0 loops=1)

2. 14.087 14.087 ↓ 1.8 109 1

Seq Scan on missioni_punti_percorso (cost=0.00..4,314.95 rows=61 width=6) (actual time=10.852..14.087 rows=109 loops=1)

  • Filter: (id_missione = 16,601)
  • Rows Removed by Filter: 180,296
Planning time : 0.045 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint missioni_tronchi_id_punto_arrivo_fkey 25,857.712 ms 109 237.227 ms