2019-11-29 19:12:11,275: INFO flask.app: ######################################################## 2019-11-29 19:12:11,276: INFO flask.app: Starting pgAdmin 4 v4.15... 2019-11-29 19:12:11,276: INFO flask.app: ######################################################## 2019-11-29 19:12:11,276: DEBUG flask.app: Python syspath: ['C:\\Program Files\\PostgreSQL\\12\\pgAdmin 4\\web', 'C:/Program Files/PostgreSQL/12/pgAdmin 4/venv/Lib/site-packages', 'C:/Program Files/PostgreSQL/12/pgAdmin 4/venv/DLLs', 'C:/Program Files/PostgreSQL/12/pgAdmin 4/venv/Lib', 'C:\\Program Files\\PostgreSQL\\12\\pgAdmin 4\\bin\\python37.zip', 'C:/Program Files/PostgreSQL/12/pgAdmin 4/venv\\DLLs', 'C:/Program Files/PostgreSQL/12/pgAdmin 4/venv\\lib', 'C:\\Program Files\\PostgreSQL\\12\\pgAdmin 4\\bin', 'C:/Program Files/PostgreSQL/12/pgAdmin 4/venv/Lib/site-packages', 'C:/Program Files/PostgreSQL/12/pgAdmin 4/venv/DLLs', 'C:/Program Files/PostgreSQL/12/pgAdmin 4/venv/Lib'] 2019-11-29 19:12:11,278: DEBUG flask.app: Available translations: [Locale('de'), Locale('es'), Locale('fr'), Locale('it'), Locale('ja'), Locale('ko'), Locale('pl'), Locale('ru'), Locale('zh')] 2019-11-29 19:12:11,648: INFO flask.app: Examining potential module: pgadmin.about 2019-11-29 19:12:11,650: INFO flask.app: Registering blueprint module: 2019-11-29 19:12:11,652: INFO flask.app: Examining potential module: pgadmin.browser 2019-11-29 19:12:11,660: INFO flask.app: Registering blueprint module: 2019-11-29 19:12:11,661: INFO flask.app: Examining potential module: pgadmin.browser.collection 2019-11-29 19:12:11,665: INFO flask.app: Examining potential module: pgadmin.browser.register_browser_preferences 2019-11-29 19:12:11,665: INFO flask.app: Examining potential module: pgadmin.browser.server_groups 2019-11-29 19:12:11,667: INFO flask.app: Examining potential module: pgadmin.browser.utils 2019-11-29 19:12:11,671: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers 2019-11-29 19:12:11,764: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases 2019-11-29 19:12:11,771: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.gpdb 2019-11-29 19:12:11,772: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.pgagent 2019-11-29 19:12:11,775: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.ppas 2019-11-29 19:12:11,776: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.resource_groups 2019-11-29 19:12:11,778: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.roles 2019-11-29 19:12:11,782: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.tablespaces 2019-11-29 19:12:11,786: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.types 2019-11-29 19:12:11,786: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.utils 2019-11-29 19:12:11,801: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.casts 2019-11-29 19:12:11,804: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.event_triggers 2019-11-29 19:12:11,807: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.extensions 2019-11-29 19:12:11,809: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.external_tables 2019-11-29 19:12:11,813: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.foreign_data_wrappers 2019-11-29 19:12:11,817: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.languages 2019-11-29 19:12:11,820: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas 2019-11-29 19:12:11,824: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.utils 2019-11-29 19:12:11,890: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.external_tables.actions 2019-11-29 19:12:11,891: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.external_tables.mapping_utils 2019-11-29 19:12:11,891: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.external_tables.properties 2019-11-29 19:12:11,891: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.external_tables.reverse_engineer_ddl 2019-11-29 19:12:11,897: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.foreign_data_wrappers.foreign_servers 2019-11-29 19:12:11,917: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.foreign_data_wrappers.foreign_servers.user_mappings 2019-11-29 19:12:11,971: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.catalog_objects 2019-11-29 19:12:11,975: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.collations 2019-11-29 19:12:11,978: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.domains 2019-11-29 19:12:11,981: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.foreign_tables 2019-11-29 19:12:11,985: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.fts_configurations 2019-11-29 19:12:11,988: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.fts_dictionaries 2019-11-29 19:12:11,992: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.fts_parsers 2019-11-29 19:12:11,995: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.fts_templates 2019-11-29 19:12:11,997: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.functions 2019-11-29 19:12:12,004: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.packages 2019-11-29 19:12:12,007: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.sequences 2019-11-29 19:12:12,010: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.synonyms 2019-11-29 19:12:12,013: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables 2019-11-29 19:12:12,028: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.types 2019-11-29 19:12:12,033: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.utils 2019-11-29 19:12:12,034: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.views 2019-11-29 19:12:12,054: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.catalog_objects.columns 2019-11-29 19:12:12,095: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.domains.domain_constraints 2019-11-29 19:12:12,352: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.packages.edbfuncs 2019-11-29 19:12:12,355: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.packages.edbvars 2019-11-29 19:12:12,437: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.base_partition_table 2019-11-29 19:12:12,437: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.columns 2019-11-29 19:12:12,442: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.compound_triggers 2019-11-29 19:12:12,445: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints 2019-11-29 19:12:12,447: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.indexes 2019-11-29 19:12:12,454: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.partitions 2019-11-29 19:12:12,454: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.rules 2019-11-29 19:12:12,456: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.triggers 2019-11-29 19:12:12,460: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.utils 2019-11-29 19:12:12,545: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints.check_constraint 2019-11-29 19:12:12,549: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints.exclusion_constraint 2019-11-29 19:12:12,555: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints.foreign_key 2019-11-29 19:12:12,560: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints.index_constraint 2019-11-29 19:12:12,565: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables.constraints.type 2019-11-29 19:12:12,727: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.views.children 2019-11-29 19:12:12,831: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.views.children 2019-11-29 19:12:12,935: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.catalog_objects 2019-11-29 19:12:12,935: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.collations 2019-11-29 19:12:12,935: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.domains 2019-11-29 19:12:12,936: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.foreign_tables 2019-11-29 19:12:12,936: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.fts_configurations 2019-11-29 19:12:12,936: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.fts_dictionaries 2019-11-29 19:12:12,936: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.fts_parsers 2019-11-29 19:12:12,937: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.fts_templates 2019-11-29 19:12:12,937: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.functions 2019-11-29 19:12:12,937: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.packages 2019-11-29 19:12:12,937: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.sequences 2019-11-29 19:12:12,937: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.synonyms 2019-11-29 19:12:12,938: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.tables 2019-11-29 19:12:12,938: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.types 2019-11-29 19:12:12,938: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.utils 2019-11-29 19:12:12,938: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.databases.schemas.views 2019-11-29 19:12:14,064: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.pgagent.schedules 2019-11-29 19:12:14,066: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.pgagent.steps 2019-11-29 19:12:14,069: INFO flask.app: Examining potential module: pgadmin.browser.server_groups.servers.pgagent.utils 2019-11-29 19:12:14,130: INFO flask.app: Examining potential module: pgadmin.dashboard 2019-11-29 19:12:14,132: INFO flask.app: Registering blueprint module: 2019-11-29 19:12:14,145: INFO flask.app: Examining potential module: pgadmin.help 2019-11-29 19:12:14,146: INFO flask.app: Registering blueprint module: 2019-11-29 19:12:14,147: INFO flask.app: Examining potential module: pgadmin.misc 2019-11-29 19:12:14,147: INFO flask.app: Registering blueprint module: 2019-11-29 19:12:14,148: INFO flask.app: Examining potential module: pgadmin.misc.bgprocess 2019-11-29 19:12:14,171: INFO flask.app: Examining potential module: pgadmin.misc.dependencies 2019-11-29 19:12:14,172: INFO flask.app: Examining potential module: pgadmin.misc.dependents 2019-11-29 19:12:14,173: INFO flask.app: Examining potential module: pgadmin.misc.file_manager 2019-11-29 19:12:14,173: INFO flask.app: Examining potential module: pgadmin.misc.sql 2019-11-29 19:12:14,174: INFO flask.app: Examining potential module: pgadmin.misc.statistics 2019-11-29 19:12:14,175: INFO flask.app: Examining potential module: pgadmin.misc.themes 2019-11-29 19:12:14,177: INFO flask.app: Examining potential module: pgadmin.misc.bgprocess.process_executor 2019-11-29 19:12:14,179: INFO flask.app: Examining potential module: pgadmin.misc.bgprocess.processes 2019-11-29 19:12:14,192: INFO flask.app: Examining potential module: pgadmin.model 2019-11-29 19:12:14,193: INFO flask.app: Examining potential module: pgadmin.preferences 2019-11-29 19:12:14,194: INFO flask.app: Registering blueprint module: 2019-11-29 19:12:14,197: INFO flask.app: Examining potential module: pgadmin.redirects 2019-11-29 19:12:14,198: INFO flask.app: Registering blueprint module: 2019-11-29 19:12:14,200: INFO flask.app: Examining potential module: pgadmin.settings 2019-11-29 19:12:14,200: INFO flask.app: Registering blueprint module: 2019-11-29 19:12:14,204: INFO flask.app: Examining potential module: pgadmin.setup 2019-11-29 19:12:14,204: INFO flask.app: Examining potential module: pgadmin.tools 2019-11-29 19:12:14,204: INFO flask.app: Registering blueprint module: 2019-11-29 19:12:14,204: INFO flask.app: Examining potential module: pgadmin.tools.backup 2019-11-29 19:12:14,211: INFO flask.app: Examining potential module: pgadmin.tools.datagrid 2019-11-29 19:12:14,213: INFO flask.app: Examining potential module: pgadmin.tools.debugger 2019-11-29 19:12:14,221: INFO flask.app: Examining potential module: pgadmin.tools.grant_wizard 2019-11-29 19:12:14,224: INFO flask.app: Examining potential module: pgadmin.tools.import_export 2019-11-29 19:12:14,225: INFO flask.app: Examining potential module: pgadmin.tools.maintenance 2019-11-29 19:12:14,227: INFO flask.app: Examining potential module: pgadmin.tools.restore 2019-11-29 19:12:14,229: INFO flask.app: Examining potential module: pgadmin.tools.sqleditor 2019-11-29 19:12:14,230: INFO flask.app: Examining potential module: pgadmin.tools.user_management 2019-11-29 19:12:14,244: INFO flask.app: Examining potential module: pgadmin.tools.debugger.utils 2019-11-29 19:12:14,275: INFO flask.app: Examining potential module: pgadmin.tools.sqleditor.command 2019-11-29 19:12:14,276: INFO flask.app: Examining potential module: pgadmin.tools.sqleditor.utils 2019-11-29 19:12:14,294: INFO flask.app: Examining potential module: pgadmin.utils 2019-11-29 19:12:14,294: DEBUG flask.app: Running under the desktop runtime, port: 50909 2019-11-29 19:12:14,294: DEBUG flask.app: Desktop security key: 36275028-51b2-4ccc-bc45-a4bb0e10dc95 2019-11-29 19:12:14,299: INFO werkzeug: * Running on http://127.0.0.1:50909/ (Press CTRL+C to quit) 2019-11-29 19:12:14,610: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:14] "GET /misc/ping?key=36275028-51b2-4ccc-bc45-a4bb0e10dc95 HTTP/1.1" 200 - 2019-11-29 19:12:15,380: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:15] "GET /?key=36275028-51b2-4ccc-bc45-a4bb0e10dc95 HTTP/1.1" 302 - 2019-11-29 19:12:15,966: DEBUG flask.app: Checking version data at: https://www.pgadmin.org/versions.json?version=4.15 2019-11-29 19:12:16,588: DEBUG flask.app: Version check HTTP response code: 200 2019-11-29 19:12:16,589: DEBUG flask.app: Response data: {'pgadmin4': {'download_url': 'https://www.pgadmin.org/download/', 'version_int': 41500, 'version': '4.15'}, 'edb-pgadmin4': {'download_url': 'https://www.enterprisedb.com/downloads/postgres-postgresql-downloads', 'version_int': 41300, 'version': '4.13'}} 2019-11-29 19:12:16,613: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:16] "GET /browser/ HTTP/1.1" 200 - 2019-11-29 19:12:17,087: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:17] "GET /static/js/generated/pgadmin.style.css?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:17,088: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:17] "GET /static/js/generated/style.css?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:17,088: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:17] "GET /static/js/generated/pgadmin.css?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:17,092: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:17] "GET /static/vendor/require/require.min.js?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:17,093: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:17] "GET /static/js/generated/vendor.main.js?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:17,114: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:17] "GET /static/js/generated/vendor.others.js?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:17,115: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:17] "GET /static/js/generated/pgadmin_commons.js?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:17,178: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:17] "GET /browser/browser.css?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:17,271: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:17] "GET /static/js/generated/fonts/Roboto-Regular.ttf HTTP/1.1" 200 - 2019-11-29 19:12:17,271: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:17] "GET /static/js/generated/fonts/fontawesome-webfont.woff2 HTTP/1.1" 200 - 2019-11-29 19:12:17,293: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:17] "GET /static/js/generated/app.bundle.js?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:17,294: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:17] "GET /static/js/generated/browser_nodes.js?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:17,295: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:17] "GET /static/js/generated/codemirror.js?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:17,315: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:17] "GET /favicon.ico?ver=41500 HTTP/1.1" 302 - 2019-11-29 19:12:17,344: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:17] "GET /browser/js/endpoints.js?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:17,352: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:17] "GET /browser/js/messages.js?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:17,358: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:17] "GET /browser/server/supported_servers.js?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:17,389: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:17] "GET /browser/js/utils.js?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:17,391: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:17] "GET /static/js/gettext.js?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:17,391: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:17] "GET /tools/translations.js?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:17,392: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:17] "GET /static/js/pgadmin.js?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:17,395: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:17] "GET /user_management/current_user.js?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:17,412: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:17] "GET /static/favicon.ico?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:17,525: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:17] "GET /static/css/webcabin.overrides.css?v=1575051137512 HTTP/1.1" 200 - 2019-11-29 19:12:17,612: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:17] "POST /browser/master_password HTTP/1.1" 200 - 2019-11-29 19:12:17,746: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:17] "GET /browser/nodes/ HTTP/1.1" 200 - 2019-11-29 19:12:17,775: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:17] "POST /settings/store HTTP/1.1" 200 - 2019-11-29 19:12:17,799: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:17] "GET /browser/server_group/static/img/server_group.svg?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:18,151: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:18] "GET /preferences/get_all HTTP/1.1" 200 - 2019-11-29 19:12:18,165: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:18] "GET /settings/get_tree_state/ HTTP/1.1" 200 - 2019-11-29 19:12:18,675: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:18] "GET /misc/bgprocess/?_=1575051137417 HTTP/1.1" 200 - 2019-11-29 19:12:24,932: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:24] "POST /browser/master_password HTTP/1.1" 200 - 2019-11-29 19:12:46,672: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:46] "GET /browser/server_group/children/1 HTTP/1.1" 200 - 2019-11-29 19:12:46,752: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:46] "GET /browser/server/static/img/serverbad.svg?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:46,753: INFO flask.app: Connection Request for server#4 2019-11-29 19:12:46,928: INFO flask.app: Connection Established for server: 4 - PostgreSQL 12 2019-11-29 19:12:46,936: SQL flask.app: Execute (dict) for server #4 - DB:postgres (Query-id: 7452429): 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 2019-11-29 19:12:46,940: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:46] "POST /browser/server/connect/1/4 HTTP/1.1" 200 - 2019-11-29 19:12:46,973: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:46] "GET /browser/server/static/img/pg.svg?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:47,027: SQL flask.app: Execute (scalar) for server #4 - DB:postgres (Query-id: 8162272): 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' ) ) 2019-11-29 19:12:47,035: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:47] "GET /browser/server/children/1/4 HTTP/1.1" 200 - 2019-11-29 19:12:47,091: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:47] "GET /browser/database/static/img/coll-database.svg?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:47,093: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:47] "GET /browser/role/static/img/coll-role.svg?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:47,139: SQL flask.app: Execute (dict) for server #4 - DB:postgres (Query-id: 7645288): 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 > 13317::OID ORDER BY datname; 2019-11-29 19:12:47,141: SQL flask.app: Execute (dict) for server #4 - DB:postgres (Query-id: 979393): 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 > 13317::OID ORDER BY datname; 2019-11-29 19:12:47,144: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:47] "GET /browser/database/nodes/1/4/ HTTP/1.1" 200 - 2019-11-29 19:12:47,144: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:47] "GET /browser/database/nodes/1/4/ HTTP/1.1" 200 - 2019-11-29 19:12:47,196: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:47] "GET /browser/database/static/img/databasebad.svg?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:47,197: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:47] "GET /browser/database/static/img/database.svg?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:48,178: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:48] "POST /settings/save_tree_state/ HTTP/1.1" 200 - 2019-11-29 19:12:51,235: SQL flask.app: Execute (dict) for server #4 - DB:postgres (Query-id: 9170092): 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 = 16713 2019-11-29 19:12:51,412: INFO flask.app: Connection Established for Database Id: 16713 2019-11-29 19:12:51,416: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:51] "POST /browser/database/connect/1/4/16713 HTTP/1.1" 200 - 2019-11-29 19:12:51,477: SQL flask.app: Execute (dict) for server #4 - DB:sib (Query-id: 1412474): SELECT DISTINCT dep.deptype, dep.classid, cl.relkind, ad.adbin, pg_get_expr(ad.adbin, ad.adrelid) as adsrc, CASE WHEN cl.relkind IS NOT NULL THEN cl.relkind || COALESCE(dep.objsubid::text, '') WHEN tg.oid IS NOT NULL THEN 'T'::text WHEN ty.oid IS NOT NULL THEN 'y'::text WHEN ns.oid IS NOT NULL THEN 'n'::text WHEN pr.oid IS NOT NULL AND prtyp.typname = 'trigger' THEN 't'::text WHEN pr.oid IS NOT NULL THEN 'P'::text WHEN la.oid IS NOT NULL THEN 'l'::text WHEN rw.oid IS NOT NULL THEN 'R'::text WHEN co.oid IS NOT NULL THEN 'C'::text || contype WHEN ad.oid IS NOT NULL THEN 'A'::text WHEN fs.oid IS NOT NULL THEN 'F'::text WHEN fdw.oid IS NOT NULL THEN 'f'::text ELSE '' END AS type, COALESCE(coc.relname, clrw.relname) AS ownertable, CASE WHEN cl.relname IS NOT NULL AND att.attname IS NOT NULL THEN cl.relname || COALESCE('.' || att.attname, '') ELSE COALESCE(cl.relname, co.conname, pr.proname, tg.tgname, ty.typname, la.lanname, rw.rulename, ns.nspname, fs.srvname, fdw.fdwname) END AS refname, COALESCE(nsc.nspname, nso.nspname, nsp.nspname, nst.nspname, nsrw.nspname) AS nspname, CASE WHEN inhits.inhparent IS NOT NULL THEN '1' ELSE '0' END AS is_inherits, CASE WHEN inhed.inhparent IS NOT NULL THEN '1' ELSE '0' END AS is_inherited FROM pg_depend dep LEFT JOIN pg_class cl ON dep.objid=cl.oid LEFT JOIN pg_attribute att ON dep.objid=att.attrelid AND dep.objsubid=att.attnum LEFT JOIN pg_namespace nsc ON cl.relnamespace=nsc.oid LEFT JOIN pg_proc pr ON dep.objid=pr.oid LEFT JOIN pg_namespace nsp ON pr.pronamespace=nsp.oid LEFT JOIN pg_trigger tg ON dep.objid=tg.oid LEFT JOIN pg_type ty ON dep.objid=ty.oid LEFT JOIN pg_namespace nst ON ty.typnamespace=nst.oid LEFT JOIN pg_constraint co ON dep.objid=co.oid LEFT JOIN pg_class coc ON co.conrelid=coc.oid LEFT JOIN pg_namespace nso ON co.connamespace=nso.oid LEFT JOIN pg_rewrite rw ON dep.objid=rw.oid LEFT JOIN pg_class clrw ON clrw.oid=rw.ev_class LEFT JOIN pg_namespace nsrw ON clrw.relnamespace=nsrw.oid LEFT JOIN pg_language la ON dep.objid=la.oid LEFT JOIN pg_namespace ns ON dep.objid=ns.oid LEFT JOIN pg_attrdef ad ON ad.oid=dep.objid LEFT JOIN pg_foreign_server fs ON fs.oid=dep.objid LEFT JOIN pg_foreign_data_wrapper fdw ON fdw.oid=dep.objid LEFT JOIN pg_type prtyp ON prtyp.oid = pr.prorettype LEFT JOIN pg_inherits inhits ON (inhits.inhrelid=dep.objid) LEFT JOIN pg_inherits inhed ON (inhed.inhparent=dep.objid) WHERE dep.refobjid=16713::oid AND classid IN ( SELECT oid FROM pg_class WHERE relname IN ('pg_class', 'pg_constraint', 'pg_conversion', 'pg_language', 'pg_proc', 'pg_rewrite', 'pg_namespace', 'pg_trigger', 'pg_type', 'pg_attrdef', 'pg_event_trigger', 'pg_foreign_server', 'pg_foreign_data_wrapper')) ORDER BY classid, cl.relkind 2019-11-29 19:12:51,488: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:51] "GET /browser/database/children/1/4/16713 HTTP/1.1" 200 - 2019-11-29 19:12:51,501: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:51] "GET /browser/database/dependent/1/4/16713 HTTP/1.1" 200 - 2019-11-29 19:12:51,532: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:51] "GET /browser/schema/static/img/coll-schema.svg?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:51,606: SQL flask.app: Execute (2darray) for server #4 - DB:sib (Query-id: 796999): SELECT nsp.oid, nsp.nspname as name, has_schema_privilege(nsp.oid, 'CREATE') as can_create, has_schema_privilege(nsp.oid, 'USAGE') as has_usage FROM pg_namespace nsp WHERE nspname NOT LIKE 'pg\_%' AND NOT ( (nsp.nspname = 'pg_catalog' AND EXISTS (SELECT 1 FROM pg_class WHERE relname = 'pg_class' AND relnamespace = nsp.oid LIMIT 1)) OR (nsp.nspname = 'pgagent' AND EXISTS (SELECT 1 FROM pg_class WHERE relname = 'pga_job' AND relnamespace = nsp.oid LIMIT 1)) OR (nsp.nspname = 'information_schema' AND EXISTS (SELECT 1 FROM pg_class WHERE relname = 'tables' AND relnamespace = nsp.oid LIMIT 1)) ) ORDER BY nspname; 2019-11-29 19:12:51,608: SQL flask.app: Execute (2darray) for server #4 - DB:sib (Query-id: 6791808): SELECT nsp.oid, nsp.nspname as name, has_schema_privilege(nsp.oid, 'CREATE') as can_create, has_schema_privilege(nsp.oid, 'USAGE') as has_usage FROM pg_namespace nsp WHERE nspname NOT LIKE 'pg\_%' AND NOT ( (nsp.nspname = 'pg_catalog' AND EXISTS (SELECT 1 FROM pg_class WHERE relname = 'pg_class' AND relnamespace = nsp.oid LIMIT 1)) OR (nsp.nspname = 'pgagent' AND EXISTS (SELECT 1 FROM pg_class WHERE relname = 'pga_job' AND relnamespace = nsp.oid LIMIT 1)) OR (nsp.nspname = 'information_schema' AND EXISTS (SELECT 1 FROM pg_class WHERE relname = 'tables' AND relnamespace = nsp.oid LIMIT 1)) ) ORDER BY nspname; 2019-11-29 19:12:51,611: SQL flask.app: Execute (2darray) for server #4 - DB:sib (Query-id: 5351986): SELECT nsp.oid, nsp.nspname as name, has_schema_privilege(nsp.oid, 'CREATE') as can_create, has_schema_privilege(nsp.oid, 'USAGE') as has_usage FROM pg_namespace nsp WHERE nspname NOT LIKE 'pg\_%' AND NOT ( (nsp.nspname = 'pg_catalog' AND EXISTS (SELECT 1 FROM pg_class WHERE relname = 'pg_class' AND relnamespace = nsp.oid LIMIT 1)) OR (nsp.nspname = 'pgagent' AND EXISTS (SELECT 1 FROM pg_class WHERE relname = 'pga_job' AND relnamespace = nsp.oid LIMIT 1)) OR (nsp.nspname = 'information_schema' AND EXISTS (SELECT 1 FROM pg_class WHERE relname = 'tables' AND relnamespace = nsp.oid LIMIT 1)) ) ORDER BY nspname; 2019-11-29 19:12:51,612: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:51] "GET /browser/schema/nodes/1/4/16713/ HTTP/1.1" 200 - 2019-11-29 19:12:51,613: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:51] "GET /browser/schema/nodes/1/4/16713/ HTTP/1.1" 200 - 2019-11-29 19:12:51,613: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:51] "GET /browser/schema/nodes/1/4/16713/ HTTP/1.1" 200 - 2019-11-29 19:12:51,662: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:51] "GET /browser/schema/static/img/schema.svg?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:51,684: SQL flask.app: Execute (dict) for server #4 - DB:sib (Query-id: 8311634): SELECT nsp.nspname as schema_name, (nsp.nspname = 'pg_catalog' AND EXISTS (SELECT 1 FROM pg_class WHERE relname = 'pg_class' AND relnamespace = nsp.oid LIMIT 1)) OR (nsp.nspname = 'pgagent' AND EXISTS (SELECT 1 FROM pg_class WHERE relname = 'pga_job' AND relnamespace = nsp.oid LIMIT 1)) OR (nsp.nspname = 'information_schema' AND EXISTS (SELECT 1 FROM pg_class WHERE relname = 'tables' AND relnamespace = nsp.oid LIMIT 1)) AS is_catalog, CASE WHEN nsp.nspname = ANY('{information_schema}') THEN false ELSE true END AS db_support FROM pg_catalog.pg_namespace nsp WHERE nsp.oid = 2200::OID; 2019-11-29 19:12:51,710: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:51] "GET /browser/schema/children/1/4/16713/2200 HTTP/1.1" 200 - 2019-11-29 19:12:51,770: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:51] "GET /browser/function/static/img/coll-function.svg?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:51,770: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:51] "GET /browser/mview/static/img/coll-mview.svg?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:51,775: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:51] "GET /browser/domain/static/img/coll-domain.svg?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:51,776: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:51] "GET /browser/procedure/static/img/coll-procedure.svg?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:51,781: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:51] "GET /browser/sequence/static/img/coll-sequence.svg?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:51,792: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:51] "GET /browser/trigger_function/static/img/coll-trigger_function.svg?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:51,792: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:51] "GET /browser/table/static/img/coll-table.svg?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:51,794: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:51] "GET /browser/view/static/img/coll-view.svg?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:51,794: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:51] "GET /browser/type/static/img/coll-type.svg?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:12:56,060: SQL flask.app: Execute (2darray) for server #4 - DB:sib (Query-id: 952351): SELECT rel.oid, rel.relname AS name, (SELECT count(*) FROM pg_trigger WHERE tgrelid=rel.oid AND tgisinternal = FALSE) AS triggercount, (SELECT count(*) FROM pg_trigger WHERE tgrelid=rel.oid AND tgisinternal = FALSE AND tgenabled = 'O') AS has_enable_triggers, (CASE WHEN rel.relkind = 'p' THEN true ELSE false END) AS is_partitioned, (SELECT count(1) FROM pg_inherits WHERE inhrelid=rel.oid LIMIT 1) as is_inherits, (SELECT count(1) FROM pg_inherits WHERE inhparent=rel.oid LIMIT 1) as is_inherited FROM pg_class rel WHERE rel.relkind IN ('r','s','t','p') AND rel.relnamespace = 2200::oid AND NOT rel.relispartition ORDER BY rel.relname; 2019-11-29 19:12:56,063: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:56] "GET /browser/table/nodes/1/4/16713/2200/ HTTP/1.1" 200 - 2019-11-29 19:12:56,115: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:12:56] "GET /browser/table/static/img/table.svg?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:13:01,099: SQL flask.app: Execute (dict) for server #4 - DB:sib (Query-id: 6479556): SELECT DISTINCT dep.deptype, dep.classid, cl.relkind, ad.adbin, pg_get_expr(ad.adbin, ad.adrelid) as adsrc, CASE WHEN cl.relkind IS NOT NULL THEN cl.relkind || COALESCE(dep.objsubid::text, '') WHEN tg.oid IS NOT NULL THEN 'T'::text WHEN ty.oid IS NOT NULL THEN 'y'::text WHEN ns.oid IS NOT NULL THEN 'n'::text WHEN pr.oid IS NOT NULL AND prtyp.typname = 'trigger' THEN 't'::text WHEN pr.oid IS NOT NULL THEN 'P'::text WHEN la.oid IS NOT NULL THEN 'l'::text WHEN rw.oid IS NOT NULL THEN 'R'::text WHEN co.oid IS NOT NULL THEN 'C'::text || contype WHEN ad.oid IS NOT NULL THEN 'A'::text WHEN fs.oid IS NOT NULL THEN 'F'::text WHEN fdw.oid IS NOT NULL THEN 'f'::text ELSE '' END AS type, COALESCE(coc.relname, clrw.relname) AS ownertable, CASE WHEN cl.relname IS NOT NULL AND att.attname IS NOT NULL THEN cl.relname || COALESCE('.' || att.attname, '') ELSE COALESCE(cl.relname, co.conname, pr.proname, tg.tgname, ty.typname, la.lanname, rw.rulename, ns.nspname, fs.srvname, fdw.fdwname) END AS refname, COALESCE(nsc.nspname, nso.nspname, nsp.nspname, nst.nspname, nsrw.nspname) AS nspname, CASE WHEN inhits.inhparent IS NOT NULL THEN '1' ELSE '0' END AS is_inherits, CASE WHEN inhed.inhparent IS NOT NULL THEN '1' ELSE '0' END AS is_inherited FROM pg_depend dep LEFT JOIN pg_class cl ON dep.objid=cl.oid LEFT JOIN pg_attribute att ON dep.objid=att.attrelid AND dep.objsubid=att.attnum LEFT JOIN pg_namespace nsc ON cl.relnamespace=nsc.oid LEFT JOIN pg_proc pr ON dep.objid=pr.oid LEFT JOIN pg_namespace nsp ON pr.pronamespace=nsp.oid LEFT JOIN pg_trigger tg ON dep.objid=tg.oid LEFT JOIN pg_type ty ON dep.objid=ty.oid LEFT JOIN pg_namespace nst ON ty.typnamespace=nst.oid LEFT JOIN pg_constraint co ON dep.objid=co.oid LEFT JOIN pg_class coc ON co.conrelid=coc.oid LEFT JOIN pg_namespace nso ON co.connamespace=nso.oid LEFT JOIN pg_rewrite rw ON dep.objid=rw.oid LEFT JOIN pg_class clrw ON clrw.oid=rw.ev_class LEFT JOIN pg_namespace nsrw ON clrw.relnamespace=nsrw.oid LEFT JOIN pg_language la ON dep.objid=la.oid LEFT JOIN pg_namespace ns ON dep.objid=ns.oid LEFT JOIN pg_attrdef ad ON ad.oid=dep.objid LEFT JOIN pg_foreign_server fs ON fs.oid=dep.objid LEFT JOIN pg_foreign_data_wrapper fdw ON fdw.oid=dep.objid LEFT JOIN pg_type prtyp ON prtyp.oid = pr.prorettype LEFT JOIN pg_inherits inhits ON (inhits.inhrelid=dep.objid) LEFT JOIN pg_inherits inhed ON (inhed.inhparent=dep.objid) WHERE dep.refobjid=16716::oid AND classid IN ( SELECT oid FROM pg_class WHERE relname IN ('pg_class', 'pg_constraint', 'pg_conversion', 'pg_language', 'pg_proc', 'pg_rewrite', 'pg_namespace', 'pg_trigger', 'pg_type', 'pg_attrdef', 'pg_event_trigger', 'pg_foreign_server', 'pg_foreign_data_wrapper')) ORDER BY classid, cl.relkind 2019-11-29 19:13:01,100: SQL flask.app: Execute (dict) for server #4 - DB:sib (Query-id: 8677643): SELECT DISTINCT dep.deptype, dep.refclassid, cl.relkind, ad.adbin, pg_get_expr(ad.adbin, ad.adrelid) as adsrc, CASE WHEN cl.relkind IS NOT NULL THEN cl.relkind || COALESCE(dep.refobjsubid::character varying, '') WHEN tg.oid IS NOT NULL THEN 'T'::text WHEN ty.oid IS NOT NULL AND ty.typbasetype = 0 THEN 'y'::text WHEN ty.oid IS NOT NULL AND ty.typbasetype != 0 THEN 'd'::text WHEN ns.oid IS NOT NULL THEN 'n'::text WHEN pr.oid IS NOT NULL AND prtyp.typname = 'trigger' THEN 't'::text WHEN pr.oid IS NOT NULL THEN 'P'::text WHEN la.oid IS NOT NULL THEN 'l'::text WHEN rw.oid IS NOT NULL THEN 'R'::text WHEN co.oid IS NOT NULL THEN 'C'::text || contype WHEN ad.oid IS NOT NULL THEN 'A'::text WHEN fs.oid IS NOT NULL THEN 'F'::text WHEN fdw.oid IS NOT NULL THEN 'f'::text ELSE '' END AS type, COALESCE(coc.relname, clrw.relname) AS ownertable, CASE WHEN cl.relname IS NOT NULL OR att.attname IS NOT NULL THEN cl.relname || COALESCE('.' || att.attname, '') ELSE COALESCE(cl.relname, co.conname, pr.proname, tg.tgname, ty.typname, la.lanname, rw.rulename, ns.nspname, fs.srvname, fdw.fdwname) END AS refname, COALESCE(nsc.nspname, nso.nspname, nsp.nspname, nst.nspname, nsrw.nspname) AS nspname, CASE WHEN inhits.inhparent IS NOT NULL THEN '1' ELSE '0' END AS is_inherits, CASE WHEN inhed.inhparent IS NOT NULL THEN '1' ELSE '0' END AS is_inherited FROM pg_depend dep LEFT JOIN pg_class cl ON dep.refobjid=cl.oid LEFT JOIN pg_attribute att ON dep.refobjid=att.attrelid AND dep.refobjsubid=att.attnum LEFT JOIN pg_namespace nsc ON cl.relnamespace=nsc.oid LEFT JOIN pg_proc pr ON dep.refobjid=pr.oid LEFT JOIN pg_namespace nsp ON pr.pronamespace=nsp.oid LEFT JOIN pg_trigger tg ON dep.refobjid=tg.oid LEFT JOIN pg_type ty ON dep.refobjid=ty.oid LEFT JOIN pg_namespace nst ON ty.typnamespace=nst.oid LEFT JOIN pg_constraint co ON dep.refobjid=co.oid LEFT JOIN pg_class coc ON co.conrelid=coc.oid LEFT JOIN pg_namespace nso ON co.connamespace=nso.oid LEFT JOIN pg_rewrite rw ON dep.refobjid=rw.oid LEFT JOIN pg_class clrw ON clrw.oid=rw.ev_class LEFT JOIN pg_namespace nsrw ON clrw.relnamespace=nsrw.oid LEFT JOIN pg_language la ON dep.refobjid=la.oid LEFT JOIN pg_namespace ns ON dep.refobjid=ns.oid LEFT JOIN pg_attrdef ad ON ad.adrelid=att.attrelid AND ad.adnum=att.attnum LEFT JOIN pg_foreign_server fs ON fs.oid=dep.refobjid LEFT JOIN pg_foreign_data_wrapper fdw ON fdw.oid=dep.refobjid LEFT JOIN pg_type prtyp ON prtyp.oid = pr.prorettype LEFT JOIN pg_inherits inhits ON (inhits.inhrelid=dep.refobjid) LEFT JOIN pg_inherits inhed ON (inhed.inhparent=dep.refobjid) WHERE dep.objid=16716::oid AND refclassid IN ( SELECT oid FROM pg_class WHERE relname IN ('pg_class', 'pg_constraint', 'pg_conversion', 'pg_language', 'pg_proc', 'pg_rewrite', 'pg_namespace', 'pg_trigger', 'pg_type', 'pg_attrdef', 'pg_event_trigger', 'pg_foreign_server', 'pg_foreign_data_wrapper')) ORDER BY refclassid, cl.relkind 2019-11-29 19:13:01,163: SQL flask.app: Execute (dict) for server #4 - DB:sib (Query-id: 1585228): SELECT rolname AS refname, refclassid, deptype FROM pg_shdepend dep LEFT JOIN pg_roles r ON refclassid=1260 AND refobjid=r.oid WHERE dep.objid=16716::oid ORDER BY 1 2019-11-29 19:13:01,165: SQL flask.app: Execute (dict) for server #4 - DB:sib (Query-id: 7068112): SELECT ref.relname AS refname, d2.refclassid, dep.deptype AS deptype FROM pg_depend dep LEFT JOIN pg_depend d2 ON dep.objid=d2.objid AND dep.refobjid != d2.refobjid LEFT JOIN pg_class ref ON ref.oid=d2.refobjid LEFT JOIN pg_attribute att ON d2.refclassid=att.attrelid AND d2.refobjsubid=att.attnum WHERE dep.refobjid=16716::OID AND dep.classid=(SELECT oid FROM pg_class WHERE relname='pg_attrdef') AND dep.refobjid NOT IN (SELECT d3.refobjid FROM pg_depend d3 WHERE d3.objid=d2.refobjid) 2019-11-29 19:13:01,167: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:13:01] "GET /browser/table/dependent/1/4/16713/2200/16716 HTTP/1.1" 200 - 2019-11-29 19:13:01,167: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:13:01] "GET /browser/table/dependency/1/4/16713/2200/16716 HTTP/1.1" 200 - 2019-11-29 19:13:01,205: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:13:01] "GET /browser/primary_key/static/img/primary_key.svg?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:13:01,205: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:13:01] "GET /browser/index/static/img/index.svg?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:13:01,207: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:13:01] "GET /browser/foreign_key/static/img/foreign_key.svg?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:13:01,454: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:13:01] "POST /settings/store HTTP/1.1" 200 - 2019-11-29 19:13:06,996: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:13:06] "GET /datagrid/filter HTTP/1.1" 200 - 2019-11-29 19:13:07,059: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:13:07] "GET /static/js/generated/fonts/SourceCodePro-Regular.ttf HTTP/1.1" 200 - 2019-11-29 19:13:18,178: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:13:18] "POST /settings/save_tree_state/ HTTP/1.1" 200 - 2019-11-29 19:14:08,759: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:08] "GET /browser/table/children/1/4/16713/2200/16716 HTTP/1.1" 200 - 2019-11-29 19:14:08,857: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:08] "GET /browser/column/static/img/coll-column.svg?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:14:08,858: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:08] "GET /browser/rule/static/img/coll-rule.svg?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:14:08,858: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:08] "GET /browser/index/static/img/coll-index.svg?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:14:08,859: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:08] "GET /browser/constraints/static/img/coll-constraints.svg?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:14:08,860: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:08] "GET /browser/trigger/static/img/coll-trigger.svg?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:14:10,304: SQL flask.app: Execute (2darray) for server #4 - DB:sib (Query-id: 2330031): SELECT nsp.nspname AS schema ,rel.relname AS table FROM pg_class rel JOIN pg_namespace nsp ON rel.relnamespace = nsp.oid::oid WHERE rel.oid = 16716::oid 2019-11-29 19:14:10,326: SQL flask.app: Execute (2darray) for server #4 - DB:sib (Query-id: 8022610): SELECT att.attname as name, att.attnum as OID, format_type(ty.oid,NULL) AS datatype, att.attnotnull as not_null, att.atthasdef as has_default_val FROM pg_attribute att JOIN pg_type ty ON ty.oid=atttypid JOIN pg_namespace tn ON tn.oid=ty.typnamespace JOIN pg_class cl ON cl.oid=att.attrelid JOIN pg_namespace na ON na.oid=cl.relnamespace LEFT OUTER JOIN pg_type et ON et.oid=ty.typelem LEFT OUTER JOIN pg_attrdef def ON adrelid=att.attrelid AND adnum=att.attnum LEFT OUTER JOIN (pg_depend JOIN pg_class cs ON classid='pg_class'::regclass AND objid=cs.oid AND cs.relkind='S') ON refobjid=att.attrelid AND refobjsubid=att.attnum LEFT OUTER JOIN pg_namespace ns ON ns.oid=cs.relnamespace LEFT OUTER JOIN pg_index pi ON pi.indrelid=att.attrelid AND indisprimary WHERE att.attrelid = 16716::oid AND att.attnum > 0 AND att.attisdropped IS FALSE ORDER BY att.attnum 2019-11-29 19:14:10,330: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:10] "GET /browser/column/nodes/1/4/16713/2200/16716/ HTTP/1.1" 200 - 2019-11-29 19:14:10,368: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:10] "GET /browser/column/static/img/column.svg?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:14:18,183: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:18] "POST /settings/save_tree_state/ HTTP/1.1" 200 - 2019-11-29 19:14:25,439: SQL flask.app: Execute (dict) for server #4 - DB:sib (Query-id: 5102303): SELECT n.nspname, r.relname FROM pg_class r LEFT JOIN pg_namespace n ON (r.relnamespace = n.oid) WHERE r.oid = 16716; 2019-11-29 19:14:25,470: SQL flask.app: Execute (scalar) for server #4 - DB:sib (Query-id: 3156124): EXPLAIN SELECT * FROM public.rubrik WHERE rubid like 'B__' 2019-11-29 19:14:25,476: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:25] "POST /datagrid/filter/validate/4/16713/16716 HTTP/1.1" 200 - 2019-11-29 19:14:25,705: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:25] "POST /datagrid/panel/5632957?is_query_tool=false&cmd_type=4&obj_type=table&obj_id=16716&sgid=1&sid=4&did=16713&server_type=pg HTTP/1.1" 200 - 2019-11-29 19:14:25,842: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:25] "POST /settings/store HTTP/1.1" 200 - 2019-11-29 19:14:26,001: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:26] "GET /static/js/generated/slickgrid.js?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:14:26,161: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:26] "GET /static/js/generated/sqleditor.js?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:14:26,205: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:26] "GET /browser/js/endpoints.js?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:14:26,208: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:26] "GET /user_management/current_user.js?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:14:26,210: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:26] "GET /tools/translations.js?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:14:26,212: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:26] "GET /browser/js/messages.js?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:14:26,217: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:26] "GET /browser/server/supported_servers.js?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:14:26,234: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:26] "GET /browser/js/utils.js?ver=41500 HTTP/1.1" 200 - 2019-11-29 19:14:26,416: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:26] "GET /static/css/webcabin.overrides.css?v=1575051266408 HTTP/1.1" 200 - 2019-11-29 19:14:26,670: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:26] "POST /settings/store HTTP/1.1" 200 - 2019-11-29 19:14:26,677: SQL flask.app: Execute (dict) for server #4 - DB:sib (Query-id: 4462827): SELECT n.nspname, r.relname FROM pg_class r LEFT JOIN pg_namespace n ON (r.relnamespace = n.oid) WHERE r.oid = 16716; 2019-11-29 19:14:26,678: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:26] "POST /datagrid/initialize/datagrid/5632957/4/table/1/4/16713/16716 HTTP/1.1" 200 - 2019-11-29 19:14:26,699: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:26] "GET /sqleditor/query_history/5632957 HTTP/1.1" 200 - 2019-11-29 19:14:26,712: SQL flask.app: Execute (dict) for server #4 - DB:sib (Query-id: 9675738): SELECT at.attname, at.attnum, ty.typname FROM pg_attribute at LEFT JOIN pg_type ty ON (ty.oid = at.atttypid) WHERE attrelid=16716::oid AND attnum = ANY ( (SELECT con.conkey FROM pg_class rel LEFT OUTER JOIN pg_constraint con ON con.conrelid=rel.oid AND con.contype='p' WHERE rel.relkind IN ('r','s','t', 'p') AND rel.oid = 16716::oid)::oid[]) 2019-11-29 19:14:26,748: SQL flask.app: Execute (dict) for server #4 - DB:sib (Query-id: 6335807): SELECT at.attname, at.attnum, ty.typname FROM pg_attribute at LEFT JOIN pg_type ty ON (ty.oid = at.atttypid) WHERE attrelid=16716::oid AND attnum = ANY ( (SELECT con.conkey FROM pg_class rel LEFT OUTER JOIN pg_constraint con ON con.conrelid=rel.oid AND con.contype='p' WHERE rel.relkind IN ('r','s','t', 'p') AND rel.oid = 16716::oid)::oid[]) 2019-11-29 19:14:26,751: SQL flask.app: Execute (async) for server #4 - CONN:3332235 (Query-id: 4656000): SELECT * FROM public.rubrik WHERE rubid like 'B__' 2019-11-29 19:14:26,754: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:26] "GET /sqleditor/view_data/start/5632957 HTTP/1.1" 200 - 2019-11-29 19:14:26,783: SQL flask.app: Polling result for (Query-id: 4656000) 2019-11-29 19:14:26,785: SQL flask.app: Execute (2darray) for server #4 - CONN:3332235 (Query-id: 8204264): SELECT att.attname as name, att.attnum as OID, format_type(ty.oid,NULL) AS datatype, att.attnotnull as not_null, att.atthasdef as has_default_val FROM pg_attribute att JOIN pg_type ty ON ty.oid=atttypid JOIN pg_namespace tn ON tn.oid=ty.typnamespace JOIN pg_class cl ON cl.oid=att.attrelid JOIN pg_namespace na ON na.oid=cl.relnamespace LEFT OUTER JOIN pg_type et ON et.oid=ty.typelem LEFT OUTER JOIN pg_attrdef def ON adrelid=att.attrelid AND adnum=att.attnum LEFT OUTER JOIN (pg_depend JOIN pg_class cs ON classid='pg_class'::regclass AND objid=cs.oid AND cs.relkind='S') ON refobjid=att.attrelid AND refobjsubid=att.attnum LEFT OUTER JOIN pg_namespace ns ON ns.oid=cs.relnamespace LEFT OUTER JOIN pg_index pi ON pi.indrelid=att.attrelid AND indisprimary WHERE att.attrelid = 16716::oid AND att.attnum > 0 AND att.attisdropped IS FALSE ORDER BY att.attnum 2019-11-29 19:14:26,795: SQL flask.app: Execute (dict) for server #4 - DB:sib (Query-id: 2403380): SELECT oid, format_type(oid, NULL) AS typname FROM pg_type WHERE oid IN %s ORDER BY oid; 2019-11-29 19:14:26,797: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:26] "GET /sqleditor/poll/5632957 HTTP/1.1" 200 - 2019-11-29 19:14:26,838: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:26] "POST /sqleditor/query_history/5632957 HTTP/1.1" 200 - 2019-11-29 19:14:26,859: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:26] "GET /static/img/select-all-icon.png HTTP/1.1" 200 - 2019-11-29 19:14:27,023: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:27] "POST /settings/store HTTP/1.1" 200 - 2019-11-29 19:14:30,495: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:30] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:14:32,495: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:32] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:14:34,496: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:34] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:14:36,498: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:36] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:14:38,497: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:38] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:14:40,498: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:40] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:14:42,497: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:42] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:14:44,498: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:44] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:14:46,497: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:46] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:14:48,500: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:48] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:14:50,499: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:50] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:14:52,500: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:52] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:14:54,502: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:54] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:14:56,502: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:56] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:14:58,503: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:14:58] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:15:00,505: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:15:00] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:15:02,505: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:15:02] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:15:04,505: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:15:04] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:15:06,506: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:15:06] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:15:08,506: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:15:08] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:15:10,508: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:15:10] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:15:12,509: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:15:12] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:15:14,510: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:15:14] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:15:16,508: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:15:16] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:15:18,448: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:15:18] "GET /browser/table/children/1/4/16713/2200/16655 HTTP/1.1" 200 - 2019-11-29 19:15:18,510: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:15:18] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:15:20,511: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:15:20] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:15:22,510: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:15:22] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:15:24,512: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:15:24] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:15:26,512: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:15:26] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:15:30,515: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:15:30] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:15:32,514: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:15:32] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:15:34,513: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:15:34] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:15:38,513: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:15:38] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:15:40,514: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:15:40] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:15:42,513: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:15:42] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:15:44,516: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:15:44] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:15:46,515: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:15:46] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:15:48,185: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:15:48] "POST /settings/save_tree_state/ HTTP/1.1" 200 - 2019-11-29 19:26:15,780: SQL flask.app: Execute (dict) for server #4 - DB:sib (Query-id: 5990344): SELECT DISTINCT dep.deptype, dep.refclassid, cl.relkind, ad.adbin, pg_get_expr(ad.adbin, ad.adrelid) as adsrc, CASE WHEN cl.relkind IS NOT NULL THEN cl.relkind || COALESCE(dep.refobjsubid::character varying, '') WHEN tg.oid IS NOT NULL THEN 'T'::text WHEN ty.oid IS NOT NULL AND ty.typbasetype = 0 THEN 'y'::text WHEN ty.oid IS NOT NULL AND ty.typbasetype != 0 THEN 'd'::text WHEN ns.oid IS NOT NULL THEN 'n'::text WHEN pr.oid IS NOT NULL AND prtyp.typname = 'trigger' THEN 't'::text WHEN pr.oid IS NOT NULL THEN 'P'::text WHEN la.oid IS NOT NULL THEN 'l'::text WHEN rw.oid IS NOT NULL THEN 'R'::text WHEN co.oid IS NOT NULL THEN 'C'::text || contype WHEN ad.oid IS NOT NULL THEN 'A'::text WHEN fs.oid IS NOT NULL THEN 'F'::text WHEN fdw.oid IS NOT NULL THEN 'f'::text ELSE '' END AS type, COALESCE(coc.relname, clrw.relname) AS ownertable, CASE WHEN cl.relname IS NOT NULL OR att.attname IS NOT NULL THEN cl.relname || COALESCE('.' || att.attname, '') ELSE COALESCE(cl.relname, co.conname, pr.proname, tg.tgname, ty.typname, la.lanname, rw.rulename, ns.nspname, fs.srvname, fdw.fdwname) END AS refname, COALESCE(nsc.nspname, nso.nspname, nsp.nspname, nst.nspname, nsrw.nspname) AS nspname, CASE WHEN inhits.inhparent IS NOT NULL THEN '1' ELSE '0' END AS is_inherits, CASE WHEN inhed.inhparent IS NOT NULL THEN '1' ELSE '0' END AS is_inherited FROM pg_depend dep LEFT JOIN pg_class cl ON dep.refobjid=cl.oid LEFT JOIN pg_attribute att ON dep.refobjid=att.attrelid AND dep.refobjsubid=att.attnum LEFT JOIN pg_namespace nsc ON cl.relnamespace=nsc.oid LEFT JOIN pg_proc pr ON dep.refobjid=pr.oid LEFT JOIN pg_namespace nsp ON pr.pronamespace=nsp.oid LEFT JOIN pg_trigger tg ON dep.refobjid=tg.oid LEFT JOIN pg_type ty ON dep.refobjid=ty.oid LEFT JOIN pg_namespace nst ON ty.typnamespace=nst.oid LEFT JOIN pg_constraint co ON dep.refobjid=co.oid LEFT JOIN pg_class coc ON co.conrelid=coc.oid LEFT JOIN pg_namespace nso ON co.connamespace=nso.oid LEFT JOIN pg_rewrite rw ON dep.refobjid=rw.oid LEFT JOIN pg_class clrw ON clrw.oid=rw.ev_class LEFT JOIN pg_namespace nsrw ON clrw.relnamespace=nsrw.oid LEFT JOIN pg_language la ON dep.refobjid=la.oid LEFT JOIN pg_namespace ns ON dep.refobjid=ns.oid LEFT JOIN pg_attrdef ad ON ad.adrelid=att.attrelid AND ad.adnum=att.attnum LEFT JOIN pg_foreign_server fs ON fs.oid=dep.refobjid LEFT JOIN pg_foreign_data_wrapper fdw ON fdw.oid=dep.refobjid LEFT JOIN pg_type prtyp ON prtyp.oid = pr.prorettype LEFT JOIN pg_inherits inhits ON (inhits.inhrelid=dep.refobjid) LEFT JOIN pg_inherits inhed ON (inhed.inhparent=dep.refobjid) WHERE dep.objid=16713::oid AND refclassid IN ( SELECT oid FROM pg_class WHERE relname IN ('pg_class', 'pg_constraint', 'pg_conversion', 'pg_language', 'pg_proc', 'pg_rewrite', 'pg_namespace', 'pg_trigger', 'pg_type', 'pg_attrdef', 'pg_event_trigger', 'pg_foreign_server', 'pg_foreign_data_wrapper')) ORDER BY refclassid, cl.relkind 2019-11-29 19:26:15,789: SQL flask.app: Execute (dict) for server #4 - DB:sib (Query-id: 8733117): SELECT DISTINCT dep.deptype, dep.classid, cl.relkind, ad.adbin, pg_get_expr(ad.adbin, ad.adrelid) as adsrc, CASE WHEN cl.relkind IS NOT NULL THEN cl.relkind || COALESCE(dep.objsubid::text, '') WHEN tg.oid IS NOT NULL THEN 'T'::text WHEN ty.oid IS NOT NULL THEN 'y'::text WHEN ns.oid IS NOT NULL THEN 'n'::text WHEN pr.oid IS NOT NULL AND prtyp.typname = 'trigger' THEN 't'::text WHEN pr.oid IS NOT NULL THEN 'P'::text WHEN la.oid IS NOT NULL THEN 'l'::text WHEN rw.oid IS NOT NULL THEN 'R'::text WHEN co.oid IS NOT NULL THEN 'C'::text || contype WHEN ad.oid IS NOT NULL THEN 'A'::text WHEN fs.oid IS NOT NULL THEN 'F'::text WHEN fdw.oid IS NOT NULL THEN 'f'::text ELSE '' END AS type, COALESCE(coc.relname, clrw.relname) AS ownertable, CASE WHEN cl.relname IS NOT NULL AND att.attname IS NOT NULL THEN cl.relname || COALESCE('.' || att.attname, '') ELSE COALESCE(cl.relname, co.conname, pr.proname, tg.tgname, ty.typname, la.lanname, rw.rulename, ns.nspname, fs.srvname, fdw.fdwname) END AS refname, COALESCE(nsc.nspname, nso.nspname, nsp.nspname, nst.nspname, nsrw.nspname) AS nspname, CASE WHEN inhits.inhparent IS NOT NULL THEN '1' ELSE '0' END AS is_inherits, CASE WHEN inhed.inhparent IS NOT NULL THEN '1' ELSE '0' END AS is_inherited FROM pg_depend dep LEFT JOIN pg_class cl ON dep.objid=cl.oid LEFT JOIN pg_attribute att ON dep.objid=att.attrelid AND dep.objsubid=att.attnum LEFT JOIN pg_namespace nsc ON cl.relnamespace=nsc.oid LEFT JOIN pg_proc pr ON dep.objid=pr.oid LEFT JOIN pg_namespace nsp ON pr.pronamespace=nsp.oid LEFT JOIN pg_trigger tg ON dep.objid=tg.oid LEFT JOIN pg_type ty ON dep.objid=ty.oid LEFT JOIN pg_namespace nst ON ty.typnamespace=nst.oid LEFT JOIN pg_constraint co ON dep.objid=co.oid LEFT JOIN pg_class coc ON co.conrelid=coc.oid LEFT JOIN pg_namespace nso ON co.connamespace=nso.oid LEFT JOIN pg_rewrite rw ON dep.objid=rw.oid LEFT JOIN pg_class clrw ON clrw.oid=rw.ev_class LEFT JOIN pg_namespace nsrw ON clrw.relnamespace=nsrw.oid LEFT JOIN pg_language la ON dep.objid=la.oid LEFT JOIN pg_namespace ns ON dep.objid=ns.oid LEFT JOIN pg_attrdef ad ON ad.oid=dep.objid LEFT JOIN pg_foreign_server fs ON fs.oid=dep.objid LEFT JOIN pg_foreign_data_wrapper fdw ON fdw.oid=dep.objid LEFT JOIN pg_type prtyp ON prtyp.oid = pr.prorettype LEFT JOIN pg_inherits inhits ON (inhits.inhrelid=dep.objid) LEFT JOIN pg_inherits inhed ON (inhed.inhparent=dep.objid) WHERE dep.refobjid=16713::oid AND classid IN ( SELECT oid FROM pg_class WHERE relname IN ('pg_class', 'pg_constraint', 'pg_conversion', 'pg_language', 'pg_proc', 'pg_rewrite', 'pg_namespace', 'pg_trigger', 'pg_type', 'pg_attrdef', 'pg_event_trigger', 'pg_foreign_server', 'pg_foreign_data_wrapper')) ORDER BY classid, cl.relkind 2019-11-29 19:26:15,803: SQL flask.app: Execute (dict) for server #4 - DB:sib (Query-id: 565718): SELECT rolname AS refname, refclassid, deptype FROM pg_shdepend dep LEFT JOIN pg_roles r ON refclassid=1260 AND refobjid=r.oid WHERE dep.objid=16713::oid ORDER BY 1 2019-11-29 19:26:15,804: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:26:15] "GET /browser/database/dependent/1/4/16713 HTTP/1.1" 200 - 2019-11-29 19:26:15,804: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:26:15] "GET /browser/database/dependency/1/4/16713 HTTP/1.1" 200 - 2019-11-29 19:27:02,277: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:27:02] "DELETE /datagrid/close/6078722 HTTP/1.1" 200 - 2019-11-29 19:27:29,037: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:27:29] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:27:29,051: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:27:29] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:27:29,122: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:27:29] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:27:29,132: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:27:29] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:27:29,146: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:27:29] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:27:29,152: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:27:29] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:27:29,156: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:27:29] "POST /misc/cleanup HTTP/1.1" 200 - 2019-11-29 19:27:29,156: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:27:29] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:27:29,164: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:27:29] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:27:29,166: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:27:29] "POST /misc/cleanup HTTP/1.1" 200 - 2019-11-29 19:27:29,166: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:27:29] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:27:29,166: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:27:29] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:27:29,167: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:27:29] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:27:29,172: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:27:29] "POST /settings/save_tree_state/ HTTP/1.1" 200 - 2019-11-29 19:27:29,174: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:27:29] "POST /settings/save_tree_state/ HTTP/1.1" 200 - 2019-11-29 19:27:29,178: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:27:29] "GET /sqleditor/status/5632957 HTTP/1.1" 200 - 2019-11-29 19:27:40,154: INFO werkzeug: 127.0.0.1 - - [29/Nov/2019 19:27:40] "GET /misc/shutdown?key=36275028-51b2-4ccc-bc45-a4bb0e10dc95 HTTP/1.1" 200 -