query-plan-1201
Change label- Query Plan as raw text
-
- Summary
-
Time Node Node (ms) Percent 0.032 100.00% ¶ Index Scan using acs_objects_pk on acs_objects (cost=0.0..3.08 rows=1 width=101) (actual time=0.027..0.032 rows=1 loops=1) Index Cond: (object_id = 1060926) Trigger for constraint acs_objects_context_id_fk: time=0.010 calls=1 Trigger for constraint acs_objects_modifying_user_fk: time=0.003 calls=1 Trigger acs_objects_context_id_up_tr: time=4953.315 calls=1 Trigger acs_objects_last_mod_update_tr: time=0.199 calls=1 Trigger acs_objects_update_tr: time=0.309 calls=1 - Run-time
- 4.963855 seconds (4963.855 ms)

ANALYZEto update the server's statistics.EXPLAINand interpreting its output, see the Postgres documentation, in particular theEXPLAINandANALYZEreferences pages, and Using Explain.