Commit Diff

Commit:
38ccac73c2766394b277612a39dd41706d32e136
From:
Sergey Bronnikov <sergeyb@bronevichok.ru>
Via:
Sergey Bronnikov <s.bronnikov@postgrespro.ru>
Date:
Message:
Rename current_query to query in SQL There is no column current_query in pg_stat_activity table at least in PostgreSQL 9.6.1
Actions:
Patch | Tree
commit - 8845343df5568cc6a562ce10ff467174165c5331
commit + 38ccac73c2766394b277612a39dd41706d32e136
blob - 8e22da0602ac231be0fc7ed4ea629ed1c8ab47db
blob + 29d03bf9a731de1ca07f39fef5511d7119c9bb0d
--- pg-stat.py
+++ pg-stat.py
@@ -118,8 +118,8 @@ class PgStatStoreBigUserTables(PgStatStore):
 class PgStatStoreProc(PgStatStore):
 	def update(self):
 		ret = DB.execute_fetchall(con,
-			"SELECT current_query, COUNT(*) FROM pg_stat_activity " + \
-			"WHERE datname = '%s' GROUP BY current_query" % opts.db_name)
+			"SELECT query, COUNT(*) FROM pg_stat_activity " + \
+			"WHERE datname = '%s' GROUP BY query" % opts.db_name)
 
 		self.store = {}
 		for row in ret: