2013-08-24

Real-time console based monitoring of PostgreSQL databases (pg_view)

In many cases, it is important to be able to keep your hand on the pulse of your database in real-time. For example when you are running a big migration task that can introduce some unexpected locks, or when you are trying to understand how the current long running query is influencing your IO subsystem.

For a long time I was using a very simple bash alias that was injected from the .bashrc script and that included the calls to system utilities like watch, iostat, uptime, df, some additional statistics from the /proc/meminfo and psql that was extracting information about currently running queries and if that queries are waiting for a lock. But this approach had several disadvantages. In many cases I was interested in the disk read/write information for query processes or PostgreSQL system processes, like WAL and archive writers. Also I wanted to have a really easy way to notice the queries that are waiting for locks and probably highlight them by color.
Several weeks ago we finally open-sourced our new tool, that makes our lives much easier. That tool combines all the feature requests that I was dreaming of for a long time. Here it is: pg_view.

I already have some more feature requests actually and hope that Alexey will find some time to add them to the tool in nearest future. So if somebody wants to contribute or give some more ideas, please comment and open feature requests on the github page :)

12 comments:

Unknown said...

This looks pretty kick ass, thanks for FOSSing it. We'll be trying it out at our company.

-Jon Erdman (aka StuckMojo)

OBTW, I don't suppose you'd be interested in giving a lightning talk on it at the Postgres Open conference in Chicago Sept 16-18 (I'm on the planning committee)?

Details here: http://www.postgresopen.org/2013/home/

Anonymous said...

Very impressive indeed. I could see this becoming a core tool.

Unknown said...

Hello Jon,

I will be giving a talk at PGConf.EU in Dublin next month. And I suppose Alexey will give a lightening talk there about the tool as well.

Unfortunately I am not planning to coming to Chicago conference yet.

We will push some minor improvements to the tool next week :) So it will become even more usable, I hope :)

Unknown said...

That sounds really great. Thank you for sharing your experience, now i feel i have to try this! total defense internet security suite

Anonymous said...

I will be giving a talk at PGConf.EU in Dublin next month. And I suppose Alexey will give a lightening talk there about the tool as well.
wifihacker

Unknown said...

Such a excellent posting. Thank you so much!!!
arcsoft photoimpression

hashmi said...

Great post. I will be dealing with some of these issues
as well..Microsoft Office 2013 Professional Plus ISO [ Activator + Crack + Product + keygen ]

Rubina Khan said...

Thanks for sharing, this is a fantastic article.Thanks Again. Great.

driverpack solution 17

replacement said...

Such a excellent posting. Thank you so much!!! http://www.abcawards.co.uk/learners/replacement-certificates/

replacement said...

Such a excellent posting. Thank you so much!!!
http://www.abcawards.co.uk/learners/replacement-certificates/

MOMOTOM said...

Assuming you applied for your reestablished identification via mail or face-to-face with no sped-up assumptions, you can want to accept your new visa within 6 to about two months. Emergency Passport

l61bwnzypa said...

Minifaber is specialised in metal drawing, even deep-drawing, processes. Brushing is produced by sharpening the metal with grit leading to a unidirectional satin end. This is an electrochemical process of putting a secure oxide coating on the fabric, normally aluminum. If the hole is placed to close Madison Park Shower Curtains to the bend, the opening could turn into distorted or could act as an unintended aid cut.