search

pgadmin-org / pgadmin4

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.
https://www.pgadmin.org
Other
2.53k stars 655 forks source link

pgAdmin Verrrry slow to connect to servers since v8 on mac #7150

Closed JessicaNandalKbra closed 8 months ago

JessicaNandalKbra commented 9 months ago

Config:

ALLOW_SAVE_PASSWORD = True
ALLOW_SAVE_TUNNEL_PASSWORD = False
APP_COPYRIGHT = "Copyright (C) 2013 - 2024, The pgAdmin Development Team"
APP_ICON = "pg-icon"
APP_NAME = "pgAdmin 4"
APP_RELEASE = 8
APP_REVISION = 2
APP_SUFFIX = ""
APP_VERSION = "8.2"
APP_VERSION_EXTN = ('.css', '.js', '.html', '.svg', '.png', '.gif', '.ico')
APP_VERSION_INT = 80200
APP_VERSION_PARAM = "ver"
AUTHENTICATION_SOURCES = ['internal']
AUTO_DISCOVER_SERVERS = True
AZURE_CREDENTIAL_CACHE_DIR = "/Users/jessica.nandal/.pgadmin/azurecredentialcache"
CA_FILE = "/Applications/pgAdmin 4.app/Contents/Resources/web/cacert.pem"
CHECK_EMAIL_DELIVERABILITY = False
CHECK_SESSION_FILES_INTERVAL = 24
CHECK_SUPPORTED_BROWSER = True
COMPRESS_LEVEL = 9
COMPRESS_MIMETYPES = ['text/html', 'text/css', 'text/xml', 'text/javascript', 'application/json', 'application/javascript']
COMPRESS_MIN_SIZE = 500
CONFIG_DATABASE_CONNECTION_MAX_OVERFLOW = 100
CONFIG_DATABASE_CONNECTION_POOL_SIZE = 5
CONFIG_DATABASE_URI = ""
CONSOLE_LOG_FORMAT = "%(asctime)s: %(levelname)s    %(name)s:   %(message)s"
CONSOLE_LOG_LEVEL = 30
CONTENT_SECURITY_POLICY = "default-src ws: http: data: blob: 'unsafe-inline' 'unsafe-eval';"
COOKIE_DEFAULT_DOMAIN = None
COOKIE_DEFAULT_PATH = "/"
DATA_DIR = "/Users/jessica.nandal/.pgadmin"
DEBUG = False
DEFAULT_BINARY_PATHS = {'pg': '$DIR/../../SharedSupport', 'ppas': ''}
DEFAULT_SERVER = "127.0.0.1"
DEFAULT_SERVER_PORT = 5050
DESKTOP_USER = "pgadmin4@pgadmin.org"
DISABLED_LOCAL_PASSWORD_STORAGE = False
EFFECTIVE_SERVER_PORT = 60961
ENABLE_BINARY_PATH_BROWSING = False
ENABLE_PSQL = True
ENHANCED_COOKIE_PROTECTION = True
FILE_LOG_FORMAT = "%(asctime)s: %(levelname)s   %(name)s:   %(message)s"
FILE_LOG_LEVEL = 30
HELP_PATH = "../../../docs/en_US/html/"
IS_WIN = False
KERBEROS_CCACHE_DIR = "/Users/jessica.nandal/.pgadmin/krbccache"
KEYRING_NAME = "macOS Keyring"
KRB_APP_HOST_NAME = "127.0.0.1"
KRB_AUTO_CREATE_USER = True
KRB_KTNAME = "<KRB5_KEYTAB_FILE>"
LANGUAGES = {'en': 'English', 'zh': 'Chinese (Simplified)', 'cs': 'Czech', 'fr': 'French', 'de': 'German', 'id': 'Indonesian', 'it': 'Italian', 'ja': 'Japanese', 'ko': 'Korean', 'pl': 'Polish', 'pt_BR': 'Portuguese (Brazilian)', 'ru': 'Russian', 'es': 'Spanish'}
LDAP_ANONYMOUS_BIND = False
LDAP_AUTO_CREATE_USER = True
LDAP_BASE_DN = "<Base-DN>"
LDAP_BIND_FORMAT = "{LDAP_USERNAME_ATTRIBUTE}={LDAP_USERNAME},{LDAP_BASE_DN}"
LDAP_BIND_USER = None
LDAP_CA_CERT_FILE = ""
LDAP_CERT_FILE = ""
LDAP_CONNECTION_TIMEOUT = 10
LDAP_DN_CASE_SENSITIVE = False
LDAP_IGNORE_MALFORMED_SCHEMA = False
LDAP_KEY_FILE = ""
LDAP_SEARCH_BASE_DN = "<Search-Base-DN>"
LDAP_SEARCH_FILTER = "(objectclass=*)"
LDAP_SEARCH_SCOPE = "SUBTREE"
LDAP_SERVER_URI = "ldap://<ip-address>:<port>"
LDAP_USERNAME_ATTRIBUTE = "<User-id>"
LDAP_USE_STARTTLS = False
LOGIN_ATTEMPT_FIELDS = ['password']
LOGIN_BANNER = ""
LOG_FILE = "/Users/jessica.nandal/.pgadmin/pgadmin4.log"
LOG_ROTATION_AGE = 1440
LOG_ROTATION_MAX_LOG_FILES = 90
LOG_ROTATION_SIZE = 10
MAIL_DEBUG = False
MAIL_PORT = 25
MAIL_SERVER = "localhost"
MAIL_USERNAME = ""
MAIL_USE_SSL = False
MAIL_USE_TLS = False
MASTER_PASSWORD_HOOK = None
MASTER_PASSWORD_REQUIRED = True
MAX_LOGIN_ATTEMPTS = 3
MAX_QUERY_HIST_STORED = 20
MAX_SESSION_IDLE_TIME = 60
MFA_EMAIL_SUBJECT = None
MFA_ENABLED = False
MFA_FORCE_REGISTRATION = False
MFA_SUPPORTED_METHODS = ['email', 'authenticator']
MODULE_BLACKLIST = ['test']
NODE_BLACKLIST = []
OAUTH2_AUTO_CREATE_USER = True
OAUTH2_CONFIG = [{'OAUTH2_NAME': None, 'OAUTH2_DISPLAY_NAME': '<Oauth2 Display Name>', 'OAUTH2_CLIENT_ID': None, 'OAUTH2_CLIENT_SECRET': None, 'OAUTH2_TOKEN_URL': None, 'OAUTH2_AUTHORIZATION_URL': None, 'OAUTH2_SERVER_METADATA_URL': None, 'OAUTH2_API_BASE_URL': None, 'OAUTH2_USERINFO_ENDPOINT': None, 'OAUTH2_SCOPE': None, 'OAUTH2_USERNAME_CLAIM': None, 'OAUTH2_ICON': None, 'OAUTH2_BUTTON_COLOR': None, 'OAUTH2_ADDITIONAL_CLAIMS': None, 'OAUTH2_SSL_CERT_VERIFICATION': True}]
ON_DEMAND_RECORD_COUNT = 1000
OVERRIDE_USER_INACTIVITY_TIMEOUT = True
PASSWORD_LENGTH_MIN = 6
PG_DEFAULT_DRIVER = "psycopg3"
PROXY_X_FOR_COUNT = 1
PROXY_X_HOST_COUNT = 0
PROXY_X_PORT_COUNT = 1
PROXY_X_PREFIX_COUNT = 0
PROXY_X_PROTO_COUNT = 1
SECURITY_EMAIL_SENDER = "no-reply@localhost"
SECURITY_EMAIL_SUBJECT_PASSWORD_CHANGE_NOTICE = "Your password for pgAdmin 4 has been changed"
SECURITY_EMAIL_SUBJECT_PASSWORD_NOTICE = "Your pgAdmin 4 password has been reset"
SECURITY_EMAIL_SUBJECT_PASSWORD_RESET = "Password reset instructions for pgAdmin 4"
SECURITY_EMAIL_VALIDATOR_ARGS = {'check_deliverability': False}
SEND_FILE_MAX_AGE_DEFAULT = 31556952
SERVER_HEARTBEAT_TIMEOUT = 30
SERVER_MODE = False
SESSION_COOKIE_DOMAIN = None
SESSION_COOKIE_HTTPONLY = True
SESSION_COOKIE_NAME = "pga4_session"
SESSION_COOKIE_SAMESITE = "Lax"
SESSION_COOKIE_SECURE = False
SESSION_DB_PATH = "/Users/jessica.nandal/.pgadmin/sessions"
SESSION_EXPIRATION_TIME = 7
SESSION_SKIP_PATHS = ['/misc/ping']
SETTINGS_SCHEMA_VERSION = 39
SHARED_STORAGE = []
SHOW_GRAVATAR_IMAGE = True
SQLALCHEMY_TRACK_MODIFICATIONS = False
SQLITE_PATH = "/Users/jessica.nandal/.pgadmin/pgadmin4.db"
SQLITE_TIMEOUT = 500
STORAGE_DIR = "/Users/jessica.nandal/.pgadmin/storage"
STRICT_TRANSPORT_SECURITY = "max-age=31536000; includeSubDomains"
STRICT_TRANSPORT_SECURITY_ENABLED = False
SUPPORT_SSH_TUNNEL = True
TEST_SQLITE_PATH = "/Users/jessica.nandal/.pgadmin/test_pgadmin4.db"
THREADED_MODE = True
UPGRADE_CHECK_ENABLED = True
UPGRADE_CHECK_KEY = "pgadmin4"
UPGRADE_CHECK_URL = "https://www.pgadmin.org/versions.json"
USER_INACTIVITY_TIMEOUT = 0
WEBSERVER_AUTO_CREATE_USER = True
WEBSERVER_REMOTE_USER = "REMOTE_USER"
WEB_SERVER = "Python"
WTF_CSRF_HEADERS = ['X-pgA-CSRFToken']
X_CONTENT_TYPE_OPTIONS = "nosniff"
X_FRAME_OPTIONS = "SAMEORIGIN"
X_XSS_PROTECTION = "1; mode=block"

Mac: 13.6.3 (22G436)

Ever since version 8, I have been having trouble connection to servers with PGAdmin4. I have just kept uninstalling 8 and going back to 7 as a work around.
I attached a screen.

Screen Recording 2024-01-23 at 10.35.09.mov.zip

We use PGAdmin for both local development (localhost) and connecting to our RDS clusters in AWS. We get the same results. They both hang - eventually they will connect, but due the performance degradation, it's just not usable.

yogeshmahajan-1903 commented 9 months ago

@JessicaNandalKbra

Can you please share log file $HOME/.pgadmin/pgadmin4.log? Also does server connect finally?

MysteriousNothing commented 9 months ago

Same on linux, I executing DELETE command that deletes 70 row, that should take 3-4s, it sometimes take 1m+, If I request app with other connection I can see data is gone

JessicaNandalKbra commented 9 months ago

It does connect but it takes a very, very long time. I ended up deleting the 8.2 and going back to 7.8.
If you need the log, I would have to delete the 7.8 and reinstall 8.2 (even 8.0 did not work - I was just hoping it would get fixed). Let me know if you would like me to do that.

JessicaNandalKbra commented 9 months ago

2024-01-30 11:48:49,507: WARNING werkzeug: Werkzeug appears to be used in a production deployment. Consider switching to a production web server instead. 2024-01-30 11:49:59,577: ERROR pgadmin: 401 Unauthorized: The server could not verify that you are authorized to access the URL requested. You either supplied the wrong credentials (e.g. a bad password), or your browser doesn't understand how to supply the credentials required. Traceback (most recent call last): File "/Applications/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.11/lib/python3.11/site-packages/flask/app.py", line 1821, in full_dispatch_request rv = self.preprocess_request() ^^^^^^^^^^^^^^^^^^^^^^^^^ File "/Applications/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.11/lib/python3.11/site-packages/flask/app.py", line 2313, in preprocess_request rv = self.ensure_sync(before_func)() ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ It's happening in 7.8.
It does connect it just takes a very long time.


  File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/__init__.py", line 815, in before_request
    abort(401)
  File "/Applications/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.11/lib/python3.11/site-packages/flask/helpers.py", line 310, in abort
    current_app.aborter(code, *args, **kwargs)
  File "/Applications/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.11/lib/python3.11/site-packages/werkzeug/exceptions.py", line 864, in __call__
    raise self.mapping[code](*args, **kwargs)
werkzeug.exceptions.Unauthorized: 401 Unauthorized: The server could not verify that you are authorized to access the URL requested. You either supplied the wrong credentials (e.g. a bad password), or your browser doesn't understand how to supply the credentials required.
jessica.nandal@K02386 ~>
JessicaNandalKbra commented 9 months ago

I turned on Debug Logging

2024-01-30 13:09:52,077: INFO   pgadmin:    ########################################################
2024-01-30 13:09:52,077: INFO   pgadmin:    Starting pgAdmin 4 v7.8...
2024-01-30 13:09:52,077: INFO   pgadmin:    ########################################################
2024-01-30 13:09:52,077: DEBUG  pgadmin:    Python syspath: ['/Applications/pgAdmin 4.app/Contents/Resources/web', '/Applications/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.11/lib/python311.zip', '/Applications/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.11/lib/python3.11', '/Applications/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.11/lib/python3.11/lib-dynload', '/Applications/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.11/lib/python3.11/site-packages']
2024-01-30 13:09:52,509: INFO   pgadmin:    Registering blueprint module: <AboutModule 'about'>
2024-01-30 13:09:52,510: INFO   pgadmin:    Registering blueprint module: <AuthenticateModule 'authenticate'>
2024-01-30 13:09:52,510: INFO   pgadmin:    Registering blueprint module: <BrowserModule 'browser'>
2024-01-30 13:09:53,094: INFO   pgadmin:    Registering blueprint module: <DashboardModule 'dashboard'>
2024-01-30 13:09:53,100: INFO   pgadmin:    Registering blueprint module: <DashboardModule 'dashboard'>
2024-01-30 13:09:53,100: INFO   pgadmin:    Registering blueprint module: <HelpModule 'help'>
2024-01-30 13:09:53,100: INFO   pgadmin:    Registering blueprint module: <MiscModule 'misc'>
2024-01-30 13:09:55,071: INFO   pgadmin:    Registering blueprint module: <PreferencesModule 'preferences'>
2024-01-30 13:09:55,072: INFO   pgadmin:    Registering blueprint module: <PgAdminModule 'redirects'>
2024-01-30 13:09:55,073: INFO   pgadmin:    Registering blueprint module: <SettingsModule 'settings'>
2024-01-30 13:09:55,074: INFO   pgadmin:    Registering blueprint module: <ToolsModule 'tools'>
2024-01-30 13:09:55,563: DEBUG  pgadmin:    Config server mode: False
2024-01-30 13:09:55,564: DEBUG  pgadmin:    Running under the desktop runtime, port: 62245
2024-01-30 13:09:55,564: DEBUG  pgadmin:    Desktop security key: d84e9b6e-722b-4365-9f6b-3e64add7a21d
2024-01-30 13:09:55,564: WARNING    werkzeug:   Werkzeug appears to be used in a production deployment. Consider switching to a production web server instead.
2024-01-30 13:09:55,566: INFO   werkzeug:   WARNING: This is a development server. Do not use it in a production deployment. Use a production WSGI server instead.
 * Running on http://127.0.0.1:62245
2024-01-30 13:09:55,566: INFO   werkzeug:   Press CTRL+C to quit
2024-01-30 13:09:55,790: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:55] "GET /misc/ping?key=d84e9b6e-722b-4365-9f6b-3e64add7a21d HTTP/1.1" 200 -
2024-01-30 13:09:55,859: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:55] "GET /?key=d84e9b6e-722b-4365-9f6b-3e64add7a21d HTTP/1.1" 302 -
2024-01-30 13:09:55,877: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:55] "GET /browser/ HTTP/1.1" 200 -
2024-01-30 13:09:55,891: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:55] "GET /static/js/generated/style.css?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:09:55,891: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:55] "GET /static/js/generated/pgadmin.style.css?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:09:55,892: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:55] "GET /static/vendor/require/require.min.js?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:09:55,893: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:55] "GET /static/js/generated/pgadmin.css?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:09:55,893: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:55] "GET /static/js/generated/vendor.main.js?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:09:55,899: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:55] "GET /static/js/generated/vendor.others.js?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:09:55,902: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:55] "GET /static/js/generated/pgadmin_commons.js?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:09:55,963: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:55] "GET /browser/browser.css?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:09:55,995: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:55] "GET /static/js/generated/fonts/Roboto-Regular..ttf HTTP/1.1" 200 -
2024-01-30 13:09:56,011: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:56] "GET /static/js/generated/app.bundle.js?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:09:56,011: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:56] "GET /static/js/generated/browser_nodes.js?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:09:56,011: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:56] "GET /static/js/generated/codemirror.js?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:09:56,061: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:56] "GET /browser/js/constants.js?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:09:56,062: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:56] "GET /browser/js/messages.js?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:09:56,063: DEBUG  pgadmin:    Failed to get the default locale.
2024-01-30 13:09:56,064: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:56] "GET /browser/server/supported_servers.js?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:09:56,067: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:56] "GET /browser/js/endpoints.js?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:09:56,081: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:56] "GET /user_management/current_user.js?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:09:56,085: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:56] "GET /browser/js/utils.js?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:09:56,088: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:56] "GET /static/js/gettext.js?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:09:56,088: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:56] "GET /static/js/pgadmin.js?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:09:56,089: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:56] "GET /tools/translations.js?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:09:56,446: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:56] "GET /static/css/webcabin.overrides.css?v=1706638196443 HTTP/1.1" 200 -
2024-01-30 13:09:56,532: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:56] "GET /browser/nodes/ HTTP/1.1" 200 -
2024-01-30 13:09:56,537: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:56] "GET /browser/check_corrupted_db_file HTTP/1.1" 200 -
2024-01-30 13:09:56,541: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:56] "GET /misc/bgprocess/ HTTP/1.1" 200 -
2024-01-30 13:09:56,551: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:56] "GET /static/js/generated/fonts/fa-solid-900..woff2 HTTP/1.1" 200 -
2024-01-30 13:09:56,583: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:56] "GET /browser/server_group/static/img/server_group.svg?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:09:56,583: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:56] "GET /static/js/generated/fonts/fa-regular-400..woff2 HTTP/1.1" 200 -
2024-01-30 13:09:56,692: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:56] "GET /favicon.ico?ver=70800 HTTP/1.1" 302 -
2024-01-30 13:09:56,700: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:56] "POST /browser/master_password HTTP/1.1" 200 -
2024-01-30 13:09:56,716: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:56] "POST /settings/store HTTP/1.1" 200 -
2024-01-30 13:09:56,716: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:56] "GET /static/favicon.ico?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:09:57,004: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:57] "GET /preferences/get_all HTTP/1.1" 200 -
2024-01-30 13:09:57,010: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:09:57] "GET /settings/get_tree_state/ HTTP/1.1" 200 -
2024-01-30 13:10:16,466: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:10:16] "GET /browser/server_group/children/3 HTTP/1.1" 200 -
2024-01-30 13:10:16,500: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:10:16] "GET /browser/server/static/img/serverbad.svg?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:10:16,689: INFO   pgadmin:    Connection Request for server#2
2024-01-30 13:10:16,770: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:10:16] "GET /browser/server/obj/3/2 HTTP/1.1" 200 -
2024-01-30 13:10:26,099: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:10:26] "POST /settings/store HTTP/1.1" 200 -
2024-01-30 13:10:27,025: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:10:27] "POST /settings/save_tree_state/ HTTP/1.1" 200 -
2024-01-30 13:10:27,035: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:10:27] "GET /settings/get_tree_state/ HTTP/1.1" 200 -
2024-01-30 13:12:19,175: INFO   pgadmin:    Connection Established for server:                 2 - RDS QA
2024-01-30 13:12:19,183: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 9839250):
SELECT CASE WHEN usesuper
       THEN pg_catalog.pg_is_in_recovery()
       ELSE FALSE
       END as inrecovery,
       CASE WHEN usesuper AND pg_catalog.pg_is_in_recovery()
       THEN pg_is_wal_replay_paused()
       ELSE FALSE
       END as isreplaypaused
FROM pg_catalog.pg_user WHERE usename=current_user
2024-01-30 13:12:19,226: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:12:19] "POST /browser/server/connect/3/2 HTTP/1.1" 200 -
2024-01-30 13:12:19,311: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:12:19] "GET /browser/server/static/img/pg.svg?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:12:19,369: SQL    pgadmin:    Execute (scalar) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 8792630):

SELECT
    has_table_privilege(
      'pgagent.pga_job', 'INSERT, SELECT, UPDATE'
    ) has_priviledge
WHERE EXISTS(
    SELECT has_schema_privilege('pgagent', 'USAGE')
    WHERE EXISTS(
        SELECT cl.oid FROM pg_catalog.pg_class cl
        LEFT JOIN pg_catalog.pg_namespace ns ON ns.oid=relnamespace
        WHERE relname='pga_job' AND nspname='pgagent'
    )
)

2024-01-30 13:12:19,418: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:12:19] "GET /browser/server/children/3/2 HTTP/1.1" 200 -
2024-01-30 13:12:19,437: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:12:19] "GET /browser/database/static/img/coll-database.svg?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:12:19,437: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:12:19] "GET /browser/role/static/img/coll-role.svg?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:12:19,438: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 3935609):
SELECT
    db.oid as did, db.datname as name, ta.spcname as spcname, db.datallowconn,
    db.datistemplate AS is_template,
    pg_catalog.has_database_privilege(db.oid, 'CREATE') as cancreate, datdba as owner,
    descr.description
FROM
    pg_catalog.pg_database db
    LEFT OUTER JOIN pg_catalog.pg_tablespace ta ON db.dattablespace = ta.oid
    LEFT OUTER JOIN pg_catalog.pg_shdescription descr ON (
        db.oid=descr.objoid AND descr.classoid='pg_database'::regclass
    )
WHERE         db.oid > 16383::OID OR db.datname IN ('postgres', 'edb')

ORDER BY datname;
2024-01-30 13:12:19,438: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:12:19] "GET /browser/tablespace/static/img/coll-tablespace.svg?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:12:19,486: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:12:19] "GET /browser/database/nodes/3/2/ HTTP/1.1" 200 -
2024-01-30 13:12:19,503: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 4843122):

SELECT
    db.oid as did, db.datname, db.datallowconn,
    pg_catalog.pg_encoding_to_char(db.encoding) AS serverencoding,
    pg_catalog.has_database_privilege(db.oid, 'CREATE') as cancreate,
    datistemplate
FROM
    pg_catalog.pg_database db
WHERE db.oid = 20522
2024-01-30 13:12:19,503: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 7880397):

SELECT
    db.oid as did, db.datname, db.datallowconn,
    pg_catalog.pg_encoding_to_char(db.encoding) AS serverencoding,
    pg_catalog.has_database_privilege(db.oid, 'CREATE') as cancreate,
    datistemplate
FROM
    pg_catalog.pg_database db
WHERE db.oid = 20522
2024-01-30 13:12:19,506: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 7490035):

SELECT
    db.oid as did, db.datname, db.datallowconn,
    pg_catalog.pg_encoding_to_char(db.encoding) AS serverencoding,
    pg_catalog.has_database_privilege(db.oid, 'CREATE') as cancreate,
    datistemplate
FROM
    pg_catalog.pg_database db
WHERE db.oid = 16400
2024-01-30 13:12:19,507: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 8924510):

SELECT
    db.oid as did, db.datname, db.datallowconn,
    pg_catalog.pg_encoding_to_char(db.encoding) AS serverencoding,
    pg_catalog.has_database_privilege(db.oid, 'CREATE') as cancreate,
    datistemplate
FROM
    pg_catalog.pg_database db
WHERE db.oid = 16400
2024-01-30 13:12:19,509: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:12:19] "GET /browser/database/static/img/databasebad.svg?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:12:19,509: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:12:19] "GET /browser/database/static/img/database.svg?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:12:27,043: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:12:27] "POST /settings/save_tree_state/ HTTP/1.1" 200 -
2024-01-30 13:12:27,048: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:12:27] "GET /settings/get_tree_state/ HTTP/1.1" 200 -
2024-01-30 13:12:49,330: DEBUG  pgadmin:    Heartbeat logged for the session id##server id: 82cd7750-f5fb-4b02-858b-f15d1c2cc69c##2
2024-01-30 13:12:49,347: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:12:49] "POST /misc/heartbeat/log HTTP/1.1" 200 -
2024-01-30 13:13:19,330: DEBUG  pgadmin:    Heartbeat logged for the session id##server id: 82cd7750-f5fb-4b02-858b-f15d1c2cc69c##2
2024-01-30 13:13:19,349: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:13:19] "POST /misc/heartbeat/log HTTP/1.1" 200 -
2024-01-30 13:13:49,328: DEBUG  pgadmin:    Heartbeat logged for the session id##server id: 82cd7750-f5fb-4b02-858b-f15d1c2cc69c##2
2024-01-30 13:13:49,363: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:13:49] "POST /misc/heartbeat/log HTTP/1.1" 200 -
2024-01-30 13:14:19,331: DEBUG  pgadmin:    Heartbeat logged for the session id##server id: 82cd7750-f5fb-4b02-858b-f15d1c2cc69c##2
2024-01-30 13:14:19,344: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:14:19] "POST /misc/heartbeat/log HTTP/1.1" 200 -
2024-01-30 13:14:22,161: INFO   pgadmin:    Connection Established for Database Id:                     20522
2024-01-30 13:14:22,194: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:14:22] "POST /browser/database/connect/3/2/20522 HTTP/1.1" 200 -
2024-01-30 13:14:24,340: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:14:24] "GET /browser/database/children/3/2/20522 HTTP/1.1" 200 -
2024-01-30 13:14:24,374: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:14:24] "GET /browser/catalog/static/img/coll-catalog.svg?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:14:24,374: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:14:24] "GET /browser/event_trigger/static/img/coll-event_trigger.svg?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:14:24,374: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:14:24] "GET /browser/extension/static/img/coll-extension.svg?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:14:24,374: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:14:24] "GET /browser/cast/static/img/coll-cast.svg?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:14:24,387: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:14:24] "GET /browser/foreign_data_wrapper/static/img/coll-foreign_data_wrapper.svg?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:14:24,387: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:14:24] "GET /browser/schema/static/img/coll-schema.svg?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:14:24,387: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:14:24] "GET /browser/publication/static/img/coll-publication.svg?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:14:24,387: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:14:24] "GET /browser/language/static/img/coll-language.svg?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:14:24,393: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:14:24] "GET /browser/subscription/static/img/coll-subscription.svg?ver=70800 HTTP/1.1" 200 -
2024-01-30 13:14:26,380: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:14:26] "GET /browser/database/children/3/2/16400 HTTP/1.1" 200 -
2024-01-30 13:14:27,061: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:14:27] "POST /settings/save_tree_state/ HTTP/1.1" 200 -
2024-01-30 13:14:27,070: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:14:27] "GET /settings/get_tree_state/ HTTP/1.1" 200 -
2024-01-30 13:14:28,283: INFO   pgadmin:    Connection Established for Database Id:                     16400
2024-01-30 13:14:28,305: INFO   werkzeug:   127.0.0.1 - - [30/Jan/2024 13:14:28] "POST /browser/database/connect/3/2/16400 HTTP/1.1" 200 -
yogeshmahajan-1903 commented 9 months ago

@JessicaNandalKbra Can you please install 8.2 and provide error logs? Also with newer version , please try to add new server and try to connect it.

JessicaNandalKbra commented 9 months ago

Updated to 8.2 Turned debug back on

jessica.nandal@K02386 ~/.pgadmin> cat pgadmin4.log
2024-02-02 16:30:27,250: INFO   pgadmin:    ########################################################
2024-02-02 16:30:27,250: INFO   pgadmin:    Starting pgAdmin 4 v8.2...
2024-02-02 16:30:27,251: INFO   pgadmin:    ########################################################
2024-02-02 16:30:27,251: DEBUG  pgadmin:    Python syspath: ['/Applications/pgAdmin 4.app/Contents/Resources/web', '/Applications/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.11/lib/python311.zip', '/Applications/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.11/lib/python3.11', '/Applications/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.11/lib/python3.11/lib-dynload', '/Applications/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.11/lib/python3.11/site-packages']
2024-02-02 16:30:29,074: INFO   pgadmin:    Registering blueprint module: <AboutModule 'about'>
2024-02-02 16:30:29,075: INFO   pgadmin:    Registering blueprint module: <AuthenticateModule 'authenticate'>
2024-02-02 16:30:29,075: INFO   pgadmin:    Registering blueprint module: <BrowserModule 'browser'>
2024-02-02 16:30:30,293: INFO   pgadmin:    Registering blueprint module: <DashboardModule 'dashboard'>
2024-02-02 16:30:30,298: INFO   pgadmin:    Registering blueprint module: <DashboardModule 'dashboard'>
2024-02-02 16:30:30,298: INFO   pgadmin:    Registering blueprint module: <HelpModule 'help'>
2024-02-02 16:30:30,298: INFO   pgadmin:    Registering blueprint module: <MiscModule 'misc'>
2024-02-02 16:30:33,427: INFO   pgadmin:    Registering blueprint module: <PreferencesModule 'preferences'>
2024-02-02 16:30:33,428: INFO   pgadmin:    Registering blueprint module: <PgAdminModule 'redirects'>
2024-02-02 16:30:33,429: INFO   pgadmin:    Registering blueprint module: <SettingsModule 'settings'>
2024-02-02 16:30:33,431: INFO   pgadmin:    Registering blueprint module: <ToolsModule 'tools'>
2024-02-02 16:30:34,954: DEBUG  pgadmin:    Config server mode: False
2024-02-02 16:30:34,955: DEBUG  pgadmin:    Running under the desktop runtime, port: 60490
2024-02-02 16:30:34,958: DEBUG  pgadmin:    Desktop security key: f5b5c397-b58b-47ec-9a80-e10a21967857
2024-02-02 16:30:35,120: WARNING    werkzeug:   Werkzeug appears to be used in a production deployment. Consider switching to a production web server instead.
2024-02-02 16:30:35,124: INFO   werkzeug:   WARNING: This is a development server. Do not use it in a production deployment. Use a production WSGI server instead.
 * Running on http://127.0.0.1:60490
2024-02-02 16:30:35,124: INFO   werkzeug:   Press CTRL+C to quit
2024-02-02 16:30:35,620: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:35] "GET /misc/ping?key=f5b5c397-b58b-47ec-9a80-e10a21967857 HTTP/1.1" 200 -
2024-02-02 16:30:35,701: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:35] "GET /?key=f5b5c397-b58b-47ec-9a80-e10a21967857 HTTP/1.1" 302 -
2024-02-02 16:30:35,724: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:35] "GET /browser/ HTTP/1.1" 200 -
2024-02-02 16:30:35,750: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:35] "GET /static/js/generated/style.css?ver=80200 HTTP/1.1" 200 -
2024-02-02 16:30:35,750: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:35] "GET /static/js/generated/pgadmin.style.css?ver=80200 HTTP/1.1" 200 -
2024-02-02 16:30:35,756: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:35] "GET /static/js/generated/vendor.react.js?ver=80200 HTTP/1.1" 200 -
2024-02-02 16:30:35,757: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:35] "GET /static/vendor/require/require.min.js?ver=80200 HTTP/1.1" 200 -
2024-02-02 16:30:35,758: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:35] "GET /static/js/generated/pgadmin.css?ver=80200 HTTP/1.1" 200 -
2024-02-02 16:30:35,758: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:35] "GET /static/js/generated/vendor.main.js?ver=80200 HTTP/1.1" 200 -
2024-02-02 16:30:35,761: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:35] "GET /static/js/generated/vendor.others.js?ver=80200 HTTP/1.1" 200 -
2024-02-02 16:30:35,763: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:35] "GET /static/js/generated/vendor.sqleditor.js?ver=80200 HTTP/1.1" 200 -
2024-02-02 16:30:35,770: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:35] "GET /static/js/generated/pgadmin_commons.js?ver=80200 HTTP/1.1" 200 -
2024-02-02 16:30:35,821: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:35] "GET /browser/browser.css?ver=80200 HTTP/1.1" 200 -
2024-02-02 16:30:35,864: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:35] "GET /static/js/generated/fonts/Roboto-Regular..ttf HTTP/1.1" 200 -
2024-02-02 16:30:35,865: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:35] "GET /static/js/generated/app.bundle.js?ver=80200 HTTP/1.1" 200 -
2024-02-02 16:30:35,865: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:35] "GET /static/js/generated/codemirror.js?ver=80200 HTTP/1.1" 200 -
2024-02-02 16:30:35,865: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:35] "GET /static/js/generated/browser_nodes.js?ver=80200 HTTP/1.1" 200 -
2024-02-02 16:30:35,914: DEBUG  pgadmin:    Failed to get the default locale.
2024-02-02 16:30:35,935: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:35] "GET /browser/js/messages.js?ver=80200 HTTP/1.1" 200 -
2024-02-02 16:30:35,938: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:35] "GET /browser/js/endpoints.js?ver=80200 HTTP/1.1" 200 -
2024-02-02 16:30:35,947: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:35] "GET /tools/translations.js?ver=80200 HTTP/1.1" 200 -
2024-02-02 16:30:35,948: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:35] "GET /user_management/current_user.js?ver=80200 HTTP/1.1" 200 -
2024-02-02 16:30:35,949: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:35] "GET /browser/server/supported_servers.js?ver=80200 HTTP/1.1" 200 -
2024-02-02 16:30:35,956: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:35] "GET /browser/js/utils.js?ver=80200 HTTP/1.1" 200 -
2024-02-02 16:30:35,956: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:35] "GET /static/js/gettext.js?ver=80200 HTTP/1.1" 200 -
2024-02-02 16:30:35,957: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:35] "GET /static/js/pgadmin.js?ver=80200 HTTP/1.1" 200 -
2024-02-02 16:30:36,290: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:36] "GET /browser/check_corrupted_db_file HTTP/1.1" 200 -
2024-02-02 16:30:36,294: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:36] "GET /misc/bgprocess/ HTTP/1.1" 200 -
2024-02-02 16:30:36,314: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:36] "GET /preferences/get_all HTTP/1.1" 200 -
2024-02-02 16:30:36,377: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:36] "GET /settings/get_tree_state/ HTTP/1.1" 200 -
2024-02-02 16:30:36,444: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:36] "GET /browser/nodes/ HTTP/1.1" 200 -
2024-02-02 16:30:36,483: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:36] "GET /misc/upgrade_check HTTP/1.1" 200 -
2024-02-02 16:30:36,506: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:36] "GET /favicon.ico?ver=80200 HTTP/1.1" 302 -
2024-02-02 16:30:36,510: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:36] "GET /static/js/generated/fonts/fa-solid-900..woff2 HTTP/1.1" 200 -
2024-02-02 16:30:36,510: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:36] "GET /static/js/generated/fonts/SourceCodePro-Regular..ttf HTTP/1.1" 200 -
2024-02-02 16:30:36,538: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:36] "GET /static/favicon.ico?ver=80200 HTTP/1.1" 200 -
2024-02-02 16:30:36,556: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:36] "GET /browser/server_group/static/img/server_group.svg?ver=80200 HTTP/1.1" 200 -
2024-02-02 16:30:36,557: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:36] "GET /static/js/generated/fonts/fa-regular-400..woff2 HTTP/1.1" 200 -
2024-02-02 16:30:36,609: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:36] "POST /browser/master_password HTTP/1.1" 200 -
2024-02-02 16:30:50,925: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:50] "GET /browser/server_group/children/3 HTTP/1.1" 200 -
2024-02-02 16:30:50,977: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:50] "GET /browser/server/static/img/serverbad.svg?ver=80200 HTTP/1.1" 200 -
2024-02-02 16:30:51,157: INFO   pgadmin:    Connection Request for server#2
2024-02-02 16:30:51,516: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:51] "GET /browser/server/obj/3/2 HTTP/1.1" 200 -
2024-02-02 16:30:51,519: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:30:51] "GET /browser/server_group/nodes/ HTTP/1.1" 200 -
2024-02-02 16:31:06,400: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:31:06] "POST /settings/save_tree_state/ HTTP/1.1" 200 -
2024-02-02 16:31:06,422: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:31:06] "GET /settings/get_tree_state/ HTTP/1.1" 200 -
2024-02-02 16:32:54,368: INFO   pgadmin:    Connection Established for server:                 2 - RDS QA
2024-02-02 16:32:54,385: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 3079817):
SELECT CASE WHEN usesuper
       THEN pg_catalog.pg_is_in_recovery()
       ELSE FALSE
       END as inrecovery,
       CASE WHEN usesuper AND pg_catalog.pg_is_in_recovery()
       THEN pg_is_wal_replay_paused()
       ELSE FALSE
       END as isreplaypaused
FROM pg_catalog.pg_user WHERE usename=current_user
2024-02-02 16:32:54,463: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:32:54] "POST /browser/server/connect/3/2 HTTP/1.1" 200 -
2024-02-02 16:32:54,537: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:32:54] "GET /browser/server/static/img/pg.svg?ver=80200 HTTP/1.1" 200 -
2024-02-02 16:32:54,566: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 9452112):
/*pga4dash*/
SELECT
    pid,
    datname,
    usename,
    application_name,
    client_addr,
    pg_catalog.to_char(backend_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS backend_start,
    state,
    wait_event_type || ': ' || wait_event AS wait_event,
    array_to_string(pg_catalog.pg_blocking_pids(pid), ', ') AS blocking_pids,
    query,
    pg_catalog.to_char(state_change, 'YYYY-MM-DD HH24:MI:SS TZ') AS state_change,
    pg_catalog.to_char(query_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS query_start,
    pg_catalog.to_char(xact_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS xact_start,
    backend_type,
    CASE WHEN state = 'active' THEN ROUND((extract(epoch from now() - query_start) / 60)::numeric, 2) ELSE 0 END AS active_since
FROM
    pg_catalog.pg_stat_activity
ORDER BY pid
2024-02-02 16:32:54,618: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:32:54] "GET /dashboard/activity/2 HTTP/1.1" 200 -
2024-02-02 16:32:54,622: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 5020567):
/*pga4dash*/
SELECT
    pid,
    datname,
    usename,
    application_name,
    client_addr,
    pg_catalog.to_char(backend_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS backend_start,
    state,
    wait_event_type || ': ' || wait_event AS wait_event,
    array_to_string(pg_catalog.pg_blocking_pids(pid), ', ') AS blocking_pids,
    query,
    pg_catalog.to_char(state_change, 'YYYY-MM-DD HH24:MI:SS TZ') AS state_change,
    pg_catalog.to_char(query_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS query_start,
    pg_catalog.to_char(xact_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS xact_start,
    backend_type,
    CASE WHEN state = 'active' THEN ROUND((extract(epoch from now() - query_start) / 60)::numeric, 2) ELSE 0 END AS active_since
FROM
    pg_catalog.pg_stat_activity
ORDER BY pid
2024-02-02 16:32:54,633: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:32:54] "GET /dashboard/dashboard_stats/2?chart_names= HTTP/1.1" 200 -
2024-02-02 16:32:54,642: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 2861866):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_catalog.pg_stat_activity) AS "Total",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active')  AS "Active",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle')  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_catalog.pg_stat_database) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database) AS "Hits"
) t

2024-02-02 16:32:54,668: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:32:54] "GET /dashboard/activity/2 HTTP/1.1" 200 -
2024-02-02 16:32:54,717: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:32:54] "GET /dashboard/dashboard_stats/2?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1" 200 -
2024-02-02 16:32:54,773: SQL    pgadmin:    Execute (scalar) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 3162297):

SELECT
    has_table_privilege(
      'pgagent.pga_job', 'INSERT, SELECT, UPDATE'
    ) has_priviledge
WHERE EXISTS(
    SELECT has_schema_privilege('pgagent', 'USAGE')
    WHERE EXISTS(
        SELECT cl.oid FROM pg_catalog.pg_class cl
        LEFT JOIN pg_catalog.pg_namespace ns ON ns.oid=relnamespace
        WHERE relname='pga_job' AND nspname='pgagent'
    )
)

2024-02-02 16:32:54,824: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:32:54] "GET /browser/server/children/3/2 HTTP/1.1" 200 -
2024-02-02 16:32:54,940: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:32:54] "GET /browser/database/static/img/coll-database.svg?ver=80200 HTTP/1.1" 200 -
2024-02-02 16:32:54,940: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:32:54] "GET /browser/role/static/img/coll-role.svg?ver=80200 HTTP/1.1" 200 -
2024-02-02 16:32:54,941: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:32:54] "GET /browser/tablespace/static/img/coll-tablespace.svg?ver=80200 HTTP/1.1" 200 -
2024-02-02 16:32:54,944: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 8495118):
SELECT
    db.oid as did, db.datname as name, ta.spcname as spcname, db.datallowconn,
    db.datistemplate AS is_template,
    pg_catalog.has_database_privilege(db.oid, 'CREATE') as cancreate, datdba as owner,
    descr.description
FROM
    pg_catalog.pg_database db
    LEFT OUTER JOIN pg_catalog.pg_tablespace ta ON db.dattablespace = ta.oid
    LEFT OUTER JOIN pg_catalog.pg_shdescription descr ON (
        db.oid=descr.objoid AND descr.classoid='pg_database'::regclass
    )
WHERE         db.oid > 16383::OID OR db.datname IN ('postgres', 'edb')

ORDER BY datname;
2024-02-02 16:32:54,984: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:32:54] "GET /browser/database/nodes/3/2/ HTTP/1.1" 200 -
2024-02-02 16:32:55,015: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 2286468):

SELECT
    db.oid as did, db.datname, db.datallowconn,
    pg_catalog.pg_encoding_to_char(db.encoding) AS serverencoding,
    pg_catalog.has_database_privilege(db.oid, 'CREATE') as cancreate,
    datistemplate
FROM
    pg_catalog.pg_database db
WHERE db.oid = 20522
2024-02-02 16:32:55,016: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 8633506):

SELECT
    db.oid as did, db.datname, db.datallowconn,
    pg_catalog.pg_encoding_to_char(db.encoding) AS serverencoding,
    pg_catalog.has_database_privilege(db.oid, 'CREATE') as cancreate,
    datistemplate
FROM
    pg_catalog.pg_database db
WHERE db.oid = 20522
2024-02-02 16:32:55,016: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 6918885):

SELECT
    db.oid as did, db.datname, db.datallowconn,
    pg_catalog.pg_encoding_to_char(db.encoding) AS serverencoding,
    pg_catalog.has_database_privilege(db.oid, 'CREATE') as cancreate,
    datistemplate
FROM
    pg_catalog.pg_database db
WHERE db.oid = 16400
2024-02-02 16:32:55,016: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 9643441):

SELECT
    db.oid as did, db.datname, db.datallowconn,
    pg_catalog.pg_encoding_to_char(db.encoding) AS serverencoding,
    pg_catalog.has_database_privilege(db.oid, 'CREATE') as cancreate,
    datistemplate
FROM
    pg_catalog.pg_database db
WHERE db.oid = 16400
2024-02-02 16:32:55,026: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:32:55] "GET /browser/database/static/img/databasebad.svg?ver=80200 HTTP/1.1" 200 -
2024-02-02 16:32:55,026: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:32:55] "GET /browser/database/static/img/database.svg?ver=80200 HTTP/1.1" 200 -
2024-02-02 16:32:59,581: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 1837149):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_catalog.pg_stat_activity) AS "Total",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active')  AS "Active",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle')  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_catalog.pg_stat_database) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database) AS "Hits"
) t

2024-02-02 16:32:59,658: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:32:59] "GET /dashboard/dashboard_stats/2?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1" 200 -
2024-02-02 16:33:04,583: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 9479193):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_catalog.pg_stat_activity) AS "Total",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active')  AS "Active",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle')  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_catalog.pg_stat_database) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database) AS "Hits"
) t

2024-02-02 16:33:04,653: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:33:04] "GET /dashboard/dashboard_stats/2?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1" 200 -
2024-02-02 16:33:06,389: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:33:06] "POST /settings/save_tree_state/ HTTP/1.1" 200 -
2024-02-02 16:33:06,394: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:33:06] "GET /settings/get_tree_state/ HTTP/1.1" 200 -
2024-02-02 16:33:09,581: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 4455777):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_catalog.pg_stat_activity) AS "Total",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active')  AS "Active",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle')  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_catalog.pg_stat_database) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database) AS "Hits"
) t

2024-02-02 16:33:09,652: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:33:09] "GET /dashboard/dashboard_stats/2?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1" 200 -
2024-02-02 16:33:14,602: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 4527495):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_catalog.pg_stat_activity) AS "Total",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active')  AS "Active",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle')  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_catalog.pg_stat_database) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database) AS "Hits"
) t

2024-02-02 16:33:14,675: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:33:14] "GET /dashboard/dashboard_stats/2?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1" 200 -
2024-02-02 16:33:19,589: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 8670758):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_catalog.pg_stat_activity) AS "Total",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active')  AS "Active",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle')  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_catalog.pg_stat_database) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database) AS "Hits"
) t

2024-02-02 16:33:19,651: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:33:19] "GET /dashboard/dashboard_stats/2?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1" 200 -
2024-02-02 16:33:24,547: DEBUG  pgadmin:    Heartbeat logged for the session id##server id: 87eaca6a-e239-455c-a30c-c51c44a4e025##2
2024-02-02 16:33:24,572: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:33:24] "POST /misc/heartbeat/log HTTP/1.1" 200 -
2024-02-02 16:33:24,604: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 4303731):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_catalog.pg_stat_activity) AS "Total",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active')  AS "Active",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle')  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_catalog.pg_stat_database) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database) AS "Hits"
) t

2024-02-02 16:33:24,674: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:33:24] "GET /dashboard/dashboard_stats/2?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1" 200 -
2024-02-02 16:33:29,593: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 3946143):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_catalog.pg_stat_activity) AS "Total",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active')  AS "Active",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle')  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_catalog.pg_stat_database) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database) AS "Hits"
) t

2024-02-02 16:33:29,693: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:33:29] "GET /dashboard/dashboard_stats/2?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1" 200 -
2024-02-02 16:33:33,718: SQL    pgadmin:    Execute (scalar) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 4785617):
SELECT * FROM pg_extension WHERE extname = 'system_stats';
2024-02-02 16:33:33,779: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:33:33] "GET /dashboard/check_extension/system_statistics/2 HTTP/1.1" 200 -
2024-02-02 16:33:34,583: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 512750):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_catalog.pg_stat_activity) AS "Total",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active')  AS "Active",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle')  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_catalog.pg_stat_database) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database) AS "Hits"
) t

2024-02-02 16:33:34,654: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:33:34] "GET /dashboard/dashboard_stats/2?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1" 200 -
2024-02-02 16:33:36,676: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 7908267):
/*pga4dash*/
SELECT
    pid,
    datname,
    usename,
    application_name,
    client_addr,
    pg_catalog.to_char(backend_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS backend_start,
    state,
    wait_event_type || ': ' || wait_event AS wait_event,
    array_to_string(pg_catalog.pg_blocking_pids(pid), ', ') AS blocking_pids,
    query,
    pg_catalog.to_char(state_change, 'YYYY-MM-DD HH24:MI:SS TZ') AS state_change,
    pg_catalog.to_char(query_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS query_start,
    pg_catalog.to_char(xact_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS xact_start,
    backend_type,
    CASE WHEN state = 'active' THEN ROUND((extract(epoch from now() - query_start) / 60)::numeric, 2) ELSE 0 END AS active_since
FROM
    pg_catalog.pg_stat_activity
ORDER BY pid
2024-02-02 16:33:36,723: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:33:36] "GET /dashboard/activity/2 HTTP/1.1" 200 -
2024-02-02 16:33:39,582: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 3224913):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_catalog.pg_stat_activity) AS "Total",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active')  AS "Active",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle')  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_catalog.pg_stat_database) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database) AS "Hits"
) t

2024-02-02 16:33:39,644: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:33:39] "GET /dashboard/dashboard_stats/2?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1" 200 -
2024-02-02 16:33:44,584: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 8824381):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_catalog.pg_stat_activity) AS "Total",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active')  AS "Active",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle')  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_catalog.pg_stat_database) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database) AS "Hits"
) t

2024-02-02 16:33:44,664: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:33:44] "GET /dashboard/dashboard_stats/2?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1" 200 -
2024-02-02 16:33:49,590: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 9657407):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_catalog.pg_stat_activity) AS "Total",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active')  AS "Active",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle')  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_catalog.pg_stat_database) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database) AS "Hits"
) t

2024-02-02 16:33:49,660: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:33:49] "GET /dashboard/dashboard_stats/2?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1" 200 -
2024-02-02 16:33:54,551: DEBUG  pgadmin:    Heartbeat logged for the session id##server id: 87eaca6a-e239-455c-a30c-c51c44a4e025##2
2024-02-02 16:33:54,554: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:33:54] "POST /misc/heartbeat/log HTTP/1.1" 200 -
2024-02-02 16:33:54,586: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 5494052):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_catalog.pg_stat_activity) AS "Total",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active')  AS "Active",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle')  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_catalog.pg_stat_database) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database) AS "Hits"
) t

2024-02-02 16:33:54,646: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:33:54] "GET /dashboard/dashboard_stats/2?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1" 200 -
2024-02-02 16:33:59,590: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 8961195):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_catalog.pg_stat_activity) AS "Total",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active')  AS "Active",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle')  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_catalog.pg_stat_database) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database) AS "Hits"
) t

2024-02-02 16:33:59,653: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:33:59] "GET /dashboard/dashboard_stats/2?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1" 200 -
2024-02-02 16:34:04,585: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 2425504):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_catalog.pg_stat_activity) AS "Total",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active')  AS "Active",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle')  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_catalog.pg_stat_database) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database) AS "Hits"
) t

2024-02-02 16:34:04,658: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:34:04] "GET /dashboard/dashboard_stats/2?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1" 200 -
2024-02-02 16:34:09,585: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 7127835):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_catalog.pg_stat_activity) AS "Total",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active')  AS "Active",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle')  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_catalog.pg_stat_database) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database) AS "Hits"
) t

2024-02-02 16:34:09,659: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:34:09] "GET /dashboard/dashboard_stats/2?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1" 200 -
2024-02-02 16:34:14,584: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 2202748):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_catalog.pg_stat_activity) AS "Total",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active')  AS "Active",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle')  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_catalog.pg_stat_database) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database) AS "Hits"
) t

2024-02-02 16:34:14,658: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:34:14] "GET /dashboard/dashboard_stats/2?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1" 200 -
2024-02-02 16:34:19,595: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 5445280):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_catalog.pg_stat_activity) AS "Total",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active')  AS "Active",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle')  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_catalog.pg_stat_database) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database) AS "Hits"
) t

2024-02-02 16:34:19,656: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:34:19] "GET /dashboard/dashboard_stats/2?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1" 200 -
2024-02-02 16:34:24,555: DEBUG  pgadmin:    Heartbeat logged for the session id##server id: 87eaca6a-e239-455c-a30c-c51c44a4e025##2
2024-02-02 16:34:24,562: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:34:24] "POST /misc/heartbeat/log HTTP/1.1" 200 -
2024-02-02 16:34:24,599: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 5397026):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_catalog.pg_stat_activity) AS "Total",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active')  AS "Active",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle')  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_catalog.pg_stat_database) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database) AS "Hits"
) t

2024-02-02 16:34:24,676: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:34:24] "GET /dashboard/dashboard_stats/2?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1" 200 -
2024-02-02 16:34:29,594: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 928310):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_catalog.pg_stat_activity) AS "Total",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active')  AS "Active",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle')  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_catalog.pg_stat_database) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database) AS "Hits"
) t

2024-02-02 16:34:29,675: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:34:29] "GET /dashboard/dashboard_stats/2?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1" 200 -
2024-02-02 16:34:34,585: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 8515982):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_catalog.pg_stat_activity) AS "Total",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active')  AS "Active",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle')  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_catalog.pg_stat_database) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database) AS "Hits"
) t

2024-02-02 16:34:34,661: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:34:34] "GET /dashboard/dashboard_stats/2?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1" 200 -
2024-02-02 16:34:39,591: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 6861751):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_catalog.pg_stat_activity) AS "Total",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active')  AS "Active",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle')  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_catalog.pg_stat_database) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database) AS "Hits"
) t

2024-02-02 16:34:39,661: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:34:39] "GET /dashboard/dashboard_stats/2?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1" 200 -
2024-02-02 16:34:41,811: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 6760640):
/*pga4dash*/
SELECT
    pid,
    locktype,
    datname,
    relation::regclass,
    page,
    tuple,
    virtualxid
    transactionid,
    classid::regclass,
    objid,
    objsubid,
    virtualtransaction,
    mode,
    granted,
    fastpath
FROM
    pg_catalog.pg_locks l
    LEFT OUTER JOIN pg_catalog.pg_database d ON (l.database = d.oid)
ORDER BY
    pid, locktype
2024-02-02 16:34:41,861: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:34:41] "GET /dashboard/locks/2 HTTP/1.1" 200 -
2024-02-02 16:34:43,668: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 9772680):
/*pga4dash*/
SELECT
    gid,
    database,
    owner,
    transaction,
    pg_catalog.to_char(prepared, 'YYYY-MM-DD HH24:MI:SS TZ') AS prepared
FROM
    pg_catalog.pg_prepared_xacts
ORDER BY
    gid, database, owner
2024-02-02 16:34:43,704: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:34:43] "GET /dashboard/prepared/2 HTTP/1.1" 200 -
2024-02-02 16:34:44,589: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 7755662):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_catalog.pg_stat_activity) AS "Total",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active')  AS "Active",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle')  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_catalog.pg_stat_database) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database) AS "Hits"
) t

2024-02-02 16:34:44,655: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:34:44] "GET /dashboard/dashboard_stats/2?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1" 200 -
2024-02-02 16:34:44,866: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 6006649):
/*pga4dash*/
SELECT
    name,
    category,
    setting,
    unit,
    short_desc
FROM
    pg_catalog.pg_settings
ORDER BY
    category
2024-02-02 16:34:45,011: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:34:45] "GET /dashboard/config/2 HTTP/1.1" 200 -
2024-02-02 16:34:48,787: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 6715602):
/*pga4dash*/
SELECT
    pid,
    datname,
    usename,
    application_name,
    client_addr,
    pg_catalog.to_char(backend_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS backend_start,
    state,
    wait_event_type || ': ' || wait_event AS wait_event,
    array_to_string(pg_catalog.pg_blocking_pids(pid), ', ') AS blocking_pids,
    query,
    pg_catalog.to_char(state_change, 'YYYY-MM-DD HH24:MI:SS TZ') AS state_change,
    pg_catalog.to_char(query_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS query_start,
    pg_catalog.to_char(xact_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS xact_start,
    backend_type,
    CASE WHEN state = 'active' THEN ROUND((extract(epoch from now() - query_start) / 60)::numeric, 2) ELSE 0 END AS active_since
FROM
    pg_catalog.pg_stat_activity
ORDER BY pid
2024-02-02 16:34:48,857: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:34:48] "GET /dashboard/activity/2 HTTP/1.1" 200 -
2024-02-02 16:34:49,589: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 6762934):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_catalog.pg_stat_activity) AS "Total",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active')  AS "Active",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle')  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_catalog.pg_stat_database) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database) AS "Hits"
) t

2024-02-02 16:34:49,646: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:34:49] "GET /dashboard/dashboard_stats/2?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1" 200 -
2024-02-02 16:34:52,887: SQL    pgadmin:    Execute (scalar) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 4957969):
SELECT * FROM pg_extension WHERE extname = 'system_stats';
2024-02-02 16:34:52,944: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:34:52] "GET /dashboard/check_extension/system_statistics/2 HTTP/1.1" 200 -
2024-02-02 16:34:54,550: DEBUG  pgadmin:    Heartbeat logged for the session id##server id: 87eaca6a-e239-455c-a30c-c51c44a4e025##2
2024-02-02 16:34:54,558: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:34:54] "POST /misc/heartbeat/log HTTP/1.1" 200 -
2024-02-02 16:34:54,602: SQL    pgadmin:    Execute (dict) by pgadmin4@pgadmin.org on admin_hermes_qa@jackalope-platform-rds-cluster.cluster-cqo1fpgfkhjl.us-east-1.rds.amazonaws.com/postgres #2 - DB:postgres (Query-id: 6199493):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_catalog.pg_stat_activity) AS "Total",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'active')  AS "Active",
   (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE state = 'idle')  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_catalog.pg_stat_database) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_catalog.pg_stat_database) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_catalog.pg_stat_database) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_catalog.pg_stat_database) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_catalog.pg_stat_database) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_catalog.pg_stat_database) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_catalog.pg_stat_database) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_catalog.pg_stat_database) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_catalog.pg_stat_database) AS "Hits"
) t

2024-02-02 16:34:54,694: INFO   werkzeug:   127.0.0.1 - - [02/Feb/2024 16:34:54] "GET /dashboard/dashboard_stats/2?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1" 200 -
jessica.nandal@K02386 ~/.pgadmin>
pravesh-sharma commented 9 months ago

Hi @JessicaNandalKbra,

It seems you are trying to connect to a remote AWS server. The response time completely depends on the remote server. pgAdmin has to wait for the server response.

JessicaNandalKbra commented 8 months ago

We figured it out. It was probably more of an internal issues. But I will explain in case anyone else has the same issue.

We use Cisco Any connect for VPN access.

When we are off the VPN PGAdmin works fine. We can connect to local postgres server and RDS instances without any program. But when we are off the network PGAdmin decides not to use GSS.

When we are on the network, PGAdmin for every server wants to use GSS, which we do not have enabled on the DB servers.

Not sure why PGAdmin uses GSS on VPN and not off. But the solution was to go into parameters and add

GSS encmode disable.

yogeshmahajan-1903 commented 8 months ago

This is not a pgadmin issue, closing the issue.

Eepa commented 7 months ago

The solution of @JessicaNandalKbra saved me as well - thank you for posting it! 👍

Here is the section in which that parameter can be added to server configuration in pgAdmin:

image