BUG #15204: Export to CSV doesn't work in Query tools - Mailing list pgsql-bugs
| From | PG Bug reporting form |
|---|---|
| Subject | BUG #15204: Export to CSV doesn't work in Query tools |
| Date | |
| Msg-id | 152656505558.1306.10001254549356380459@wrigleys.postgresql.org Whole thread Raw |
| Responses |
Re: BUG #15204: Export to CSV doesn't work in Query tools
("David G. Johnston" <david.g.johnston@gmail.com>)
|
| List | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 15204
Logged by: Nicolas Devis
Email address: nhegi@hotmail.com
PostgreSQL version: 10.3
Operating system: windows 10 pro
Description:
Hello,
When I create a query in the query tool windows and press the "Download as
CSV" button, nothing happens.
I ve installed many versions of Pgadmin (4.3 4.2.1 4.2.0 and different
4.1.XX) but there is the same problem everytime.
Thanks !
I try to show you the log when i m doing that :
2018-05-17 15:48:02,543:
INFO pgadmin: ########################################################
2018-05-17 15:48:02,546: INFO pgadmin: Starting pgAdmin 4 v2.1...
2018-05-17 15:48:02,546:
INFO pgadmin: ########################################################
2018-05-17 15:48:02,546: DEBUG pgadmin: Python syspath: ['C:\\Program Files
(x86)\\pgAdmin 4\\v2\\web', 'C:\\Program Files (x86)\\pgAdmin
4\\v2\\runtime\\python27.zip', 'C:/Program Files (x86)/pgAdmin
4/v2/venv\\DLLs', 'C:/Program Files (x86)/pgAdmin 4/v2/venv\\lib',
'C:/Program Files (x86)/pgAdmin 4/v2/venv\\lib\\plat-win', 'C:/Program Files
(x86)/pgAdmin 4/v2/venv\\lib\\lib-tk', 'C:\\Program Files (x86)\\pgAdmin
4\\v2\\runtime', 'C:/Program Files (x86)/pgAdmin
4/v2/venv/Lib/site-packages', 'C:/Program Files (x86)/pgAdmin
4/v2/venv/DLLs', 'C:/Program Files (x86)/pgAdmin 4/v2/venv/Lib']
2018-05-17 15:48:02,549: DEBUG pgadmin: Available translations:
[Locale('de'), Locale('ja'), Locale('pl'), Locale('ru'), Locale('zh')]
2018-05-17 15:48:03,569: INFO pgadmin: Examining potential module:
pgadmin.about
2018-05-17 15:48:03,585: INFO pgadmin: Registering blueprint module:
<pgadmin.about.AboutModule object at 0x10801750>
2018-05-17 15:48:03,586: INFO pgadmin: Examining potential module:
pgadmin.browser
2018-05-17 15:48:03,635: INFO pgadmin: Registering blueprint module:
<pgadmin.browser.BrowserModule object at 0x0CCA47B0>
2018-05-17 15:48:03,637: INFO pgadmin: Examining potential module:
pgadmin.browser.collection
2018-05-17 15:48:03,657: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups
2018-05-17 15:48:03,674: INFO pgadmin: Examining potential module:
pgadmin.browser.utils
2018-05-17 15:48:03,677: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers
2018-05-17 15:48:03,717: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases
2018-05-17 15:48:03,746: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.gpdb
2018-05-17 15:48:03,750: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.pgagent
2018-05-17 15:48:03,766: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.ppas
2018-05-17 15:48:03,769: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.resource_groups
2018-05-17 15:48:03,785: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.roles
2018-05-17 15:48:03,803: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.tablespaces
2018-05-17 15:48:03,821: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.types
2018-05-17 15:48:03,822: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.utils
2018-05-17 15:48:03,828: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.casts
2018-05-17 15:48:03,845: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.event_triggers
2018-05-17 15:48:03,865: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.extensions
2018-05-17 15:48:03,881: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.foreign_data_wrappers
2018-05-17 15:48:03,898: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.languages
2018-05-17 15:48:03,915: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas
2018-05-17 15:48:03,933: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.utils
2018-05-17 15:48:03,961: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.foreign_data_wrappers.foreign_servers
2018-05-17 15:48:03,990: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.foreign_data_wrappers.foreign_servers.user_mapping
2018-05-17 15:48:04,032: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.catalog_objects
2018-05-17 15:48:04,052: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.collations
2018-05-17 15:48:04,068: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.domains
2018-05-17 15:48:04,082: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.foreign_tables
2018-05-17 15:48:04,104: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.fts_configurations
2018-05-17 15:48:04,119: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.fts_dictionaries
2018-05-17 15:48:04,137: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.fts_parser
2018-05-17 15:48:04,154: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.fts_templates
2018-05-17 15:48:04,170: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.functions
2018-05-17 15:48:04,194: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.packages
2018-05-17 15:48:04,210: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.sequences
2018-05-17 15:48:04,227: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.synonyms
2018-05-17 15:48:04,243: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.tables
2018-05-17 15:48:04,288: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.types
2018-05-17 15:48:04,308: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.utils
2018-05-17 15:48:04,309: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.views
2018-05-17 15:48:04,338: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.catalog_objects.columns
2018-05-17 15:48:04,369: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.domains.domain_constraints
2018-05-17 15:48:04,490: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.packages.edbfuncs
2018-05-17 15:48:04,509: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.packages.edbvars
2018-05-17 15:48:04,559: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.tables.column
2018-05-17 15:48:04,581: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints
2018-05-17 15:48:04,596: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.tables.indexes
2018-05-17 15:48:04,617: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.tables.partitions
2018-05-17 15:48:04,634: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.tables.rules
2018-05-17 15:48:04,651: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.tables.triggers
2018-05-17 15:48:04,673: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.tables.utils
2018-05-17 15:48:04,700: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints.check_constraint
2018-05-17 15:48:04,730: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints.exclusion_constraint
2018-05-17 15:48:04,760: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints.foreign_key
2018-05-17 15:48:04,795: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints.index_constraint
2018-05-17 15:48:04,838: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints.type
2018-05-17 15:48:04,928: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.views.children
2018-05-17 15:48:04,979: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.views.children
2018-05-17 15:48:05,022: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.catalog_objects
2018-05-17 15:48:05,023: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.collations
2018-05-17 15:48:05,023: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.domains
2018-05-17 15:48:05,023: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.foreign_tables
2018-05-17 15:48:05,023: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.fts_configurations
2018-05-17 15:48:05,025: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.fts_dictionaries
2018-05-17 15:48:05,025: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.fts_parser
2018-05-17 15:48:05,026: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.fts_templates
2018-05-17 15:48:05,026: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.functions
2018-05-17 15:48:05,026: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.packages
2018-05-17 15:48:05,026: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.sequences
2018-05-17 15:48:05,026: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.synonyms
2018-05-17 15:48:05,028: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.tables
2018-05-17 15:48:05,029: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.types
2018-05-17 15:48:05,029: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.utils
2018-05-17 15:48:05,029: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.databases.schemas.views
2018-05-17 15:48:05,505: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.pgagent.schedules
2018-05-17 15:48:05,520: INFO pgadmin: Examining potential module:
pgadmin.browser.server_groups.servers.pgagent.steps
2018-05-17 15:48:05,565: INFO pgadmin: Examining potential module:
pgadmin.dashboard
2018-05-17 15:48:05,582: INFO pgadmin: Registering blueprint module:
<pgadmin.dashboard.DashboardModule object at 0x10801F70>
2018-05-17 15:48:05,591: INFO pgadmin: Examining potential module:
pgadmin.help
2018-05-17 15:48:05,601: INFO pgadmin: Registering blueprint module:
<pgadmin.help.HelpModule object at 0x115BCF90>
2018-05-17 15:48:05,602: INFO pgadmin: Examining potential module:
pgadmin.misc
2018-05-17 15:48:05,612: INFO pgadmin: Registering blueprint module:
<pgadmin.misc.MiscModule object at 0x115DDDD0>
2018-05-17 15:48:05,614: INFO pgadmin: Examining potential module:
pgadmin.misc.bgprocess
2018-05-17 15:48:05,668: INFO pgadmin: Examining potential module:
pgadmin.misc.depends
2018-05-17 15:48:05,674: INFO pgadmin: Examining potential module:
pgadmin.misc.file_manager
2018-05-17 15:48:05,703: INFO pgadmin: Examining potential module:
pgadmin.misc.sql
2018-05-17 15:48:05,707: INFO pgadmin: Examining potential module:
pgadmin.misc.statistics
2018-05-17 15:48:05,714: INFO pgadmin: Examining potential module:
pgadmin.misc.bgprocess.process_executor
2018-05-17 15:48:05,726: INFO pgadmin: Examining potential module:
pgadmin.misc.bgprocess.processes
2018-05-17 15:48:05,734: INFO pgadmin: Examining potential module:
pgadmin.model
2018-05-17 15:48:05,734: INFO pgadmin: Examining potential module:
pgadmin.preferences
2018-05-17 15:48:05,746: INFO pgadmin: Registering blueprint module:
<pgadmin.preferences.PreferencesModule object at 0x11759F70>
2018-05-17 15:48:05,750: INFO pgadmin: Examining potential module:
pgadmin.redirects
2018-05-17 15:48:05,756: INFO pgadmin: Registering blueprint module:
<pgadmin.utils.PgAdminModule object at 0x11759F50>
2018-05-17 15:48:05,757: INFO pgadmin: Examining potential module:
pgadmin.settings
2018-05-17 15:48:05,757: INFO pgadmin: Registering blueprint module:
<pgadmin.settings.SettingsModule object at 0x0CCA4610>
2018-05-17 15:48:05,759: INFO pgadmin: Examining potential module:
pgadmin.setup
2018-05-17 15:48:05,760: INFO pgadmin: Examining potential module:
pgadmin.tools
2018-05-17 15:48:05,769: INFO pgadmin: Registering blueprint module:
<pgadmin.tools.ToolsModule object at 0x116A4FD0>
2018-05-17 15:48:05,769: INFO pgadmin: Examining potential module:
pgadmin.tools.backup
2018-05-17 15:48:05,790: INFO pgadmin: Examining potential module:
pgadmin.tools.datagrid
2018-05-17 15:48:06,003: INFO pgadmin: Examining potential module:
pgadmin.tools.debugger
2018-05-17 15:48:06,028: INFO pgadmin: Examining potential module:
pgadmin.tools.grant_wizard
2018-05-17 15:48:06,046: INFO pgadmin: Examining potential module:
pgadmin.tools.import_export
2018-05-17 15:48:06,059: INFO pgadmin: Examining potential module:
pgadmin.tools.maintenance
2018-05-17 15:48:06,069: INFO pgadmin: Examining potential module:
pgadmin.tools.restore
2018-05-17 15:48:06,084: INFO pgadmin: Examining potential module:
pgadmin.tools.sqleditor
2018-05-17 15:48:06,085: INFO pgadmin: Examining potential module:
pgadmin.tools.user_management
2018-05-17 15:48:06,118: INFO pgadmin: Examining potential module:
pgadmin.tools.sqleditor.command
2018-05-17 15:48:06,128: INFO pgadmin: Examining potential module:
pgadmin.utils
2018-05-17 15:48:06,226: DEBUG pgadmin: Running under the desktop runtime,
port: 59595
2018-05-17 15:48:06,226: DEBUG pgadmin: Desktop security key:
71420cd3-b515-4d08-a05c-bc8fdbbe994b
2018-05-17 15:48:06,276: INFO werkzeug: * Running on
http://127.0.0.1:59595/ (Press CTRL+C to quit)
2018-05-17 15:48:06,779: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:06]
"GET /misc/ping?key=71420cd3-b515-4d08-a05c-bc8fdbbe994b HTTP/1.1" 200 -
2018-05-17 15:48:07,595: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:07]
"GET /?key=71420cd3-b515-4d08-a05c-bc8fdbbe994b HTTP/1.1" 302 -
2018-05-17 15:48:07,825: DEBUG pgadmin: Checking version data at:
https://www.pgadmin.org/versions.json?version=2.1
2018-05-17 15:48:09,558: DEBUG pgadmin: Version check HTTP response code:
200
2018-05-17 15:48:09,565: DEBUG pgadmin: Response data: {u'pgadmin4':
{u'version': u'2.1', u'version_int': 20005, u'download_url':
u'https://www.pgadmin.org/download/'}}
2018-05-17 15:48:09,634: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:09]
"GET /browser/ HTTP/1.1" 200 -
2018-05-17 15:48:10,976: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:10]
"GET /browser/browser.css HTTP/1.1" 200 -
2018-05-17 15:48:11,045: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:11]
"GET /static/vendor/backgrid/backgrid.css HTTP/1.1" 200 -
2018-05-17 15:48:11,066: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:11]
"GET /static/js/generated/pgadmin_commons.js HTTP/1.1" 200 -
2018-05-17 15:48:11,078: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:11]
"GET /static/js/generated/style.css HTTP/1.1" 200 -
2018-05-17 15:48:11,078: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:11]
"GET /static/vendor/require/require.min.js HTTP/1.1" 200 -
2018-05-17 15:48:11,085: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:11]
"GET /static/js/generated/pgadmin.css HTTP/1.1" 200 -
2018-05-17 15:48:11,088: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:11]
"GET /static/js/generated/vendor.js HTTP/1.1" 200 -
2018-05-17 15:48:11,556: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:11]
"GET /static/js/generated/fonts/OpenSans-Regular.ttf HTTP/1.1" 200 -
2018-05-17 15:48:11,559: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:11]
"GET /static/js/generated/fonts/fontawesome-webfont.woff2 HTTP/1.1" 200 -
2018-05-17 15:48:11,575: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:11]
"GET /static/js/generated/app.bundle.js HTTP/1.1" 200 -
2018-05-17 15:48:11,763: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:11]
"GET /browser/server/supported_servers.js HTTP/1.1" 200 -
2018-05-17 15:48:11,783: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:11]
"GET /browser/js/messages.js HTTP/1.1" 200 -
2018-05-17 15:48:11,801: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:11]
"GET /user_management/current_user.js HTTP/1.1" 200 -
2018-05-17 15:48:11,809: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:11]
"GET /browser/js/endpoints.js HTTP/1.1" 200 -
2018-05-17 15:48:11,822: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:11]
"GET /tools/translations.js HTTP/1.1" 200 -
2018-05-17 15:48:11,834: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:11]
"GET /static/js/gettext.js HTTP/1.1" 200 -
2018-05-17 15:48:11,848: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:11]
"GET /static/js/pgadmin.js HTTP/1.1" 200 -
2018-05-17 15:48:11,871: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:11]
"GET /browser/js/utils.js HTTP/1.1" 200 -
2018-05-17 15:48:12,269: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:12]
"GET /static/css//webcabin.overrides.css?v=1526564892230 HTTP/1.1" 200 -
2018-05-17 15:48:12,344: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:12]
"GET /preferences/get_all HTTP/1.1" 200 -
2018-05-17 15:48:12,766: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:12]
"GET /static/css/webcabin.overrides.css?v=1526564892732 HTTP/1.1" 200 -
2018-05-17 15:48:12,785: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:12]
"GET /dashboard/ HTTP/1.1" 200 -
2018-05-17 15:48:12,937: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:12]
"GET /dashboard/static/img/welcome_logo.png HTTP/1.1" 200 -
2018-05-17 15:48:12,940: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:12]
"GET /browser/nodes/ HTTP/1.1" 200 -
2018-05-17 15:48:13,128: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:13]
"POST /settings/store HTTP/1.1" 200 -
2018-05-17 15:48:13,141: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:13]
"POST /settings/store HTTP/1.1" 200 -
2018-05-17 15:48:13,253: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:13]
"GET /browser/server_group/static/img/server_group.svg HTTP/1.1" 200 -
2018-05-17 15:48:13,257: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:13]
"GET /static/js/generated/img/tree-small.png HTTP/1.1" 200 -
2018-05-17 15:48:13,257: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:13]
"GET /static/js/generated/img/load-node.gif HTTP/1.1" 200 -
2018-05-17 15:48:13,911: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:13]
"GET /misc/bgprocess/?_=1526564892000 HTTP/1.1" 200 -
2018-05-17 15:48:15,480: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:15]
"GET /browser/server_group/children/1 HTTP/1.1" 200 -
2018-05-17 15:48:15,551: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:15]
"GET /browser/server/static/img/serverbad.svg HTTP/1.1" 200 -
2018-05-17 15:48:16,538: INFO pgadmin: Connection Request for server#1
2018-05-17 15:48:16,558: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:16]
"POST /browser/server/connect/1/1 HTTP/1.1" 428 -
2018-05-17 15:48:20,144: INFO pgadmin: Connection Request for server#1
2018-05-17 15:48:20,226: INFO pgadmin: Connection Established for server:
1 - PostgreSQL 10
2018-05-17 15:48:20,230: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 4522203):
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
2018-05-17 15:48:20,242: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:20]
"POST /browser/server/connect/1/1 HTTP/1.1" 200 -
2018-05-17 15:48:20,286: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:20]
"GET /browser/server/static/img/pg.svg HTTP/1.1" 200 -
2018-05-17 15:48:20,401: SQL pgadmin: Execute (scalar) for server #1 -
DB:postgres (Query-id: 6548177):
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'
)
)
2018-05-17 15:48:20,434: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:20]
"GET /browser/server/children/1/1 HTTP/1.1" 200 -
2018-05-17 15:48:20,453: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:20]
"GET /dashboard/1 HTTP/1.1" 200 -
2018-05-17 15:48:20,608: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 8282226):
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
2018-05-17 15:48:20,617: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:20]
"GET /dashboard/activity/1 HTTP/1.1" 200 -
2018-05-17 15:48:20,823: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:20]
"GET /browser/tablespace/static/img/coll-tablespace.svg HTTP/1.1" 200 -
2018-05-17 15:48:20,825: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:20]
"GET /browser/role/static/img/coll-role.svg HTTP/1.1" 200 -
2018-05-17 15:48:20,825: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:20]
"GET /browser/database/static/img/coll-database.svg HTTP/1.1" 200 -
2018-05-17 15:48:20,825: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:20]
"GET /static/js/generated/img/tree-branch.png HTTP/1.1" 200 -
2018-05-17 15:48:21,815: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 4442184):
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"
2018-05-17 15:48:21,822: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:21]
"GET /dashboard/session_stats/1 HTTP/1.1" 200 -
2018-05-17 15:48:21,887: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 1440332):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database) AS "Returned"
2018-05-17 15:48:21,887: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 5984988):
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"
2018-05-17 15:48:21,887: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 8240885):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database) AS "Hits"
2018-05-17 15:48:21,890: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 3217329):
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"
2018-05-17 15:48:21,905: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:21]
"GET /dashboard/to_stats/1 HTTP/1.1" 200 -
2018-05-17 15:48:21,907: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:21]
"GET /dashboard/bio_stats/1 HTTP/1.1" 200 -
2018-05-17 15:48:21,907: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:21]
"GET /dashboard/tps_stats/1 HTTP/1.1" 200 -
2018-05-17 15:48:21,907: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:21]
"GET /dashboard/ti_stats/1 HTTP/1.1" 200 -
2018-05-17 15:48:22,743: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 1314275):
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 > 12937::OID
ORDER BY datname;
2018-05-17 15:48:22,750: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:22]
"GET /browser/database/nodes/1/1/ HTTP/1.1" 200 -
2018-05-17 15:48:22,832: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:22]
"GET /browser/database/static/img/databasebad.svg HTTP/1.1" 200 -
2018-05-17 15:48:22,834: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:22]
"GET /browser/database/static/img/database.svg HTTP/1.1" 200 -
2018-05-17 15:48:22,881: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 566599):
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"
2018-05-17 15:48:22,885: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:22]
"GET /dashboard/session_stats/1 HTTP/1.1" 200 -
2018-05-17 15:48:22,976: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 6372365):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database) AS "Returned"
2018-05-17 15:48:22,994: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:22]
"GET /dashboard/to_stats/1 HTTP/1.1" 200 -
2018-05-17 15:48:23,016: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 8135370):
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"
2018-05-17 15:48:23,019: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 1864514):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database) AS "Hits"
2018-05-17 15:48:23,020: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 5029387):
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"
2018-05-17 15:48:23,022: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:23]
"GET /dashboard/tps_stats/1 HTTP/1.1" 200 -
2018-05-17 15:48:23,025: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:23]
"GET /dashboard/bio_stats/1 HTTP/1.1" 200 -
2018-05-17 15:48:23,028: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:23]
"GET /dashboard/ti_stats/1 HTTP/1.1" 200 -
2018-05-17 15:48:23,927: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 4667038):
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"
2018-05-17 15:48:23,930: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:23]
"GET /dashboard/session_stats/1 HTTP/1.1" 200 -
2018-05-17 15:48:24,030: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 5426259):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database) AS "Returned"
2018-05-17 15:48:24,046: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:24]
"GET /dashboard/to_stats/1 HTTP/1.1" 200 -
2018-05-17 15:48:24,052: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 5127976):
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"
2018-05-17 15:48:24,056: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:24]
"GET /dashboard/tps_stats/1 HTTP/1.1" 200 -
2018-05-17 15:48:24,095: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 8139352):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database) AS "Hits"
2018-05-17 15:48:24,098: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 3756955):
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"
2018-05-17 15:48:24,101: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:24]
"GET /dashboard/bio_stats/1 HTTP/1.1" 200 -
2018-05-17 15:48:24,102: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:24]
"GET /dashboard/ti_stats/1 HTTP/1.1" 200 -
2018-05-17 15:48:24,138: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 9986595):
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 = 45511
2018-05-17 15:48:24,194: INFO pgadmin: Connection Established for Database
Id: 45511
2018-05-17 15:48:24,203: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:24]
"POST /browser/database/connect/1/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:24,348: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:24]
"GET /browser/database/children/1/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:24,368: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:24]
"GET /dashboard/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:24,450: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 6103352):
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 = 45511)ORDER BY
pid
2018-05-17 15:48:24,454: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:24]
"GET /dashboard/activity/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:24,644: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:24]
"GET /browser/event_trigger/static/img/coll-event_trigger.svg HTTP/1.1" 200
-
2018-05-17 15:48:24,647: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:24]
"GET /browser/foreign_data_wrapper/static/img/coll-foreign_data_wrapper.svg
HTTP/1.1" 200 -
2018-05-17 15:48:24,648: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:24]
"GET /browser/cast/static/img/coll-cast.svg HTTP/1.1" 200 -
2018-05-17 15:48:24,651: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:24]
"GET /browser/catalog/static/img/coll-catalog.svg HTTP/1.1" 200 -
2018-05-17 15:48:24,653: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:24]
"GET /browser/language/static/img/coll-language.svg HTTP/1.1" 200 -
2018-05-17 15:48:24,654: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:24]
"GET /browser/extension/static/img/coll-extension.svg HTTP/1.1" 200 -
2018-05-17 15:48:24,677: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:24]
"GET /browser/schema/static/img/coll-schema.svg HTTP/1.1" 200 -
2018-05-17 15:48:24,971: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 3722449):
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"
2018-05-17 15:48:24,976: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:24]
"GET /dashboard/session_stats/1 HTTP/1.1" 200 -
2018-05-17 15:48:25,101: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 4411461):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database) AS "Returned"
2018-05-17 15:48:25,117: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 5017616):
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"
2018-05-17 15:48:25,117: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:25]
"GET /dashboard/to_stats/1 HTTP/1.1" 200 -
2018-05-17 15:48:25,121: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:25]
"GET /dashboard/tps_stats/1 HTTP/1.1" 200 -
2018-05-17 15:48:25,134: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 583237):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database) AS "Hits"
2018-05-17 15:48:25,141: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:25]
"GET /dashboard/bio_stats/1 HTTP/1.1" 200 -
2018-05-17 15:48:25,154: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 398404):
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"
2018-05-17 15:48:25,157: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:25]
"GET /dashboard/ti_stats/1 HTTP/1.1" 200 -
2018-05-17 15:48:25,494: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 4022894):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:48:25,506: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:25]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:25,509: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 8843694):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:48:25,509: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 5189599):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:48:25,510: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 7027031):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:48:25,512: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 5681116):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:48:25,522: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:25]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:25,522: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:25]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:25,523: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:25]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:25,523: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:25]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:26,607: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 4928487):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:48:26,609: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 5516996):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:48:26,631: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:26]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:26,631: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:26]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:26,644: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 7635059):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:48:26,644: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 1208236):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:48:26,644: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 5458941):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:48:26,654: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:26]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:26,654: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:26]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:26,654: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:26]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:27,733: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 8489906):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:48:27,740: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:27]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:27,780: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 3004611):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:48:27,782: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 8170183):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:48:27,789: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 466771):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:48:27,789: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 3396409):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:48:27,808: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:27]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:27,808: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:27]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:27,808: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:27]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:27,808: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:27]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:28,780: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 6100139):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:48:28,786: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:28]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:28,914: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 9646754):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:48:28,931: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:28]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:28,944: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 2970995):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:48:28,946: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 2918438):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:48:28,946: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 6164458):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:48:28,957: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:28]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:28,957: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:28]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:28,959: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:28]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:29,595: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:29]
"POST /datagrid/initialize/query_tool/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:29,750: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:29]
"POST /settings/store HTTP/1.1" 200 -
2018-05-17 15:48:29,871: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 4958765):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:48:29,875: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:29]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:30,005: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:30]
"GET
/datagrid/panel/179254/true/p17330_wufl%20on%20postgres%40PostgreSQL%2010?query_url=&server_type=pg
HTTP/1.1" 200 -
2018-05-17 15:48:30,023: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 2643428):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:48:30,045: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:30]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:30,063: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 5881650):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:48:30,072: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 3009928):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:48:30,073: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:30]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:30,085: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 9565743):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:48:30,086: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:30]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:30,095: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:30]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:30,125: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:30]
"GET /sqleditor/static/css/sqleditor.css HTTP/1.1" 200 -
2018-05-17 15:48:30,176: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:30]
"GET /browser/browser.css HTTP/1.1" 200 -
2018-05-17 15:48:30,256: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:30]
"GET /static/js/generated/sqleditor.js HTTP/1.1" 200 -
2018-05-17 15:48:30,345: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:30]
"GET /browser/js/messages.js HTTP/1.1" 200 -
2018-05-17 15:48:30,351: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:30]
"GET /tools/translations.js HTTP/1.1" 200 -
2018-05-17 15:48:30,358: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:30]
"GET /browser/js/endpoints.js HTTP/1.1" 200 -
2018-05-17 15:48:30,378: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:30]
"GET /browser/js/utils.js HTTP/1.1" 200 -
2018-05-17 15:48:30,655: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:30]
"GET /static/css/webcabin.overrides.css?v=1526564910628 HTTP/1.1" 200 -
2018-05-17 15:48:30,809: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:30]
"GET /sqleditor/query_tool/preferences/179254 HTTP/1.1" 200 -
2018-05-17 15:48:30,844: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:30]
"GET /static/js/generated/fonts/SourceCodePro-Regular.ttf HTTP/1.1" 200 -
2018-05-17 15:48:30,927: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 1771971):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:48:30,933: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:30]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:31,131: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 9505138):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:48:31,148: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:31]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:31,161: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 4778429):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:48:31,163: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 3716003):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:48:31,170: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 9746261):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:48:31,171: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:31]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:31,171: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:31]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:31,176: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:31]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:32,000: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 7148464):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:48:32,006: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:32]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:32,168: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 534392):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:48:32,184: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:32]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:32,194: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 2933737):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:48:32,200: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:32]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:32,232: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 9861098):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:48:32,232: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 933990):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:48:32,239: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:32]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:32,240: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:32]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:33,042: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 633935):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:48:33,046: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:33]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:33,273: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 2853222):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:48:33,275: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 1319542):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:48:33,296: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:33]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:33,296: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:33]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:33,303: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 9513593):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:48:33,303: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 911709):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:48:33,311: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:33]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:33,311: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:33]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:34,078: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 5235283):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:48:34,082: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:34]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:34,344: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 6415177):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:48:34,359: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:34]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:34,401: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 7214696):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:48:34,401: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 9339691):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:48:34,401: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 1032667):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:48:34,410: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:34]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:34,410: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:34]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:34,410: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:34]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:35,145: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 3520730):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:48:35,151: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:35]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:35,391: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 372039):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:48:35,405: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:35]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:35,493: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 7774685):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:48:35,496: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 280251):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:48:35,496: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 9373451):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:48:35,499: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:35]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:35,503: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:35]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:35,503: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:35]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:36,190: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 510068):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:48:36,196: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:36]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:36,437: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 5761273):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:48:36,453: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:36]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:36,592: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 3634443):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:48:36,592: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 175933):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:48:36,592: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 8627125):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:48:36,599: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:36]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:36,601: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:36]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:36,601: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:36]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:37,233: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 3339681):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:48:37,236: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:37]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:37,490: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 9083483):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:48:37,505: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:37]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:37,687: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 3332278):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:48:37,693: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 6882559):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:48:37,694: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 3402193):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:48:37,694: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:37]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:37,698: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:37]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:37,703: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:37]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:38,266: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 7945714):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:48:38,272: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:38]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:38,540: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 7179184):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:48:38,555: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:38]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:38,782: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 1185795):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:48:38,785: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 3327088):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:48:38,785: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 725776):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:48:38,792: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:38]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:38,792: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:38]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:38,792: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:38]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:38,891: SQL pgadmin: Execute (async) for server #1 -
CONN:3355698 (Query-id: 3319559):
select* from global
2018-05-17 15:48:38,895: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:38]
"POST /sqleditor/query_tool/start/179254 HTTP/1.1" 200 -
2018-05-17 15:48:38,914: SQL pgadmin: Polling result for (Query-id:
3319559)
2018-05-17 15:48:38,920: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:38]
"GET /sqleditor/poll/179254 HTTP/1.1" 200 -
2018-05-17 15:48:38,937: SQL pgadmin: Polling result for (Query-id:
3319559)
2018-05-17 15:48:39,053: SQL pgadmin: Execute (dict) for server #1 -
DB:p17330_wufl (Query-id: 5083440):
SELECT oid, format_type(oid,null) as typname FROM pg_type WHERE oid IN %s
ORDER BY oid;
2018-05-17 15:48:39,069: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:39]
"GET /sqleditor/poll/179254 HTTP/1.1" 200 -
2018-05-17 15:48:39,278: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:39]
"GET /static/js/generated/img/ui-bg_glass_75_e6e6e6_1x400.png HTTP/1.1" 200
-
2018-05-17 15:48:39,711: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:39]
"GET /static/js/generated/img/ui-bg_flat_75_ffffff_40x100.png HTTP/1.1" 200
-
2018-05-17 15:48:39,711: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:39]
"GET /static/img/select-all-icon.png HTTP/1.1" 200 -
2018-05-17 15:48:39,723: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 2522995):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:48:39,724: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 8492105):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:48:39,743: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:39]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:39,744: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:39]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:39,894: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 4313113):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:48:39,897: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 4850582):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:48:39,898: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 4000080):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:48:39,901: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:39]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:39,904: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:39]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:39,904: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:39]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:40,897: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 2023972):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:48:40,901: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 8780221):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:48:40,904: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:40]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:40,921: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:40]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:40,951: SQL pgadmin: Execute (with server cursor) for
server #1 - CONN:3546228 (Query-id: 1147813):
select* from global
2018-05-17 15:48:40,970: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 198503):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:48:40,971: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 4125521):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:48:40,973: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 5725834):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:48:40,982: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:40]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:40,982: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:40]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:40,982: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:40]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:41,269: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:41]
"GET
/sqleditor/query_tool/download/179254?query=select*+from+global&filename=data-1526564920841.csv
HTTP/1.1" 500 -
2018-05-17 15:48:41,275: ERROR werkzeug: Error on request:
Traceback (most recent call last):
File "C:\Program Files (x86)\pgAdmin
4\v2\venv\Lib\site-packages\werkzeug\serving.py", line 209, in run_wsgi
execute(self.server.app)
File "C:\Program Files (x86)\pgAdmin
4\v2\venv\Lib\site-packages\werkzeug\serving.py", line 199, in execute
for data in application_iter:
File "C:\Program Files (x86)\pgAdmin
4\v2\venv\Lib\site-packages\werkzeug\wsgi.py", line 704, in __next__
return self._next()
File "C:\Program Files (x86)\pgAdmin
4\v2\venv\Lib\site-packages\werkzeug\wrappers.py", line 81, in
_iter_encoded
for item in iterable:
File "C:\Program Files (x86)\pgAdmin
4\v2\web\pgadmin\utils\driver\psycopg2\__init__.py", line 697, in gen
column_name = column_name.decode(conn_encoding)
LookupError: unknown encoding: WIN1252
2018-05-17 15:48:41,946: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 6524654):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:48:41,953: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:41]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:41,960: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 5897449):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:48:41,974: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:41]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:42,016: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 3067195):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:48:42,019: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:42]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:42,066: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 9740257):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:48:42,068: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 5583823):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:48:42,075: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:42]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:42,075: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:42]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:42,992: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 1302691):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:48:42,996: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:42]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:43,022: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 8564044):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:48:43,039: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:43]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:43,051: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 7227693):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:48:43,055: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:43]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:43,109: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 8669771):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:48:43,115: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:43]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:43,122: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 5388437):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:48:43,128: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:43]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:44,038: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 7009810):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:48:44,042: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:44]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:44,253: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 4125022):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:48:44,256: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 3067128):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:48:44,257: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 9477860):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:48:44,259: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 4996234):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:48:44,280: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:44]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:44,282: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:44]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:44,282: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:44]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:44,282: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:44]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:45,226: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 7912275):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:48:45,232: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:45]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:45,388: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 5912874):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:48:45,394: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 8129140):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:48:45,395: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 5581109):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:48:45,397: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 5285708):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:48:45,417: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:45]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:45,417: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:45]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:45,417: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:45]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:45,417: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:45]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:46,252: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 7066417):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:48:46,256: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:46]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:46,453: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 8861260):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:48:46,469: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:46]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:46,509: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 6935663):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:48:46,510: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 5704711):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:48:46,510: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 730583):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:48:46,519: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:46]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:46,520: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:46]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:46,520: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:46]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:47,296: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 8144664):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:48:47,302: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:47]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:47,497: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 5741293):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:48:47,513: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:47]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:47,573: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 7525208):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:48:47,579: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:47]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:47,595: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 375781):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:48:47,596: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 6333678):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:48:47,599: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:47]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:47,604: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:47]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:48,331: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 650990):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:48:48,335: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:48]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:48,543: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 6346163):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:48:48,558: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:48]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:48,625: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 9610144):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:48:48,631: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:48]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:48,645: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 5524273):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:48:48,651: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:48]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:48,651: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 9078149):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:48:48,655: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:48]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:49,365: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 136060):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:48:49,369: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:49]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:49,588: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 9239727):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:48:49,602: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:49]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:49,677: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 6505739):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:48:49,684: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:49]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:49,700: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 6370739):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:48:49,701: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 6712788):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:48:49,707: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:49]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:49,707: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:49]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:50,404: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 1281110):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:48:50,410: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:50]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:50,645: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 9623370):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:48:50,677: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:50]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:50,719: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 124819):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:48:50,723: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:50]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:50,763: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 4495145):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:48:50,766: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 9272162):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:48:50,769: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:50]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:50,773: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:50]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:51,433: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 6228647):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:48:51,437: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:51]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:51,711: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 7607162):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:48:51,726: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:51]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:51,766: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 9371325):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:48:51,769: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:51]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:51,828: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 8542556):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:48:51,828: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 8715700):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:48:51,835: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:51]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:51,835: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:51]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:52,463: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 5955273):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:48:52,467: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:52]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:52,753: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 3548717):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:48:52,766: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:52]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:52,798: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 539848):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:48:52,802: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:52]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:52,858: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 276796):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:48:52,865: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:52]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:52,875: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 888811):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:48:52,878: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:52]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:53,500: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 6291740):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:48:53,506: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:53]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:53,793: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 984075):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:48:53,808: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:53]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:53,845: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 5131822):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:48:53,849: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:53]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:53,881: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 4510929):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:48:53,887: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:53]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:53,920: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 1589369):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:48:53,924: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:53]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:54,530: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 1434005):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:48:54,536: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:54]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:54,891: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 7631914):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:48:54,892: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 5659070):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:48:54,898: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:54]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:54,898: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:54]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:54,936: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 9852371):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:48:54,943: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:54]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:54,953: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 7585578):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:48:54,960: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:54]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:55,565: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 4028312):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:48:55,569: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:55]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:55,936: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 4832419):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:48:55,954: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:55]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:55,956: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 381249):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:48:55,960: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:55]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:55,986: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 7925387):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:48:55,990: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 9491537):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:48:55,992: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:55]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:55,996: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:55]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:56,594: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 5136278):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:48:56,598: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:56]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:56,989: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 8085544):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:48:57,006: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:57]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:57,015: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 9051574):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:48:57,019: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:57]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:57,033: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 9297279):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:48:57,039: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:57]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:57,042: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 3331520):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:48:57,046: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:57]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:57,628: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 1850240):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:48:57,632: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:57]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:58,052: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 9145973):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:48:58,069: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:58]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:58,082: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 3069563):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:48:58,088: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:58]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:58,102: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 5826658):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:48:58,104: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 8306029):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:48:58,111: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:58]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:58,111: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:58]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:58,661: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 3143802):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:48:58,665: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:58]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:59,102: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 4273878):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:48:59,125: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:59]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:59,138: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 9130449):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:48:59,145: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:59]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:59,163: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 4257039):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:48:59,164: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 2702518):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:48:59,171: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:59]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:59,171: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:59]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:48:59,710: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 6244002):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:48:59,714: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:48:59]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:00,160: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 5477382):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:49:00,177: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:00]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:00,183: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 7901217):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:49:00,187: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:00]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:00,246: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 5361990):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:49:00,246: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 705134):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:49:00,255: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:00]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:00,255: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:00]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:00,736: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 4900740):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:49:00,740: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:00]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:01,236: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 4776241):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:49:01,250: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 1970036):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:49:01,253: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:01]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:01,256: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:01]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:01,312: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 1152079):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:49:01,312: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 8795669):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:49:01,319: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:01]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:01,319: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:01]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:01,785: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 4131266):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:49:01,789: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:01]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:02,312: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 6352260):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:49:02,312: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 2345156):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:49:02,329: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:02]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:02,329: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:02]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:02,361: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 1975401):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:49:02,365: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 2143035):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:49:02,367: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:02]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:02,369: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:02]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:02,821: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 2632504):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:49:02,825: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:02]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:03,368: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 2156169):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:49:03,371: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 507175):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:49:03,388: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:03]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:03,388: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:03]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:03,404: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 4779242):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:49:03,408: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 8263619):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:49:03,410: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:03]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:03,413: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:03]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:03,851: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 5277376):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:49:03,855: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:03]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:04,428: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 4983628):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:49:04,446: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:04]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:04,473: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 9956045):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:49:04,476: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 7644094):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:49:04,477: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 2233926):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:49:04,480: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:04]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:04,486: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:04]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:04,486: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:04]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:04,898: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 6363298):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:49:04,903: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:04]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:05,479: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 3132048):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:49:05,496: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:05]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:05,510: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 1630804):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:49:05,516: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:05]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:05,542: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 8493787):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:49:05,542: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 6290506):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:49:05,549: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:05]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:05,549: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:05]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:05,947: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 2102906):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:49:05,950: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:05]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:06,530: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 6908885):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:49:06,546: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:06]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:06,549: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 8280178):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:49:06,553: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:06]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:06,605: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 3124177):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:49:06,608: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 2715485):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:49:06,611: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:06]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:06,614: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:06]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:06,973: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 1401624):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:49:06,979: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:06]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:07,599: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 9345185):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:49:07,607: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 7646471):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:49:07,618: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:07]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:07,618: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:07]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:07,651: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 2899041):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:49:07,653: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 7005372):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:49:07,658: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:07]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:07,658: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:07]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:08,029: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 3761116):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:49:08,035: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:08]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:08,660: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 2257007):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:49:08,676: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:08]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:08,690: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 3981251):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:49:08,697: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:08]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:08,714: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 8198677):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:49:08,717: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 9670105):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:49:08,726: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:08]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:08,726: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:08]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:09,055: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 6413133):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:49:09,059: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:09]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:09,706: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 587664):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:49:09,721: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:09]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:09,730: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 9396743):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:49:09,734: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:09]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:09,773: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 9193319):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:49:09,775: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 49197):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:49:09,779: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:09]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:09,779: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:09]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:10,098: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 9388731):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:49:10,102: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:10]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:10,765: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 4831722):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:49:10,775: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 8235313):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:49:10,785: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:10]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:10,785: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:10]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:10,851: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 4182867):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:49:10,854: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 3170930):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:49:10,857: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:10]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:10,858: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:10]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:11,119: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 5771969):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:49:11,125: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:11]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:11,897: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 2895435):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:49:11,897: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 1528546):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:49:11,915: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:11]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:11,917: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:11]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:11,917: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 823955):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:49:11,918: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 4447512):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:49:11,927: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:11]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:11,927: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:11]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:12,157: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 2630402):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:49:12,161: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:12]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:13,032: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 6344293):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:49:13,039: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 6938952):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:49:13,040: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 8934628):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:49:13,042: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 8211669):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:49:13,055: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:13]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:13,055: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:13]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:13,055: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:13]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:13,055: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:13]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:13,190: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 6799726):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:49:13,194: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:13]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:14,138: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 7135657):
SELECT
(SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Hits"
2018-05-17 15:49:14,140: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 6635084):
SELECT
(SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE
datname = (SELECT datname FROM pg_database WHERE oid = 45511)) AS
"Transactions",
(SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Commits",
(SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Rollbacks"
2018-05-17 15:49:14,160: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 3994009):
SELECT
(SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Inserts",
(SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Updates",
(SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Deletes"
2018-05-17 15:49:14,160: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:14]
"GET /dashboard/bio_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:14,160: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 3388924):
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT
datname FROM pg_database WHERE oid = 45511)) AS "Returned"
2018-05-17 15:49:14,161: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:14]
"GET /dashboard/tps_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:14,167: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:14]
"GET /dashboard/to_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:14,167: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:14]
"GET /dashboard/ti_stats/1/45511 HTTP/1.1" 200 -
2018-05-17 15:49:14,221: SQL pgadmin: Execute (dict) for server #1 -
DB:postgres (Query-id: 1197317):
SELECT
(SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname
FROM pg_database WHERE oid = 45511)) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname
= (SELECT datname FROM pg_database WHERE oid = 45511)) AS "Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname =
(SELECT datname FROM pg_database WHERE oid = 45511)) AS "Idle"
2018-05-17 15:49:14,226: INFO werkzeug: 127.0.0.1 - - [17/May/2018 15:49:14]
"GET /dashboard/session_stats/1/45511 HTTP/1.1" 200 -
pgsql-bugs by date: