explain.depesz.com

PostgreSQL's explain analyze made readable

Result: i0IC : Insert_depseg

Settings
# exclusive inclusive rows x rows loops node
1. 0.365 0.446 ↓ 0.0 0 1

Insert on departure_seg (cost=0.43..846.82 rows=1 width=570) (actual time=0.446..0.446 rows=0 loops=1)

2. 0.008 0.081 ↑ 1.0 1 1

Subquery Scan on *SELECT* (cost=0.43..846.82 rows=1 width=570) (actual time=0.076..0.081 rows=1 loops=1)

3. 0.029 0.073 ↑ 1.0 1 1

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

4. 0.036 0.036 ↑ 100.0 1 1

Function Scan on json_to_recordset y (cost=0.00..1.00 rows=100 width=480) (actual time=0.034..0.036 rows=1 loops=1)

5. 0.008 0.008 ↓ 0.0 0 1

Index Only Scan using xpkdeparture_seg on departure_seg departure_seg_1 (cost=0.43..8.45 rows=1 width=6) (actual time=0.007..0.008 rows=0 loops=1)

  • Index Cond: (departure_seg_key = y.departuresegkey)
  • Heap Fetches: 0
Planning time : 0.217 ms
Execution time : 0.927 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint xfkacftype_depseg 0.120 ms 1 0.120 ms
for constraint xfkarpt_depsegdest 0.084 ms 1 0.084 ms
for constraint xfkarpt_depsegorig 0.063 ms 1 0.063 ms
for constraint xfkflowpathod_depseg 0.069 ms 1 0.069 ms
for constraint xfksvctype_depseg 0.055 ms 1 0.055 ms
departure_seg_i 0.177 ms 1 0.177 ms