SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[postgresql] Session monitor not working for pg9.6

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[postgresql] Session monitor not working for pg9.6
Author Message
michalk



Joined: 29 Aug 2014
Posts: 211

Post [postgresql] Session monitor not working for pg9.6 Reply with quote
Please be adviced that pg_stat_activity has been changed in postgresql v9.6
Since this, SessionMonitor found in EA Editor doesn't work with this version and later.

To make it work, I created new Session Monitor entry in DB Queries duplicated a code for version 9.2 and then replaced line

Code:
CASE WHEN a.waiting THEN 'Waiting for a lock' END AS wait_type/*,

with
Code:
a.wait_event_type || ' / ' || a.wait_event AS wait_type,


Hope it'll help.
Please add this to official distribution.
Fri Apr 27, 2018 9:21 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7841

Post Reply with quote
Thank you very much for your feedback. This is very helpful. We will certainly incorporate it.

Just in case, did you know that you can add additional columns or expressions to the query if you see a fit for them?
Fri Apr 27, 2018 11:23 am View user's profile Send private message
michalk



Joined: 29 Aug 2014
Posts: 211

Post Reply with quote
Thanks for it.
I usually work with additional information, like:
Code:
NOW() - query_start AS query_time -- this is provided by default script actually,
  NOW() - backend_start AS backend_time,

so being able to extend original query is useful feature to me.


with regards
Wed May 02, 2018 4:33 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7841

Post Reply with quote
Thank you very much for the hint about query compatibility. We will have it incorporated in version 10 expected sometime in the summer
Wed May 02, 2018 12:20 pm View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2102

Post Reply with quote
SysOp wrote:
Thank you very much for the hint about query compatibility. We will have it incorporated in version 10 expected sometime in the summer


Oh, there will be v10 shortly? Would you mind opening a new topic with some hints (leaks :) on what will be in there?
Thu May 03, 2018 5:32 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7841

Post Reply with quote
I'm afraid I cannot list all new features until they make to the beta version, if they actually make it. Some of the big changes are graphical management UI for a number of databases, kind of more clicking, less typing;, the command palette (you likely guessed that one already) and some other.
Thu May 03, 2018 9:57 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.