[pgAdmin4][Patch] Statistics button not working for GreenPlum

[Joao De Almeida Pereira]

Hello Hackers,
Find attached a patch that enables the retrieval of statistics for
databases and servers on GreenPlum databases.


Thanks
Joao

diff --git 
a/web/pgadmin/browser/server_groups/servers/databases/templates/databases/sql/default/stats.sql
 
b/web/pgadmin/browser/server_groups/servers/databases/templates/databases/sql/default/stats.sql
index 5cc5d670..68ff711b 100644
--- 
a/web/pgadmin/browser/server_groups/servers/databases/templates/databases/sql/default/stats.sql
+++ 
b/web/pgadmin/browser/server_groups/servers/databases/templates/databases/sql/default/stats.sql
@@ -10,16 +10,9 @@ SELECT
     tup_inserted AS {{ conn|qtIdent(_('Tuples inserted')) }},
     tup_updated AS {{ conn|qtIdent(_('Tuples updated')) }},
     tup_deleted AS {{ conn|qtIdent(_('Tuples deleted')) }},
-    stats_reset AS {{ conn|qtIdent(_('Last statistics reset')) }},
-    slave.confl_tablespace AS {{ conn|qtIdent(_('Tablespace conflicts')) }},
-    slave.confl_lock AS {{ conn|qtIdent(_('Lock conflicts')) }},
-    slave.confl_snapshot AS {{ conn|qtIdent(_('Snapshot conflicts')) }},
-    slave.confl_bufferpin AS {{ conn|qtIdent(_('Bufferpin conflicts')) }},
-    slave.confl_deadlock AS {{ conn|qtIdent(_('Deadlock conflicts')) }},
     pg_database_size(db.datid) AS {{ conn|qtIdent(_('Size')) }}
 FROM
     pg_stat_database db
-    LEFT JOIN pg_stat_database_conflicts slave ON db.datid=slave.datid
 WHERE {% if did %}
 db.datid = {{ did|qtLiteral }}::OID{% else %}
 db.datid > {{ last_system_oid|qtLiteral }}::OID
diff --git 
a/web/pgadmin/browser/server_groups/servers/templates/servers/sql/default/stats.sql
 
b/web/pgadmin/browser/server_groups/servers/templates/servers/sql/default/stats.sql
index 62552190..f72e1ba8 100644
--- 
a/web/pgadmin/browser/server_groups/servers/templates/servers/sql/default/stats.sql
+++ 
b/web/pgadmin/browser/server_groups/servers/templates/servers/sql/default/stats.sql
@@ -4,8 +4,6 @@ SELECT
     datname AS {{ conn|qtIdent(_('Database')) }},
     backend_start AS {{ conn|qtIdent(_('Backend start')) }},
     CASE
-    WHEN client_hostname IS NOT NULL AND client_hostname != '' THEN
-        client_hostname || ':' || client_port
     WHEN client_addr IS NOT NULL AND client_addr::text != '' THEN
         client_addr::text || ':' || client_port
     WHEN client_port = -1 THEN
@@ -26,11 +24,9 @@ UNION
 SELECT
     procpid AS "PID",
     usename AS {{ conn|qtIdent(_('User')) }},
-    datname AS {{ conn|qtIdent(_('Database')) }},
+    '' AS {{ conn|qtIdent(_('Database')) }},
     backend_start AS {{ conn|qtIdent(_('Backend start')) }},
     CASE
-    WHEN client_hostname IS NOT NULL AND client_hostname != '' THEN
-        client_hostname || ':' || client_port
     WHEN client_addr IS NOT NULL AND client_addr::text != '' THEN
         client_addr::text || ':' || client_port
     WHEN client_port = -1 THEN
@@ -38,7 +34,7 @@ SELECT
     ELSE
         'localhost:' || client_port
     END AS {{ conn|qtIdent(_('Client')) }},
-    {{ _('Streaming Replication') }}|qtLiteral AS {{ 
conn|qtIdent(_('Application')) }},
+    {{ _('Streaming Replication')|qtLiteral }} AS {{ 
conn|qtIdent(_('Application')) }},
     null AS {{ conn|qtIdent(_('Waiting?')) }},
     state || ' [sync (state: ' || COALESCE(sync_state, '') || ', priority: ' 
|| sync_priority::text || ')] (' || sent_location || ' sent, ' || 
write_location || ' written, ' || flush_location || ' flushed, ' || 
replay_location || ' applied)' AS {{ conn|qtIdent(_('Query')) }},
     null AS {{ conn|qtIdent(_('Query start')) }},