Re: PG 8.3 and server load

От: Guillaume Cottenceau
Тема: Re: PG 8.3 and server load
Дата: ,
Msg-id: 87my5vsy2l.fsf@meuh.mnc.lan
(см: обсуждение, исходный текст)
Ответ на: Re: PG 8.3 and server load  (Ivan Voras)
Список: pgsql-performance

Скрыть дерево обсуждения

PG 8.3 and server load  (Phoenix Kiula, )
 Re: PG 8.3 and server load  (Ivan Voras, )
  Re: PG 8.3 and server load  (Guillaume Cottenceau, )
 Re: PG 8.3 and server load  (Andy Colson, )
  Re: PG 8.3 and server load  (Karl Denninger, )
 Re: PG 8.3 and server load  (Andy Colson, )
  Re: PG 8.3 and server load  (Phoenix Kiula, )
   Re: PG 8.3 and server load  (Matthew Wakeling, )
  Re: PG 8.3 and server load  ("Kevin Grittner", )
   Re: PG 8.3 and server load  (Andy Colson, )
    Re: PG 8.3 and server load  (Phoenix Kiula, )
     Re: PG 8.3 and server load  (Andy Colson, )
     Re: PG 8.3 and server load  (Tom Lane, )
     Re: PG 8.3 and server load  (Guillaume Cottenceau, )
     Re: PG 8.3 and server load  (Scott Marlowe, )
      Re: PG 8.3 and server load  (Ivan Voras, )

Ivan Voras <ivoras 'at' freebsd.org> writes:

> pgtop (http://pgfoundry.org/projects/pgtop/) might help you see what
> is your database doing.

A simpler (but most probably less powerful) method would be to
activate "stats_command_string = on" in the server configuration,
then issue that query to view the currently running queries:

SELECT procpid, datname, current_query, query_start FROM pg_stat_activity WHERE current_query <> '<IDLE>'

That may also be interesting.

--
Guillaume Cottenceau


В списке pgsql-performance по дате сообщения:

От: Kevin Kempter
Дата:
Сообщение: Re: Query tuning
От: Jaime Casanova
Дата:
Сообщение: [PERFORMANCE] how to set wal_buffers