[postgresql] Session monitor not working for pg9.6

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.

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?

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

Thank you very much for the hint about query compatibility. We will have it incorporated in version 10 expected sometime in the summer

	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?

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.