explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YHht

Settings
# exclusive inclusive rows x rows loops node
1. 13.899 27.796 ↓ 0.0 0 1

Update on import_vn.observations_json (cost=50.16..26,189.83 rows=25,460 width=991) (actual time=27.796..27.796 rows=0 loops=1)

2. 4.729 4.729 ↑ 25.3 1,006 1

Nested Loop (cost=50.16..26,189.83 rows=25,460 width=991) (actual time=2.318..4.729 rows=1,006 loops=1)

3. 2.390 2.390 ↑ 8.6 116 1

HashAggregate (cost=49.74..59.74 rows=1,000 width=40) (actual time=2.291..2.390 rows=116 loops=1)

4. 1.881 1.881 ↑ 1.0 1,000 1

Subquery Scan on ANY_subquery (cost=0.42..47.24 rows=1,000 width=40) (actual time=0.030..1.881 rows=1,000 loops=1)

5. 1.513 1.513 ↑ 1.0 1,000 1

Limit (cost=0.42..37.24 rows=1,000 width=8) (actual time=0.025..1.513 rows=1,000 loops=1)

6. 1.412 1.412 ↑ 44.7 1,000 1

Index Only Scan using observations_json_idx_id_form_universal on import_vn.observations_json observations_json_1 (cost=0.42..1,647.46 rows=44,739 width=8) (actual time=0.023..1.412 rows=1,000 loops=1)

7. 1.972 1.972 ↑ 2.8 9 116

Index Scan using observations_json_idx_id_form_universal on import_vn.observations_json (cost=0.42..25.88 rows=25 width=959) (actual time=0.010..0.017 rows=9 loops=116)

Planning time : 0.354 ms
Execution time : 25,391.243 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
observations_trigger 277.256 ms 1006 0.276 ms
obsfull_upsert_from_vn_trigger 24,511.838 ms 1006 24.366 ms
stoc_observation_upsert_from_vn_trigger 350.431 ms 1006 0.348 ms
stoc_releve_update_type_eps_from_vn_trigger 222.222 ms 1006 0.221 ms