Skip site navigation (1) Skip section navigation (2)

Re: monitor stats

From: "Shoaib Mir" <shoaibmir(at)gmail(dot)com>
To: "Diego Fernando Arce" <diegof(dot)hykova(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: monitor stats
Date: 2007-05-29 22:07:17
Message-ID: bf54be870705291507k6be0d961wb0da01a59dafdeab@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
Did you do a reload or restart of the server after doing this change?

what do you see when you do this query? --> show log_statement

--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 5/29/07, Diego Fernando Arce <diegof(dot)hykova(at)gmail(dot)com> wrote:
>
> this is a part of postgrsql.conf
>
>
> log_statement = 'all'                   # none, mod, ddl, all
> #log_hostname = off
>
>
>
> #---------------------------------------------------------------------------
> # RUNTIME STATISTICS
>
> #---------------------------------------------------------------------------
>
> # - Statistics Monitoring -
>
> #log_parser_stats = off
> #log_planner_stats = off
> #log_executor_stats = off
> #log_statement_stats = off
>
> # - Query/Index Statistics Collector -
>
> stats_start_collector = on
> stats_command_string = on
> #stats_block_level = off
> #stats_row_level = off
> #stats_reset_on_server_start = off
>
>
> *in 8.1.6 and 8.1.4 it works *
>
>
>
>
> On 5/29/07, Shoaib Mir <shoaibmir(at)gmail(dot)com> wrote:
> >
> > Did you try doing "log_statements = all" in your postgresql.conf file?
> >
> > --
> > Shoaib Mir
> > EnterpriseDB (www.enterprisedb.com)
> >
> > On 5/29/07, Diego Fernando Arce <diegof(dot)hykova(at)gmail(dot)com > wrote:
> > >
> > > hello, I have a question, does not work monitor stats in postgres
> > > 8.1.8
> > >
> > >  I cannot see querys in execution
> > >
> > > help me please..........
> > >
> > > DiegoF
> > >
> >
> >
>

In response to

Responses

pgsql-general by date

Next:From: Glen ParkerDate: 2007-05-29 22:23:03
Subject: Re: backup strategies
Previous:From: Diego Fernando ArceDate: 2007-05-29 22:03:01
Subject: Re: monitor stats

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group