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 23:26:16 |
Message-ID: | bf54be870705291626m3a241606v606129e508163ea8@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Make sure there are some queries been executed on the server from
pg_stat_activity. Make sure your logging level for log files is such that it
can log the queries in db server log file.
In addition to log_statement you can also set log_min_duration_statement to
0 and that will also log queries in your log file.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.co,)
On 5/29/07, Diego Fernando Arce <diegof(dot)hykova(at)gmail(dot)com> wrote:
>
> 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.conffile?
> > > >
> > > > --
> > > > 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
> > > > >
> > > >
> > > >
> > >
> >
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Allison | 2007-05-29 23:28:14 | prepare() |
Previous Message | Raymond O'Donnell | 2007-05-29 23:25:08 | Re: 8.3 |