Log In - Home Page

Patch: Separate pg_stat_activity into current_query into state and query columns

Edit Patch - Move To Another CommitFest - Delete Patch

CommitFest 2011-11
Topic Logging, Monitoring & Error Handling
Patch Status Returned with Feedback
Author Scott Mead
Reviewers Magnus Hagander, Greg Smith
Committer Nobody
Close Date 2011-12-15
Patch by smead on 2011-11-03 03:18:01 PM: Initial version.
Patch by smead on 2011-11-15 03:25:37 PM: v2

Changed all states to lower case
De-coupled waiting / state column
Changed 'WAITING' => 'active' (text in state column)
Review by gsmith on 2011-11-15 05:02:06 PM: Needs regression test fix, docs. May want to break more fields while doing this disruptive change.
Comment by smead on 2011-11-17 05:46:46 PM: query_start column needs consideration now that state / query are broken apart, telling the difference between how long a query has been in the system and how long we've been 'idle in transaction' for.
Patch by smead on 2011-11-19 02:17:25 AM: * Updated documentation
* Updated regression
* Renamed procpid => pid
* Added state_change (timestamp) to follow
the 'state' column
* Fixed minor bugs
- See message for details
Review by mha on 2011-12-06 11:39:35 AM: Another review, requiring some further changes

Add Comment

Please log in to comment on this patch.