query-plan-1204
Change label- Query Plan as raw text
-
- Summary
-
Time Node Node (ms) Percent 0.082 100.00% ¶ Index Scan using acs_objects_pk on acs_objects (cost=0.0..3.08 rows=1 width=101) (actual time=0.080..0.082 rows=1 loops=1) Index Cond: (object_id = 1060926) Trigger for constraint acs_objects_context_id_fk: time=0.005 calls=1 Trigger for constraint acs_objects_modifying_user_fk: time=0.002 calls=1 Trigger acs_objects_context_id_up_tr: time=4818.611 calls=1 Trigger acs_objects_last_mod_update_tr: time=0.030 calls=1 Trigger acs_objects_update_tr: time=0.024 calls=1 - Run-time
- 4.830796 seconds (4830.796 ms)

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