explain.depesz.com

PostgreSQL's explain analyze made readable

Result: s7iF : Insert_depleg

Settings
# exclusive inclusive rows x rows loops node
1. 0.392 0.482 ↓ 0.0 0 1

Insert on departure_leg (cost=0.43..846.81 rows=1 width=3,724) (actual time=0.482..0.482 rows=0 loops=1)

2. 0.017 0.090 ↑ 1.0 1 1

Subquery Scan on *SELECT* (cost=0.43..846.81 rows=1 width=3,724) (actual time=0.085..0.090 rows=1 loops=1)

3. 0.024 0.073 ↑ 1.0 1 1

Nested Loop Anti Join (cost=0.43..846.75 rows=1 width=448) (actual time=0.070..0.073 rows=1 loops=1)

4. 0.043 0.043 ↑ 100.0 1 1

Function Scan on json_to_recordset x (cost=0.00..1.00 rows=100 width=472) (actual time=0.041..0.043 rows=1 loops=1)

5. 0.006 0.006 ↓ 0.0 0 1

Index Only Scan using xpkdeparture_leg on departure_leg departure_leg_1 (cost=0.43..8.45 rows=1 width=6) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (departure_key = x.departurekey)
  • Heap Fetches: 0
Planning time : 0.302 ms
Execution time : 1.049 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint xfkacftype_depleg 0.114 ms 1 0.114 ms
for constraint xfkbidpric_deplegvol 0.005 ms 1 0.005 ms
for constraint xfkbidpric_deplegwt 0.002 ms 1 0.002 ms
for constraint xfkdstcity_depleg 0.003 ms 1 0.003 ms
for constraint xfkflt_depleg 0.073 ms 1 0.073 ms
for constraint xfklegdstapt_depleg 0.078 ms 1 0.078 ms
for constraint xfklegorgapt_depleg 0.060 ms 1 0.060 ms
for constraint xfkorgcity_depleg 0.003 ms 1 0.003 ms
for constraint xfkowner_depleg 0.003 ms 1 0.003 ms
for constraint xfksvctype_depleg 0.070 ms 1 0.070 ms
departure_leg_i 0.212 ms 1 0.212 ms