RE: How to get the content of Bind variables

Hi Here is the information : postgres=# show log_error_verbosity ; log_error_verbosity - default (1 row) postgres=# show log_statement ; log_statement --- none (1 row) I am trying now to set up log_statement : log_statement=all ; log_min_duration_sta

Re: Performance regressions found using sqlfuzz

Hi Andres: Could you please share your thoughts on QUERY 3? The performance impact of this regression increases *linearly* on larger databases. We concur with Andrew in that this is related to the lack of a Materialize node and mis-costing of the Nested Loop Anti-Join. We found more than 20 r

Re: How to get the content of Bind variables

On Thu, Feb 28, 2019 at 12:21:56PM +, ROS Didier wrote: > Statement: update t_shared_liste_valeurs set deletion_date=$1, > deletion_login=$2, modification_date=$3, modification_login=$4, > administrable=$5, libelle=$6, niveau=$7 where code=$8 > > è how to get the content of the bind variable

RE: How to get the content of Bind variables

Hi Laurent Here is a biggest part of my log file : >> 2019-02-27 14:41:28 CET [16239]: [5696-1] [10086] user=pgbd_preint_sg2,db=pgbd_preint_sg2,client=localhost.localdomainLOG: duration: 1.604 ms 2019-02-27 14:41:28 CET [16239]: [5697-1] [10086] user=pgbd_preint_sg2,db=pgbd_preint_sg2,client

Re: How to get the content of Bind variables

ROS Didier wrote: >In the log file of my PostgreSQL cluster, I find : > >> > Statement: update t_shared_liste_valeurs set deletion_date=$1, > deletion_login=$2, modification_date=$3, modification_login=$4, > administrable=$5, libelle=$6, niveau=$7 where code=$8 > << > > how to

pgsql-performance@lists.postgresql.org

Thank you … Are the calculations for triggering autovacuum dependent upon statistics generated by auto-anaylyze. In other words, if autoanalyze does not run at all, will autovac be able to run its math for threshold (updates & deletes) & scale factor (table rows) to do its thing? My understand

RE: How to get the content of Bind variables

Hi Thanks for the answer. I have in my postgresql.conf : log_min_duration_statement=0 and the content of bind variables is not showed in the log file. What can I do to get the content of the bind variables ? Best Regard [cid:image002.png@01D14E0E.8515EB90] Didier ROS Expertise S

Re: How to get the content of Bind variables

If you set log_min_duration_statement low enough for your particular query, you will see another line below it showing what values are associated with each bind variable like this: 2019-02-28 00:07:55CST 2019-02-2800:02:09CST ihr2 10.86.42.184(43460) SELECT LOG: duration: 26078.308 ms execut

How to get the content of Bind variables

Hi In the log file of my PostgreSQL cluster, I find : >> Statement: update t_shared_liste_valeurs set deletion_date=$1, deletion_login=$2, modification_date=$3, modification_login=$4, administrable=$5, libelle=$6, niveau=$7 where code=$8 << è how to get the content of the bind va

Re: What is pg_stat_user_tables Showing NULL for last_autoanalyze & last_autovacuum

On Wed, 2019-02-27 at 09:47 -0500, Fd Habash wrote: > I have been able to locate four google search results with the same inquiry. > What’ve been able to understand is … > > If auto-vaccum is working as expected, stats collector does not nullify these > values as part of a > startup sequence or