explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vkMA : insert_depsegleg

Settings
# exclusive inclusive rows x rows loops node
1. 0.055 61,867.370 ↓ 0.0 0 1

Insert on departure_seg_leg (cost=0.00..158,299,638.88 rows=50 width=40) (actual time=61,867.369..61,867.370 rows=0 loops=1)

2. 0.008 61,867.315 ↑ 50.0 1 1

Subquery Scan on *SELECT* (cost=0.00..158,299,638.88 rows=50 width=40) (actual time=61,867.311..61,867.315 rows=1 loops=1)

3. 0.437 61,867.307 ↑ 50.0 1 1

Function Scan on json_to_recordset z (cost=0.00..158,299,638.00 rows=50 width=96) (actual time=61,867.305..61,867.307 rows=1 loops=1)

  • Filter: (NOT (SubPlan 1))
4.          

SubPlan (for Function Scan)

5. 61,866.870 61,866.870 ↓ 0.0 0 1

Seq Scan on departure_seg_leg departure_seg_leg_1 (cost=0.00..1,582,996.00 rows=1 width=0) (actual time=61,866.869..61,866.870 rows=0 loops=1)

  • Filter: ((departure_key = get_leg_key(z.leginfo)) AND (departure_seg_key = get_seg_key(z.seginfo)))
  • Rows Removed by Filter: 3,035,523
Planning time : 0.121 ms
Execution time : 61,867.531 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint xfkdepleg_depsegleg 0.110 ms 1 0.110 ms