Re: monitor stats

show log_statement;

log_statement
---------------
all
(1 fila)

select pg_stat_get_backend_pid(s.backendid),pg_stat_get_backend_activity(
s.backendid) from (select pg_stat_get_backend_idset() as backendid)s;

pg_stat_get_backend_pid | pg_stat_get_backend_activity
-------------------------+------------------------------
(0 filas)
executing in another terminal other query

On 5/30/07, Shoaib Mir <shoaibmir(at)gmail(dot)com> wrote:
>
> 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
> > > >
> > >
> > >
> >
>