2020-05-02 20:21:29,043: INFO	flask.app:	########################################################
2020-05-02 20:21:29,043: INFO	flask.app:	Starting pgAdmin 4 v4.21...
2020-05-02 20:21:29,043: INFO	flask.app:	########################################################
2020-05-02 20:21:29,043: DEBUG	flask.app:	Python syspath: ['/usr/local/lib/python3.7/dist-packages/pgadmin4', '/usr/lib/python37.zip', '/usr/lib/python3.7', '/usr/lib/python3.7/lib-dynload', '/usr/local/lib/python3.7/dist-packages', '/usr/lib/python3/dist-packages']
2020-05-02 20:21:29,045: DEBUG	flask.app:	Available translations: [Locale('es'), Locale('ja'), Locale('fr'), Locale('ko'), Locale('it'), Locale('zh'), Locale('pl'), Locale('de'), Locale('cs'), Locale('ru')]
2020-05-02 20:21:29,522: INFO	flask.app:	Examining potential module: pgadmin.about
2020-05-02 20:21:29,524: INFO	flask.app:	Registering blueprint module: <pgadmin.about.AboutModule object at 0x7fe8051891d0>
2020-05-02 20:21:29,527: INFO	flask.app:	Examining potential module: pgadmin.authenticate
2020-05-02 20:21:29,527: INFO	flask.app:	Registering blueprint module: <pgadmin.authenticate.AuthenticateModule object at 0x7fe8081b6550>
2020-05-02 20:21:29,527: INFO	flask.app:	Examining potential module: pgadmin.authenticate.internal
2020-05-02 20:21:29,527: INFO	flask.app:	Examining potential module: pgadmin.authenticate.ldap
2020-05-02 20:21:29,527: INFO	flask.app:	Examining potential module: pgadmin.authenticate.registry
2020-05-02 20:21:29,529: INFO	flask.app:	Examining potential module: pgadmin.browser
2020-05-02 20:21:29,534: INFO	flask.app:	Registering blueprint module: <pgadmin.browser.BrowserModule object at 0x7fe80511fbd0>
2020-05-02 20:21:29,534: INFO	flask.app:	Examining potential module: pgadmin.browser.collection
2020-05-02 20:21:29,537: INFO	flask.app:	Examining potential module: pgadmin.browser.register_browser_preferences
2020-05-02 20:21:29,537: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups
2020-05-02 20:21:29,538: INFO	flask.app:	Examining potential module: pgadmin.browser.tests
2020-05-02 20:21:29,548: INFO	flask.app:	Examining potential module: pgadmin.browser.utils
2020-05-02 20:21:29,559: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers
2020-05-02 20:21:29,627: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.tests
2020-05-02 20:21:29,639: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases
2020-05-02 20:21:29,643: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.gpdb
2020-05-02 20:21:29,643: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.pgagent
2020-05-02 20:21:29,645: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.ppas
2020-05-02 20:21:29,646: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.resource_groups
2020-05-02 20:21:29,647: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.roles
2020-05-02 20:21:29,649: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.tablespaces
2020-05-02 20:21:29,650: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.tests
2020-05-02 20:21:29,651: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.types
2020-05-02 20:21:29,651: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.utils
2020-05-02 20:21:29,677: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.casts
2020-05-02 20:21:29,679: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.event_triggers
2020-05-02 20:21:29,680: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.extensions
2020-05-02 20:21:29,682: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.external_tables
2020-05-02 20:21:29,684: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.foreign_data_wrappers
2020-05-02 20:21:29,686: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.languages
2020-05-02 20:21:29,687: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas
2020-05-02 20:21:29,689: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.tests
2020-05-02 20:21:29,690: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.utils
2020-05-02 20:21:29,721: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.casts.tests
2020-05-02 20:21:29,751: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.event_triggers.tests
2020-05-02 20:21:29,776: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.extensions.tests
2020-05-02 20:21:29,804: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.external_tables.actions
2020-05-02 20:21:29,805: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.external_tables.mapping_utils
2020-05-02 20:21:29,805: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.external_tables.properties
2020-05-02 20:21:29,806: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.external_tables.reverse_engineer_ddl
2020-05-02 20:21:29,806: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.external_tables.tests
2020-05-02 20:21:29,815: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.foreign_data_wrappers.foreign_servers
2020-05-02 20:21:29,817: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.foreign_data_wrappers.tests
2020-05-02 20:21:29,849: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.foreign_data_wrappers.foreign_servers.tests
2020-05-02 20:21:29,850: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.foreign_data_wrappers.foreign_servers.user_mappings
2020-05-02 20:21:29,892: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.foreign_data_wrappers.foreign_servers.user_mappings.tests
2020-05-02 20:21:29,932: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.languages.tests
2020-05-02 20:21:29,957: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.catalog_objects
2020-05-02 20:21:29,959: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.collations
2020-05-02 20:21:29,962: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.domains
2020-05-02 20:21:29,963: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.foreign_tables
2020-05-02 20:21:29,965: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.fts_configurations
2020-05-02 20:21:29,967: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.fts_dictionaries
2020-05-02 20:21:29,968: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.fts_parsers
2020-05-02 20:21:29,970: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.fts_templates
2020-05-02 20:21:29,971: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.functions
2020-05-02 20:21:29,974: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.packages
2020-05-02 20:21:29,976: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.sequences
2020-05-02 20:21:29,977: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.synonyms
2020-05-02 20:21:29,979: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables
2020-05-02 20:21:30,003: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tests
2020-05-02 20:21:30,004: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.types
2020-05-02 20:21:30,006: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.utils
2020-05-02 20:21:30,006: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.views
2020-05-02 20:21:30,055: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.catalog_objects.columns
2020-05-02 20:21:30,091: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.collations.tests
2020-05-02 20:21:30,129: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.domains.domain_constraints
2020-05-02 20:21:30,130: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.domains.tests
2020-05-02 20:21:30,191: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.foreign_tables.tests
2020-05-02 20:21:30,251: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.fts_configurations.tests
2020-05-02 20:21:30,292: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.fts_dictionaries.tests
2020-05-02 20:21:30,322: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.fts_parsers.tests
2020-05-02 20:21:30,365: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.fts_templates.tests
2020-05-02 20:21:30,398: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.functions.tests
2020-05-02 20:21:30,441: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.functions.tests
2020-05-02 20:21:30,483: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.functions.tests
2020-05-02 20:21:30,526: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.packages.edbfuncs
2020-05-02 20:21:30,527: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.packages.edbvars
2020-05-02 20:21:30,529: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.packages.tests
2020-05-02 20:21:30,557: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.packages.edbfuncs.tests
2020-05-02 20:21:30,576: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.packages.edbfuncs.tests
2020-05-02 20:21:30,616: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.sequences.tests
2020-05-02 20:21:30,643: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.synonyms.tests
2020-05-02 20:21:30,676: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.base_partition_table
2020-05-02 20:21:30,676: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.columns
2020-05-02 20:21:30,676: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.compound_triggers
2020-05-02 20:21:30,677: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints
2020-05-02 20:21:30,677: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.indexes
2020-05-02 20:21:30,681: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.partitions
2020-05-02 20:21:30,681: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.rules
2020-05-02 20:21:30,683: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.schema_diff_utils
2020-05-02 20:21:30,683: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.tests
2020-05-02 20:21:30,684: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.triggers
2020-05-02 20:21:30,684: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.utils
2020-05-02 20:21:30,760: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.columns.tests
2020-05-02 20:21:30,761: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.columns.utils
2020-05-02 20:21:30,786: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.compound_triggers.tests
2020-05-02 20:21:30,787: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.compound_triggers.utils
2020-05-02 20:21:30,820: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints.check_constraint
2020-05-02 20:21:30,821: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints.exclusion_constraint
2020-05-02 20:21:30,821: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints.foreign_key
2020-05-02 20:21:30,821: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints.index_constraint
2020-05-02 20:21:30,822: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints.tests
2020-05-02 20:21:30,823: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints.type
2020-05-02 20:21:30,832: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints.check_constraint.tests
2020-05-02 20:21:30,833: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints.check_constraint.utils
2020-05-02 20:21:30,974: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.indexes.tests
2020-05-02 20:21:30,975: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.indexes.utils
2020-05-02 20:21:31,021: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.partitions.tests
2020-05-02 20:21:31,022: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.partitions.tests
2020-05-02 20:21:31,046: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.rules.tests
2020-05-02 20:21:31,076: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.triggers.tests
2020-05-02 20:21:31,078: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.triggers.utils
2020-05-02 20:21:31,115: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.types.tests
2020-05-02 20:21:31,164: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.views.children
2020-05-02 20:21:31,165: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.views.tests
2020-05-02 20:21:31,330: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.views.children
2020-05-02 20:21:31,331: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.views.tests
2020-05-02 20:21:31,489: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.catalog_objects
2020-05-02 20:21:31,489: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.collations
2020-05-02 20:21:31,490: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.domains
2020-05-02 20:21:31,490: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.foreign_tables
2020-05-02 20:21:31,490: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.fts_configurations
2020-05-02 20:21:31,490: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.fts_dictionaries
2020-05-02 20:21:31,490: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.fts_parsers
2020-05-02 20:21:31,490: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.fts_templates
2020-05-02 20:21:31,491: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.functions
2020-05-02 20:21:31,491: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.packages
2020-05-02 20:21:31,491: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.sequences
2020-05-02 20:21:31,491: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.synonyms
2020-05-02 20:21:31,491: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables
2020-05-02 20:21:31,492: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tests
2020-05-02 20:21:31,492: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.types
2020-05-02 20:21:31,492: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.utils
2020-05-02 20:21:31,492: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.views
2020-05-02 20:21:33,296: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.pgagent.schedules
2020-05-02 20:21:33,297: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.pgagent.steps
2020-05-02 20:21:33,298: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.pgagent.tests
2020-05-02 20:21:33,299: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.pgagent.utils
2020-05-02 20:21:33,345: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.resource_groups.tests
2020-05-02 20:21:33,363: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.roles.tests
2020-05-02 20:21:33,381: INFO	flask.app:	Examining potential module: pgadmin.browser.server_groups.servers.tablespaces.tests
2020-05-02 20:21:33,404: INFO	flask.app:	Examining potential module: pgadmin.dashboard
2020-05-02 20:21:33,405: INFO	flask.app:	Registering blueprint module: <pgadmin.dashboard.DashboardModule object at 0x7fe802fea2d0>
2020-05-02 20:21:33,406: INFO	flask.app:	Examining potential module: pgadmin.dashboard.tests
2020-05-02 20:21:33,429: INFO	flask.app:	Examining potential module: pgadmin.feature_tests
2020-05-02 20:21:33,429: INFO	flask.app:	Examining potential module: pgadmin.help
2020-05-02 20:21:33,430: INFO	flask.app:	Registering blueprint module: <pgadmin.help.HelpModule object at 0x7fe803010390>
2020-05-02 20:21:33,431: INFO	flask.app:	Examining potential module: pgadmin.misc
2020-05-02 20:21:33,431: INFO	flask.app:	Registering blueprint module: <pgadmin.misc.MiscModule object at 0x7fe805035810>
2020-05-02 20:21:33,432: INFO	flask.app:	Examining potential module: pgadmin.misc.bgprocess
2020-05-02 20:21:33,432: INFO	flask.app:	Examining potential module: pgadmin.misc.dependencies
2020-05-02 20:21:33,433: INFO	flask.app:	Examining potential module: pgadmin.misc.dependents
2020-05-02 20:21:33,433: INFO	flask.app:	Examining potential module: pgadmin.misc.file_manager
2020-05-02 20:21:33,434: INFO	flask.app:	Examining potential module: pgadmin.misc.sql
2020-05-02 20:21:33,434: INFO	flask.app:	Examining potential module: pgadmin.misc.statistics
2020-05-02 20:21:33,435: INFO	flask.app:	Examining potential module: pgadmin.misc.themes
2020-05-02 20:21:33,439: INFO	flask.app:	Examining potential module: pgadmin.misc.bgprocess.process_executor
2020-05-02 20:21:33,440: INFO	flask.app:	Examining potential module: pgadmin.misc.bgprocess.processes
2020-05-02 20:21:33,463: INFO	flask.app:	Examining potential module: pgadmin.model
2020-05-02 20:21:33,463: INFO	flask.app:	Examining potential module: pgadmin.preferences
2020-05-02 20:21:33,464: INFO	flask.app:	Registering blueprint module: <pgadmin.preferences.PreferencesModule object at 0x7fe802f51190>
2020-05-02 20:21:33,469: INFO	flask.app:	Examining potential module: pgadmin.redirects
2020-05-02 20:21:33,470: INFO	flask.app:	Registering blueprint module: <pgadmin.utils.PgAdminModule object at 0x7fe802f5b550>
2020-05-02 20:21:33,473: INFO	flask.app:	Examining potential module: pgadmin.settings
2020-05-02 20:21:33,473: INFO	flask.app:	Registering blueprint module: <pgadmin.settings.SettingsModule object at 0x7fe80512b210>
2020-05-02 20:21:33,482: INFO	flask.app:	Examining potential module: pgadmin.setup
2020-05-02 20:21:33,482: INFO	flask.app:	Examining potential module: pgadmin.tools
2020-05-02 20:21:33,482: INFO	flask.app:	Registering blueprint module: <pgadmin.tools.ToolsModule object at 0x7fe805179050>
2020-05-02 20:21:33,483: INFO	flask.app:	Examining potential module: pgadmin.tools.backup
2020-05-02 20:21:33,484: INFO	flask.app:	Examining potential module: pgadmin.tools.datagrid
2020-05-02 20:21:33,485: INFO	flask.app:	Examining potential module: pgadmin.tools.debugger
2020-05-02 20:21:33,487: INFO	flask.app:	Examining potential module: pgadmin.tools.grant_wizard
2020-05-02 20:21:33,488: INFO	flask.app:	Examining potential module: pgadmin.tools.import_export
2020-05-02 20:21:33,489: INFO	flask.app:	Examining potential module: pgadmin.tools.maintenance
2020-05-02 20:21:33,490: INFO	flask.app:	Examining potential module: pgadmin.tools.restore
2020-05-02 20:21:33,491: INFO	flask.app:	Examining potential module: pgadmin.tools.schema_diff
2020-05-02 20:21:33,492: INFO	flask.app:	Examining potential module: pgadmin.tools.search_objects
2020-05-02 20:21:33,493: INFO	flask.app:	Examining potential module: pgadmin.tools.sqleditor
2020-05-02 20:21:33,493: INFO	flask.app:	Examining potential module: pgadmin.tools.user_management
2020-05-02 20:21:33,496: INFO	flask.app:	Examining potential module: pgadmin.tools.backup.tests
2020-05-02 20:21:33,517: INFO	flask.app:	Examining potential module: pgadmin.tools.debugger.utils
2020-05-02 20:21:33,561: INFO	flask.app:	Examining potential module: pgadmin.tools.import_export.tests
2020-05-02 20:21:33,569: INFO	flask.app:	Examining potential module: pgadmin.tools.maintenance.tests
2020-05-02 20:21:33,577: INFO	flask.app:	Examining potential module: pgadmin.tools.restore.tests
2020-05-02 20:21:33,583: INFO	flask.app:	Examining potential module: pgadmin.tools.schema_diff.compare
2020-05-02 20:21:33,583: INFO	flask.app:	Examining potential module: pgadmin.tools.schema_diff.directory_compare
2020-05-02 20:21:33,583: INFO	flask.app:	Examining potential module: pgadmin.tools.schema_diff.model
2020-05-02 20:21:33,584: INFO	flask.app:	Examining potential module: pgadmin.tools.schema_diff.node_registry
2020-05-02 20:21:33,584: INFO	flask.app:	Examining potential module: pgadmin.tools.schema_diff.tests
2020-05-02 20:21:33,603: INFO	flask.app:	Examining potential module: pgadmin.tools.search_objects.tests
2020-05-02 20:21:33,604: INFO	flask.app:	Examining potential module: pgadmin.tools.search_objects.utils
2020-05-02 20:21:33,608: INFO	flask.app:	Examining potential module: pgadmin.tools.sqleditor.command
2020-05-02 20:21:33,609: INFO	flask.app:	Examining potential module: pgadmin.tools.sqleditor.tests
2020-05-02 20:21:33,609: INFO	flask.app:	Examining potential module: pgadmin.tools.sqleditor.utils
2020-05-02 20:21:33,641: INFO	flask.app:	Examining potential module: pgadmin.utils
2020-05-02 20:21:33,644: DEBUG	flask.app:	Not running under the desktop runtime, port: 5050
2020-05-02 20:21:33,644: DEBUG	flask.app:	Authentication Source: internal
2020-05-02 20:21:33,645: INFO	werkzeug:	 * Running on http://127.0.0.1:5050/ (Press CTRL+C to quit)
2020-05-02 20:22:21,471: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:21] "[32mGET / HTTP/1.1[0m" 302 -
2020-05-02 20:22:21,551: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:21] "[37mGET /login?next=%2F HTTP/1.1[0m" 200 -
2020-05-02 20:22:21,675: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:21] "[37mGET /static/js/generated/pgadmin.style.css?ver=42100 HTTP/1.1[0m" 200 -
2020-05-02 20:22:21,681: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:21] "[37mGET /static/img/login.svg?ver=42100 HTTP/1.1[0m" 200 -
2020-05-02 20:22:21,696: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:21] "[37mGET /static/js/generated/pgadmin.css?ver=42100 HTTP/1.1[0m" 200 -
2020-05-02 20:22:21,700: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:21] "[37mGET /static/js/generated/style.css?ver=42100 HTTP/1.1[0m" 200 -
2020-05-02 20:22:24,466: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:24] "[32mPOST /authenticate/login HTTP/1.1[0m" 302 -
2020-05-02 20:22:24,494: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:24] "[32mGET / HTTP/1.1[0m" 302 -
2020-05-02 20:22:24,517: DEBUG	flask.app:	Checking version data at: https://www.pgadmin.org/versions.json?version=4.21
2020-05-02 20:22:25,065: DEBUG	flask.app:	Version check HTTP response code: 200
2020-05-02 20:22:25,066: DEBUG	flask.app:	Response data: {'edb-pgadmin4': {'version': '4.18', 'version_int': 41800, 'download_url': 'https://www.enterprisedb.com/downloads/postgres-postgresql-downloads'}, 'pgadmin4': {'version': '4.21', 'version_int': 42100, 'download_url': 'https://www.pgadmin.org/download/'}}
2020-05-02 20:22:25,100: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:25] "[37mGET /browser/ HTTP/1.1[0m" 200 -
2020-05-02 20:22:25,310: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:25] "[37mGET /browser/browser.css?ver=42100 HTTP/1.1[0m" 200 -
2020-05-02 20:22:25,373: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:25] "[37mGET /static/js/generated/fonts/fontawesome-webfont.woff2 HTTP/1.1[0m" 200 -
2020-05-02 20:22:25,524: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:25] "[37mGET /browser/js/endpoints.js?ver=42100 HTTP/1.1[0m" 200 -
2020-05-02 20:22:25,548: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:25] "[37mGET /browser/js/messages.js?ver=42100 HTTP/1.1[0m" 200 -
2020-05-02 20:22:25,553: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:25] "[37mGET /browser/server/supported_servers.js?ver=42100 HTTP/1.1[0m" 200 -
2020-05-02 20:22:25,567: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:25] "[37mGET /tools/translations.js?ver=42100 HTTP/1.1[0m" 200 -
2020-05-02 20:22:25,606: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:25] "[37mGET /user_management/current_user.js?ver=42100 HTTP/1.1[0m" 200 -
2020-05-02 20:22:25,617: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:25] "[37mGET /browser/js/utils.js?ver=42100 HTTP/1.1[0m" 200 -
2020-05-02 20:22:25,640: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:25] "[37mGET /static/favicon.ico?ver=42100 HTTP/1.1[0m" 200 -
2020-05-02 20:22:25,970: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:25] "[37mGET /static/css/webcabin.overrides.css?v=1588447345953 HTTP/1.1[0m" 200 -
2020-05-02 20:22:26,296: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:26] "[37mPOST /browser/master_password HTTP/1.1[0m" 200 -
2020-05-02 20:22:26,477: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:26] "[37mGET /dashboard/ HTTP/1.1[0m" 200 -
2020-05-02 20:22:26,683: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:26] "[37mPOST /settings/store HTTP/1.1[0m" 200 -
2020-05-02 20:22:26,754: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:26] "[37mGET /browser/nodes/ HTTP/1.1[0m" 200 -
2020-05-02 20:22:26,851: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:26] "[37mGET /browser/server_group/static/img/server_group.svg?ver=42100 HTTP/1.1[0m" 200 -
2020-05-02 20:22:27,015: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:27] "[37mPOST /settings/store HTTP/1.1[0m" 200 -
2020-05-02 20:22:27,031: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:27] "[37mGET /preferences/get_all HTTP/1.1[0m" 200 -
2020-05-02 20:22:27,066: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:27] "[37mGET /settings/get_tree_state/ HTTP/1.1[0m" 200 -
2020-05-02 20:22:27,507: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:27] "[37mGET /misc/bgprocess/?_=1588447345660 HTTP/1.1[0m" 200 -
2020-05-02 20:22:30,082: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:30] "[37mGET /dashboard/ HTTP/1.1[0m" 200 -
2020-05-02 20:22:30,241: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:30] "[37mGET /browser/server_group/children/2 HTTP/1.1[0m" 200 -
2020-05-02 20:22:30,303: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:30] "[37mGET /browser/server/static/img/serverbad.svg?ver=42100 HTTP/1.1[0m" 200 -
2020-05-02 20:22:30,418: INFO	flask.app:	Connection Request for server#1
2020-05-02 20:22:30,537: INFO	flask.app:	Connection Established for server:                 1 - freenas
2020-05-02 20:22:30,543: SQL	flask.app:	Execute (dict) for server #1 - DB:postgres (Query-id: 6142719):
SELECT CASE WHEN usesuper
       THEN pg_is_in_recovery()
       ELSE FALSE
       END as inrecovery,
       CASE WHEN usesuper AND pg_is_in_recovery()
       THEN pg_is_wal_replay_paused()
       ELSE FALSE
       END as isreplaypaused
FROM pg_user WHERE usename=current_user
2020-05-02 20:22:30,546: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:30] "[37mPOST /browser/server/connect/2/1 HTTP/1.1[0m" 200 -
2020-05-02 20:22:30,801: SQL	flask.app:	Execute (scalar) for server #1 - DB:postgres (Query-id: 7180651):

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_class cl
        LEFT JOIN pg_namespace ns ON ns.oid=relnamespace
        WHERE relname='pga_job' AND nspname='pgagent'
    )
)

2020-05-02 20:22:30,824: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:30] "[37mGET /dashboard/1 HTTP/1.1[0m" 200 -
2020-05-02 20:22:30,834: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:30] "[37mGET /browser/server/children/2/1 HTTP/1.1[0m" 200 -
2020-05-02 20:22:30,950: SQL	flask.app:	Execute (dict) for server #1 - DB:postgres (Query-id: 6922429):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active')  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle')  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database) AS "Hits"
) t

2020-05-02 20:22:30,979: SQL	flask.app:	Execute (dict) for server #1 - DB:postgres (Query-id: 8562049):
/*pga4dash*/
SELECT
    pid,
    datname,
    usename,
    application_name,
    client_addr,
    to_char(backend_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS backend_start,
    state,
    wait_event_type || ': ' || wait_event AS wait_event,
    pg_blocking_pids(pid) AS blocking_pids,
    query,
    to_char(state_change, 'YYYY-MM-DD HH24:MI:SS TZ') AS state_change,
    to_char(query_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS query_start,
    backend_type
FROM
    pg_stat_activity
ORDER BY pid
2020-05-02 20:22:30,988: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:30] "[37mGET /dashboard/dashboard_stats/1?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:22:30,989: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:30] "[37mGET /dashboard/activity/1 HTTP/1.1[0m" 200 -
2020-05-02 20:22:31,101: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:31] "[37mGET /browser/database/static/img/coll-database.svg?ver=42100 HTTP/1.1[0m" 200 -
2020-05-02 20:22:31,102: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:31] "[37mGET /browser/role/static/img/coll-role.svg?ver=42100 HTTP/1.1[0m" 200 -
2020-05-02 20:22:31,103: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:31] "[37mGET /browser/tablespace/static/img/coll-tablespace.svg?ver=42100 HTTP/1.1[0m" 200 -
2020-05-02 20:22:31,154: SQL	flask.app:	Execute (2darray) for server #1 - DB:postgres (Query-id: 8260435):
SELECT
	r.oid, r.rolname, r.rolcanlogin, r.rolsuper
FROM
	pg_roles r
ORDER BY r.rolcanlogin, r.rolname
2020-05-02 20:22:31,159: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:31] "[37mGET /browser/role/nodes/2/1/ HTTP/1.1[0m" 200 -
2020-05-02 20:22:31,171: SQL	flask.app:	Execute (dict) for server #1 - DB:postgres (Query-id: 8597843):
SELECT
    db.oid as did, db.datname as name, ta.spcname as spcname, db.datallowconn,
    has_database_privilege(db.oid, 'CREATE') as cancreate, datdba as owner
FROM
    pg_database db
    LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace = ta.oid
WHERE db.oid > 13748::OID

ORDER BY datname;
2020-05-02 20:22:31,174: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:31] "[37mGET /browser/database/nodes/2/1/ HTTP/1.1[0m" 200 -
2020-05-02 20:22:31,327: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:31] "[37mGET /browser/role/static/img/role.svg?ver=42100 HTTP/1.1[0m" 200 -
2020-05-02 20:22:31,332: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:31] "[37mGET /browser/role/static/img/group.svg?ver=42100 HTTP/1.1[0m" 200 -
2020-05-02 20:22:31,337: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:31] "[37mGET /browser/database/static/img/database.svg?ver=42100 HTTP/1.1[0m" 200 -
2020-05-02 20:22:31,337: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:31] "[37mGET /browser/database/static/img/databasebad.svg?ver=42100 HTTP/1.1[0m" 200 -
2020-05-02 20:22:31,869: SQL	flask.app:	Execute (dict) for server #1 - DB:postgres (Query-id: 7224645):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active')  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle')  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database) AS "Hits"
) t

2020-05-02 20:22:31,892: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:31] "[37mGET /dashboard/dashboard_stats/1?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:22:32,615: SQL	flask.app:	Execute (dict) for server #1 - DB:postgres (Query-id: 2590191):

SELECT
    db.oid as did, db.datname, db.datallowconn,
    pg_encoding_to_char(db.encoding) AS serverencoding,
    has_database_privilege(db.oid, 'CREATE') as cancreate, datlastsysoid
FROM
    pg_database db
WHERE db.oid = 1680798
2020-05-02 20:22:32,637: INFO	flask.app:	Connection Established for Database Id:                 1680798
2020-05-02 20:22:32,644: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:32] "[37mPOST /browser/database/connect/2/1/1680798 HTTP/1.1[0m" 200 -
2020-05-02 20:22:32,823: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:32] "[37mGET /dashboard/1/1680798 HTTP/1.1[0m" 200 -
2020-05-02 20:22:32,899: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 5964889):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:22:32,940: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:32] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:22:32,941: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:32] "[37mGET /browser/database/children/2/1/1680798 HTTP/1.1[0m" 200 -
2020-05-02 20:22:32,943: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 2576551):
/*pga4dash*/
SELECT
    pid,
    datname,
    usename,
    application_name,
    client_addr,
    to_char(backend_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS backend_start,
    state,
    wait_event_type || ': ' || wait_event AS wait_event,
    pg_blocking_pids(pid) AS blocking_pids,
    query,
    to_char(state_change, 'YYYY-MM-DD HH24:MI:SS TZ') AS state_change,
    to_char(query_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS query_start,
    backend_type
FROM
    pg_stat_activity
WHERE
    datname = (SELECT datname FROM pg_database WHERE oid = 1680798)ORDER BY pid
2020-05-02 20:22:32,953: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:32] "[37mGET /dashboard/activity/1/1680798 HTTP/1.1[0m" 200 -
2020-05-02 20:22:32,987: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 2699318):
SELECT DISTINCT dep.deptype, dep.refclassid, cl.relkind, ad.adbin, ad.adsrc,
    CASE WHEN cl.relkind IS NOT NULL THEN cl.relkind || COALESCE(dep.refobjsubid::character varying, '')
        WHEN tg.oid IS NOT NULL THEN 'T'::text
        WHEN ty.oid IS NOT NULL AND ty.typbasetype = 0 THEN 'y'::text
        WHEN ty.oid IS NOT NULL AND ty.typbasetype != 0 THEN 'd'::text
        WHEN ns.oid IS NOT NULL THEN 'n'::text
        WHEN pr.oid IS NOT NULL AND prtyp.typname = 'trigger' THEN 't'::text
        WHEN pr.oid IS NOT NULL THEN 'P'::text
        WHEN la.oid IS NOT NULL THEN 'l'::text
        WHEN rw.oid IS NOT NULL THEN 'R'::text
        WHEN co.oid IS NOT NULL THEN 'C'::text || contype
        WHEN ad.oid IS NOT NULL THEN 'A'::text
        WHEN fs.oid IS NOT NULL THEN 'F'::text
        WHEN fdw.oid IS NOT NULL THEN 'f'::text
    ELSE ''
    END AS type,
    COALESCE(coc.relname, clrw.relname) AS ownertable,
    CASE WHEN cl.relname IS NOT NULL OR att.attname IS NOT NULL THEN cl.relname || COALESCE('.' || att.attname, '')
    ELSE COALESCE(cl.relname, co.conname, pr.proname, tg.tgname, ty.typname, la.lanname, rw.rulename, ns.nspname, fs.srvname, fdw.fdwname)
    END AS refname,
    COALESCE(nsc.nspname, nso.nspname, nsp.nspname, nst.nspname, nsrw.nspname) AS nspname,
    CASE WHEN inhits.inhparent IS NOT NULL THEN '1' ELSE '0' END AS is_inherits,
    CASE WHEN inhed.inhparent IS NOT NULL THEN '1' ELSE '0' END AS is_inherited
FROM pg_depend dep
LEFT JOIN pg_class cl ON dep.refobjid=cl.oid
LEFT JOIN pg_attribute att ON dep.refobjid=att.attrelid AND dep.refobjsubid=att.attnum
LEFT JOIN pg_namespace nsc ON cl.relnamespace=nsc.oid
LEFT JOIN pg_proc pr ON dep.refobjid=pr.oid
LEFT JOIN pg_namespace nsp ON pr.pronamespace=nsp.oid
LEFT JOIN pg_trigger tg ON dep.refobjid=tg.oid
LEFT JOIN pg_type ty ON dep.refobjid=ty.oid
LEFT JOIN pg_namespace nst ON ty.typnamespace=nst.oid
LEFT JOIN pg_constraint co ON dep.refobjid=co.oid
LEFT JOIN pg_class coc ON co.conrelid=coc.oid
LEFT JOIN pg_namespace nso ON co.connamespace=nso.oid
LEFT JOIN pg_rewrite rw ON dep.refobjid=rw.oid
LEFT JOIN pg_class clrw ON clrw.oid=rw.ev_class
LEFT JOIN pg_namespace nsrw ON clrw.relnamespace=nsrw.oid
LEFT JOIN pg_language la ON dep.refobjid=la.oid
LEFT JOIN pg_namespace ns ON dep.refobjid=ns.oid
LEFT JOIN pg_attrdef ad ON ad.adrelid=att.attrelid AND ad.adnum=att.attnum
LEFT JOIN pg_foreign_server fs ON fs.oid=dep.refobjid
LEFT JOIN pg_foreign_data_wrapper fdw ON fdw.oid=dep.refobjid
LEFT JOIN pg_type prtyp ON prtyp.oid = pr.prorettype
LEFT JOIN pg_inherits inhits ON (inhits.inhrelid=dep.refobjid)
LEFT JOIN pg_inherits inhed ON (inhed.inhparent=dep.refobjid)
WHERE dep.objid=1680798::oid AND
refclassid IN ( SELECT oid FROM pg_class WHERE relname IN
   ('pg_class', 'pg_constraint', 'pg_conversion', 'pg_language', 'pg_proc', 'pg_rewrite', 'pg_namespace',
   'pg_trigger', 'pg_type', 'pg_attrdef', 'pg_event_trigger', 'pg_foreign_server', 'pg_foreign_data_wrapper'))
ORDER BY refclassid, cl.relkind
2020-05-02 20:22:32,990: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 6566144):
SELECT DISTINCT dep.deptype, dep.classid, cl.relkind, ad.adbin, ad.adsrc,
    CASE WHEN cl.relkind IS NOT NULL THEN cl.relkind || COALESCE(dep.objsubid::text, '')
        WHEN tg.oid IS NOT NULL THEN 'T'::text
        WHEN ty.oid IS NOT NULL THEN 'y'::text
        WHEN ns.oid IS NOT NULL THEN 'n'::text
        WHEN pr.oid IS NOT NULL AND prtyp.typname = 'trigger' THEN 't'::text
        WHEN pr.oid IS NOT NULL THEN 'P'::text
        WHEN la.oid IS NOT NULL THEN 'l'::text
        WHEN rw.oid IS NOT NULL THEN 'R'::text
        WHEN co.oid IS NOT NULL THEN 'C'::text || contype
        WHEN ad.oid IS NOT NULL THEN 'A'::text
        WHEN fs.oid IS NOT NULL THEN 'F'::text
        WHEN fdw.oid IS NOT NULL THEN 'f'::text
        ELSE ''
    END AS type,
    COALESCE(coc.relname, clrw.relname) AS ownertable,
    CASE WHEN cl.relname IS NOT NULL AND att.attname IS NOT NULL THEN cl.relname || COALESCE('.' || att.attname, '')
    ELSE COALESCE(cl.relname, co.conname, pr.proname, tg.tgname, ty.typname, la.lanname, rw.rulename, ns.nspname, fs.srvname, fdw.fdwname)
    END AS refname,
    COALESCE(nsc.nspname, nso.nspname, nsp.nspname, nst.nspname, nsrw.nspname) AS nspname,
    CASE WHEN inhits.inhparent IS NOT NULL THEN '1' ELSE '0' END AS is_inherits,
    CASE WHEN inhed.inhparent IS NOT NULL THEN '1' ELSE '0' END AS is_inherited
FROM pg_depend dep
LEFT JOIN pg_class cl ON dep.objid=cl.oid
LEFT JOIN pg_attribute att ON dep.objid=att.attrelid AND dep.objsubid=att.attnum
LEFT JOIN pg_namespace nsc ON cl.relnamespace=nsc.oid
LEFT JOIN pg_proc pr ON dep.objid=pr.oid
LEFT JOIN pg_namespace nsp ON pr.pronamespace=nsp.oid
LEFT JOIN pg_trigger tg ON dep.objid=tg.oid
LEFT JOIN pg_type ty ON dep.objid=ty.oid
LEFT JOIN pg_namespace nst ON ty.typnamespace=nst.oid
LEFT JOIN pg_constraint co ON dep.objid=co.oid
LEFT JOIN pg_class coc ON co.conrelid=coc.oid
LEFT JOIN pg_namespace nso ON co.connamespace=nso.oid
LEFT JOIN pg_rewrite rw ON dep.objid=rw.oid
LEFT JOIN pg_class clrw ON clrw.oid=rw.ev_class
LEFT JOIN pg_namespace nsrw ON clrw.relnamespace=nsrw.oid
LEFT JOIN pg_language la ON dep.objid=la.oid
LEFT JOIN pg_namespace ns ON dep.objid=ns.oid
LEFT JOIN pg_attrdef ad ON ad.oid=dep.objid
LEFT JOIN pg_foreign_server fs ON fs.oid=dep.objid
LEFT JOIN pg_foreign_data_wrapper fdw ON fdw.oid=dep.objid
LEFT JOIN pg_type prtyp ON prtyp.oid = pr.prorettype
LEFT JOIN pg_inherits inhits ON (inhits.inhrelid=dep.objid)
LEFT JOIN pg_inherits inhed ON (inhed.inhparent=dep.objid)
WHERE dep.refobjid=1680798::oid AND
classid IN ( SELECT oid FROM pg_class WHERE relname IN
   ('pg_class', 'pg_constraint', 'pg_conversion', 'pg_language', 'pg_proc', 'pg_rewrite', 'pg_namespace',
   'pg_trigger', 'pg_type', 'pg_attrdef', 'pg_event_trigger', 'pg_foreign_server', 'pg_foreign_data_wrapper'))
ORDER BY classid, cl.relkind
2020-05-02 20:22:33,035: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:33] "[37mGET /browser/database/dependent/2/1/1680798 HTTP/1.1[0m" 200 -
2020-05-02 20:22:33,107: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:33] "[37mGET /browser/catalog/static/img/coll-catalog.svg?ver=42100 HTTP/1.1[0m" 200 -
2020-05-02 20:22:33,126: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:33] "[37mGET /browser/schema/static/img/coll-schema.svg?ver=42100 HTTP/1.1[0m" 200 -
2020-05-02 20:22:33,155: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 2091905):
SELECT rolname AS refname, refclassid, deptype
FROM pg_shdepend dep
LEFT JOIN pg_roles r ON refclassid=1260 AND refobjid=r.oid
WHERE dep.objid=1680798::oid ORDER BY 1
2020-05-02 20:22:33,159: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:33] "[37mGET /browser/database/dependency/2/1/1680798 HTTP/1.1[0m" 200 -
2020-05-02 20:22:33,187: SQL	flask.app:	Execute (2darray) for server #1 - DB:foo (Query-id: 6336177):
SELECT
    nsp.oid,
    nsp.nspname as name,
    has_schema_privilege(nsp.oid, 'CREATE') as can_create,
    has_schema_privilege(nsp.oid, 'USAGE') as has_usage
FROM
    pg_namespace nsp
WHERE
            nspname NOT LIKE 'pg\_%' AND
            NOT (
(nsp.nspname = 'pg_catalog' AND EXISTS
        (SELECT 1 FROM pg_class WHERE relname = 'pg_class' AND
            relnamespace = nsp.oid LIMIT 1)) OR
    (nsp.nspname = 'pgagent' AND EXISTS
        (SELECT 1 FROM pg_class WHERE relname = 'pga_job' AND
            relnamespace = nsp.oid LIMIT 1)) OR
    (nsp.nspname = 'information_schema' AND EXISTS
        (SELECT 1 FROM pg_class WHERE relname = 'tables' AND
            relnamespace = nsp.oid LIMIT 1))
    )
ORDER BY nspname;
2020-05-02 20:22:33,190: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:33] "[37mGET /browser/schema/nodes/2/1/1680798/ HTTP/1.1[0m" 200 -
2020-05-02 20:22:33,301: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 4147406):
SELECT
    nsp.nspname as schema_name,
    (nsp.nspname = 'pg_catalog' AND EXISTS
        (SELECT 1 FROM pg_class WHERE relname = 'pg_class' AND
            relnamespace = nsp.oid LIMIT 1)) OR
    (nsp.nspname = 'pgagent' AND EXISTS
        (SELECT 1 FROM pg_class WHERE relname = 'pga_job' AND
            relnamespace = nsp.oid LIMIT 1)) OR
    (nsp.nspname = 'information_schema' AND EXISTS
        (SELECT 1 FROM pg_class WHERE relname = 'tables' AND
            relnamespace = nsp.oid LIMIT 1)) AS is_catalog,
    CASE
    WHEN nsp.nspname = ANY('{information_schema}')
        THEN false
    ELSE true END AS db_support
FROM
    pg_catalog.pg_namespace nsp
WHERE
    nsp.oid = 2200::OID;
2020-05-02 20:22:33,349: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:33] "[37mGET /browser/schema/children/2/1/1680798/2200 HTTP/1.1[0m" 200 -
2020-05-02 20:22:33,527: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:33] "[37mGET /browser/fts_dictionary/static/img/coll-fts_dictionary.svg?ver=42100 HTTP/1.1[0m" 200 -
2020-05-02 20:22:33,559: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:33] "[37mGET /browser/fts_configuration/static/img/coll-fts_configuration.svg?ver=42100 HTTP/1.1[0m" 200 -
2020-05-02 20:22:33,580: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:33] "[37mGET /browser/collation/static/img/coll-collation.svg?ver=42100 HTTP/1.1[0m" 200 -
2020-05-02 20:22:33,595: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:33] "[37mGET /browser/fts_parser/static/img/coll-fts_parser.svg?ver=42100 HTTP/1.1[0m" 200 -
2020-05-02 20:22:33,606: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:33] "[37mGET /browser/fts_template/static/img/coll-fts_template.svg?ver=42100 HTTP/1.1[0m" 200 -
2020-05-02 20:22:33,624: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:33] "[37mGET /browser/trigger_function/static/img/coll-trigger_function.svg?ver=42100 HTTP/1.1[0m" 200 -
2020-05-02 20:22:33,624: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:33] "[37mGET /browser/procedure/static/img/coll-procedure.svg?ver=42100 HTTP/1.1[0m" 200 -
2020-05-02 20:22:33,624: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:33] "[37mGET /browser/table/static/img/coll-table.svg?ver=42100 HTTP/1.1[0m" 200 -
2020-05-02 20:22:33,631: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:33] "[37mGET /browser/domain/static/img/coll-domain.svg?ver=42100 HTTP/1.1[0m" 200 -
2020-05-02 20:22:33,633: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:33] "[37mGET /browser/sequence/static/img/coll-sequence.svg?ver=42100 HTTP/1.1[0m" 200 -
2020-05-02 20:22:33,639: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:33] "[37mGET /browser/type/static/img/coll-type.svg?ver=42100 HTTP/1.1[0m" 200 -
2020-05-02 20:22:33,641: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:33] "[37mGET /browser/view/static/img/coll-view.svg?ver=42100 HTTP/1.1[0m" 200 -
2020-05-02 20:22:33,648: SQL	flask.app:	Execute (2darray) for server #1 - DB:foo (Query-id: 2915965):
SELECT rel.oid, rel.relname AS name,
    (SELECT count(*) FROM pg_trigger WHERE tgrelid=rel.oid AND tgisinternal = FALSE) AS triggercount,
    (SELECT count(*) FROM pg_trigger WHERE tgrelid=rel.oid AND tgisinternal = FALSE AND tgenabled = 'O') AS has_enable_triggers,
    (CASE WHEN rel.relkind = 'p' THEN true ELSE false END) AS is_partitioned,
    (SELECT count(1) FROM pg_inherits WHERE inhrelid=rel.oid LIMIT 1) as is_inherits,
    (SELECT count(1) FROM pg_inherits WHERE inhparent=rel.oid LIMIT 1) as is_inherited
FROM pg_class rel
    WHERE rel.relkind IN ('r','s','t','p') AND rel.relnamespace = 2200::oid
    AND NOT rel.relispartition
        ORDER BY rel.relname;
2020-05-02 20:22:33,658: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:33] "[37mGET /browser/table/nodes/2/1/1680798/2200/ HTTP/1.1[0m" 200 -
2020-05-02 20:22:33,820: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:33] "[37mGET /browser/table/static/img/table.svg?ver=42100 HTTP/1.1[0m" 200 -
2020-05-02 20:22:33,945: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 5052090):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:22:33,971: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:33] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:22:34,945: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 9670781):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:22:34,967: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:34] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:22:35,946: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 943058):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:22:35,968: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:35] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:22:36,945: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 632471):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:22:36,967: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:36] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:22:37,955: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 7140869):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:22:37,978: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:37] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:22:38,966: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 7964120):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:22:38,987: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:38] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:22:39,963: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 9375896):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:22:39,984: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:39] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:22:40,973: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 2174813):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:22:40,994: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:40] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:22:41,975: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 7327485):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:22:41,998: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:41] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:22:42,981: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 1523442):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:22:43,004: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:43] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:22:43,979: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 9880438):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:22:44,000: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:44] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:22:44,974: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 9386664):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:22:44,996: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:44] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:22:45,977: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 8519742):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:22:46,000: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:46] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:22:47,035: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 5006320):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:22:47,069: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:47] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:22:47,266: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:47] "[37mGET /preferences/ HTTP/1.1[0m" 200 -
2020-05-02 20:22:48,008: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 8706570):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:22:48,029: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:48] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:22:49,010: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 9225379):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:22:49,033: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:49] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:22:50,009: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 7469768):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:22:50,031: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:50] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:22:51,008: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 7503650):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:22:51,031: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:51] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:22:52,010: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 6503892):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:22:52,031: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:52] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:22:53,009: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 753176):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:22:53,031: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:53] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:22:54,010: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 5359311):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:22:54,032: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:54] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:22:55,011: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 3452227):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:22:55,033: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:55] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:22:56,010: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 4282360):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:22:56,031: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:56] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:22:57,011: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 1173981):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:22:57,032: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:57] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:22:57,086: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:57] "[37mPOST /settings/save_tree_state/ HTTP/1.1[0m" 200 -
2020-05-02 20:22:58,011: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 6425745):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:22:58,033: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:58] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:22:59,011: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 6080096):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:22:59,032: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:22:59] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:23:00,026: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 8986604):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:23:00,048: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:23:00] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:23:01,022: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 4344870):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:23:01,043: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:23:01] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:23:02,023: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 4185638):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:23:02,045: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:23:02] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:23:03,028: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 2831080):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:23:03,050: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:23:03] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:23:04,022: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 4548186):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:23:04,044: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:23:04] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:23:05,028: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 6017854):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:23:05,049: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:23:05] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:23:06,029: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 2076439):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:23:06,051: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:23:06] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:23:07,028: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 9882150):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:23:07,049: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:23:07] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:23:08,029: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 6538245):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:23:08,051: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:23:08] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:23:09,042: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 7566330):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:23:09,064: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:23:09] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:23:10,500: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 3782127):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:23:10,522: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:23:10] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:23:13,532: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 6632095):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:23:13,554: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:23:13] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:23:14,540: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 4289807):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:23:14,562: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:23:14] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:23:16,568: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 4148319):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:23:16,591: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:23:16] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:23:18,582: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 9013361):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:23:18,605: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:23:18] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:23:19,578: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 5833983):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:23:19,600: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:23:19] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:23:20,583: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 9738183):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:23:20,604: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:23:20] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:23:22,595: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 6564689):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:23:22,618: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:23:22] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:23:23,592: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 499110):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:23:23,614: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:23:23] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:23:24,600: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 1688003):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:23:24,622: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:23:24] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:23:26,597: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 9548007):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:23:26,618: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:23:26] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:23:27,602: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 1131372):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:23:27,624: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:23:27] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:23:29,599: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 5849138):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:23:29,620: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:23:29] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:23:30,608: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 1557146):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:23:30,629: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:23:30] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:23:32,606: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 5896801):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:23:32,628: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:23:32] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:23:33,606: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 2699402):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:23:33,628: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:23:33] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:23:35,613: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 5375783):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:23:35,635: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:23:35] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:23:36,622: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 9962712):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:23:36,644: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:23:36] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:23:38,622: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 8288663):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:23:38,643: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:23:38] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
2020-05-02 20:23:39,670: SQL	flask.app:	Execute (dict) for server #1 - DB:foo (Query-id: 2685963):
/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Total",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Active",
   (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1680798))  AS "Idle"
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Transactions",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Commits",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Rollbacks"
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Inserts",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Updates",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Fetched",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Returned"
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Reads",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1680798)) AS "Hits"
) t

2020-05-02 20:23:39,694: INFO	werkzeug:	127.0.0.1 - - [02/May/2020 20:23:39] "[37mGET /dashboard/dashboard_stats/1/1680798?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1[0m" 200 -
