Search Postgresql Archives

Re: monitor stats

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



hello again

if, but, I need it is real time not in archives

lynx /usr/share/doc/postgresql-8.1.8/html/monitoring-stats.html

SELECT pg_stat_get_backend_pid(s.backendid) AS procpid,
       pg_stat_get_backend_activity( s.backendid) AS current_query
    FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS s;

in 8.1.4

aslecol=# SELECT pg_stat_get_backend_pid(s.backendid) AS procpid,pg_stat_get_backend_activity(s.backendid ) AS current_query FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS s;
 procpid |                                                                                                                                                         current_q
uery                                                                                                                                                         
---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------
   25506 | <IDLE>
   25507 | select entidad,producto,num_doc,f_pago,to_char(sald_mora::numeric(12,2),'999,999, 999.99'),fecha,sald_mora::numeric(12,2) from bcsc_facics where 1=1 and fecha_car
ga in (select max(fecha_carga) from bcsc_facics where codcli='1448998') and bcsc_facics.codcli='1448998' order by fecha_carga desc,entidad,producto,num_doc 
   25524 | <IDLE>
    6447 | <IDLE>
     598 | <IDLE>

in 8.1.8

aslecol=# SELECT pg_stat_get_backend_pid(s.backendid) AS procpid,pg_stat_get_backend_activity(s.backendid) AS current_query FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS s;
 procpid | current_query
---------+---------------
(0 filas)




On 5/29/07, Shoaib Mir <shoaibmir@xxxxxxxxx > wrote:
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.hykova@xxxxxxxxx> 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@xxxxxxxxx > 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.hykova@xxxxxxxxx > 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@xxxxxxxxx > 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.hykova@xxxxxxxxx > 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







[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux