Postgresql analyze8/30/2023 ![]() ![]() ![]() Output: s.id, s.setting_key, s.type, s.cap_id, s.current_value, s.source, s.rationale, s.created_date, s.last_modified_date, s.model_year, s.batch_adjustment_id, s.active, s.last_activated_at, s.setting_metadata_id, (max(setting_aud.revision_id))| I have added the following indexes: CREATE INDEX setting_type_active_id_idx ON setting (type, active, id) ĬREATE INDEX setting_aud_type_revision_type_id_revision_id_idx ON setting_aud (type, revision_type, id, revision_id) Īnd also executed EXPLAIN with VERBOSE option in order to see more information as suggested by Laurenz Albe, the results now are better: QUERY PLAN | How can I know where to put indexes looking into these results? How can I know how many iterations are executed in the Nested Loop join? > Parallel Seq Scan on setting_aud (cost=0.00. Worker 1: Sort Method: quicksort Memory: 59kB Worker 0: Sort Method: quicksort Memory: 59kB I'm using PostgreSQL 12.8 and I have the following result when executing the EXPLAIN ANALYZE command: I have read a bunch of resources on the internet and the official documentation of PostgreSQL and I still don't know how to interpret the result of a EXPLAIN ANALYZE.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |