{"id":175,"date":"2007-11-16T10:04:04","date_gmt":"2007-11-16T18:04:04","guid":{"rendered":"http:\/\/www.chesnok.com\/daily\/2007\/11\/16\/ptop-meeting-summary-from-last-nights-pdxpug\/"},"modified":"2012-03-26T02:57:10","modified_gmt":"2012-03-26T10:57:10","slug":"ptop-meeting-summary-from-last-nights-pdxpug","status":"publish","type":"post","link":"https:\/\/www.chesnok.com\/daily\/2007\/11\/16\/ptop-meeting-summary-from-last-nights-pdxpug\/","title":{"rendered":"ptop &#8211; meeting summary from last nights pdxpug"},"content":{"rendered":"<p>Last night&#8217;s meeting was about <a href=\"http:\/\/pgfoundry.org\/projects\/ptop\">ptop<\/a> and Mark Wong&#8217;s efforts to make an interactive, command-line tool for monitoring the current status of a PostgreSQL database.<\/p>\n<p>For our meeting, Mark set up a test operating system on a USB drive, and bravely demo&#8217;d his new software.<\/p>\n<p>Mark got the idea for ptop a few months ago, and went looking for the source code to top to get started. After a few days of hacking, he had a some useful features he wanted to share. So, he&#8217;s set up a project and started gathering developers:<\/p>\n<p><a href=\"http:\/\/pgfoundry.org\/projects\/ptop\">http:\/\/pgfoundry.org\/projects\/ptop<\/a><\/p>\n<p>The features currently supported include displaying:<\/p>\n<ul>\n<li>Current queries<\/li>\n<li>Query plans<\/li>\n<li>Locks<\/li>\n<li>User table statistics<\/li>\n<li>User index statistics<\/li>\n<\/ul>\n<p><!--more--><\/p>\n<p>One feature I particularly liked was showing deltas of statistics over time. So you set your ptop sampling interval to some value (i.e. 5 seconds) and then you can see, for example, user table statics<br \/>\nchanging over time. This is something I wrote some perl scripts for, but would love to have as a standard utility.  Particularly if I could log\/graph it.<\/p>\n<p>Currently, ptop is only compiling on Linux. I really want it on Mac OS X.<\/p>\n<p>We came up with a short list of desired features for the next revision of ptop:<\/p>\n<ul>\n<li>Change command line options to match psql (-U for user, -p for port, etc)<\/li>\n<li>Add command to show table (basically \\dt [tablename]) for non-query processes<\/li>\n<li>Enable arrow keys to move around in the content to select, instead<br \/>\nof cut\/paste process ID<\/li>\n<li>Log the stats deltas over time (i would be very interested in this)<\/li>\n<li>Change lock query to use an OUTER JOIN to show &#8220;waiting&#8221; locks that<br \/>\naren&#8217;t granted\n<\/li>\n<\/ul>\n<p>And just a general question that came up:<\/p>\n<ul>\n<li>Is it possible to peek at a currently executing SELECT statement&#8217;s plan?<br \/>\n       &#8211; We all agreed that this would be awesome.<\/li>\n<\/ul>\n<p>Thanks for a great meeting.<\/p>\n<hr>\n<p>Thank you Mark &#038; Gabrielle for sending out meeting announcements this month.<\/p>\n<p>NEXT MEETING: DIFFERENT DATE AND TIME!<\/p>\n<p><a href=\"http:\/\/pdxgroups.pbwiki.org\/2007%20December%20Coders%20Social\">December Coders Bash<\/a><br \/>\nTuesday, December 11, 2007<br \/>\nCubeSpace, 622 SE Grand Ave., Portland OR 97214<\/p>\n<p>Sam from the PHP Users group started organizing a group event in<br \/>\nDecember, inviting folks from all the different users groups to come<br \/>\nand socialize.<\/p>\n<p>ALSO a HACKATHON:<br \/>\nGabrielle, Mark and I thought it would be awesome to have a ptop HackAThon the weekend after Thanksgiving. Some possible features we&#8217;d work on are below. Anyone interested? Get in touch.  I was thinking the early afternoon on Saturday, or early evening on Sunday.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Last night&#8217;s meeting was about ptop and Mark Wong&#8217;s efforts to make an interactive, command-line tool for monitoring the current status of a PostgreSQL database. For our meeting, Mark set up a test operating system on a USB drive, and &hellip; <a href=\"https:\/\/www.chesnok.com\/daily\/2007\/11\/16\/ptop-meeting-summary-from-last-nights-pdxpug\/\">Continue reading &rarr;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,97,9,8,11],"tags":[647],"class_list":["post-175","post","type-post","status-publish","format-standard","hentry","category-pdxpug","category-postgres","category-postgresql","category-sysadmin","category-user-groups","tag-postgres"],"_links":{"self":[{"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/posts\/175","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/comments?post=175"}],"version-history":[{"count":1,"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/posts\/175\/revisions"}],"predecessor-version":[{"id":4056,"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/posts\/175\/revisions\/4056"}],"wp:attachment":[{"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/media?parent=175"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/categories?post=175"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/tags?post=175"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}