pg_stat_statements: can we extend the object names to the qualifiednames?
От | Sergei Agalakov |
---|---|
Тема | pg_stat_statements: can we extend the object names to the qualifiednames? |
Дата | |
Msg-id | 372d75cc-053b-1a07-948f-089408d3cd3a@gmail.com обсуждение исходный текст |
Ответы |
Re: pg_stat_statements: can we extend the object names to thequalified names?
Re: pg_stat_statements: can we extend the object names to thequalified names? |
Список | pgsql-general |
Hi, It would help to analyze performance issues if pg_stat_statements would extend the object names to the qualified names. Currently if we have two schemas ( say s1 and s2) with the objects with the same name ( say tables t1) then after the next executions: set schema 's1'; select count(*) from t1; // returns 10 set schema 's2'; select count(*) from t1; // returns 1000000000 we see in select queryid, query from pg_stat_statements where query like '%from t1%' something like this 3004391594 select count(*) from t1 1336375111 select count(*) from t1 We do see that the queries are different but we can't see why they are so much different in the execution time. If the pg_stat_statements module would extend the object name to the qualified names like s1.t1 and s2.t2 then we would see the report as 3004391594 select count(*) from s1.t1 1336375111 select count(*) from s2.t1 with an immediate understanding of what's going on. Obviously it would be even bigger help in the situations with the more complex queries where it will be mush more difficult to find that the query was executed with the incorrect search_path settings. Thank you, Sergei Agalakov
В списке pgsql-general по дате отправления: