PostgreSQL log query's result size
Hello Excuse me in advance for my English, I'm improving :-) Could you tell me if it is possible that as well as the configuration that the log presents the duration of the delayed queries, it can also present the size of the result data? especially those who want to return a lot of information -- Cordialmente, Ing. Hellmuth I. Vargas S.
Re: PostgreSQL log query's result size
?? Well, the truth does not show the data that I request, what I request is that by configuring some parameter, the size of the obtained records can be obtained from the execution of a query something similar to the log_min_duration_statement parameter Now I think it is pertinent to write here because, according to I have carefully reviewed the documentation, this functionality does not exist El mar, 6 de abr. de 2021 a la(s) 14:15, Justin Pryzby (pry...@telsasoft.com) escribió: > On Tue, Apr 06, 2021 at 02:03:03PM -0500, Hellmuth Vargas wrote: > > Could you tell me if it is possible that as well as the configuration > that > > the log presents the duration of the delayed queries, it can also present > > the size of the result data? especially those who want to return a lot of > > information > > I think you can get what you want by with auto_explain. > https://www.postgresql.org/docs/current/auto-explain.html > > You can set: > auto_explain.log_analyze > > And then the "width" and "rows" are logged: > Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.002..0.004 rows=1 > loops=1) > > PS, you should first ask on the pgsql-general list, rather than this > development list. > > -- > Justin > -- Cordialmente, Ing. Hellmuth I. Vargas S. Esp. Telemática y Negocios por Internet Oracle Database 10g Administrator Certified Associate EnterpriseDB Certified PostgreSQL 9.3 Associate
Re: PostgreSQL log query's result size
Thank you for the clarification. El mié, 7 de abr. de 2021 a la(s) 09:20, David G. Johnston ( david.g.johns...@gmail.com) escribió: > On Wed, Apr 7, 2021 at 7:13 AM Hellmuth Vargas wrote: > >> >> ?? Well, the truth does not show the data that I request, what I request >> is that by configuring some parameter, the size of the obtained records can >> be obtained from the execution of a query something similar to the >> log_min_duration_statement parameter >> > >> Now I think it is pertinent to write here because, according to I have >> carefully reviewed the documentation, this functionality does not exist >> > > You were provided the closest answer to what you wanted from what does > exist today. As you say, your exact request is not available. Feature > requests belong on pgsql-general, not psql-hackers. > > As this wasn't a question or request about active development work the > -general list is the preferred location. > > David J. > -- Cordialmente, Ing. Hellmuth I. Vargas S. Esp. Telemática y Negocios por Internet Oracle Database 10g Administrator Certified Associate EnterpriseDB Certified PostgreSQL 9.3 Associate
