P.A.M. van Dam wrote:


I'd like to know if there is a way to see what queries are running
within a certain postgres instance and how much resources (cpu/memory)
etc. they are using. Right now it's impossible to see what is happening
within postgres when it's binaries are using 100% CPU.

In Sybase there is a command which let's you view what 'processes' are
running within the server and how much cpu (according to Sybase) they
are using. It also provides you with a stored procedure to kill off some
bad behaving queries. How can one do this within postgres?

Thanks in advance!

Best regards,


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

select * from pg_stat_activity. If you want to see the command that was run, you will need to turn on stats_command_string = true in postgresql.conf and re-start server. PID shows up, so you can kill bad queries from terminal and see CUP % in top

Roger Ging
V.P., Information Technology
Music Reports, Inc.

---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Reply via email to