Am 28.11.2019 um 09:33 schrieb Akshay Joshi:
Hi Sibylle

Can you please provide the pgAdmin4 backend logs
https://www.pgadmin.org/faq/#8 and browser logs if possible. Is there
any exact reproduction steps?

Here is a pgAdmin4 log, I hope it's ok to send it as attachment. I can't
find information about getting a Firefox log, sorry - I'm not even sure
Firefox lets me do that. I don't really think that's important, as
pgAdmin behaves the same with Edge as with Firefox.

There don't seem to be exact reproduction steps. Steps this time, after
opening pgAdmin4 and entering the master password:

- connect to database "sib"

- right click on table "rubrik", choose "View / Edit data", "Filtered
data", enter filter expression "rubid like 'B__'", click "Ok". This
works as expected. I could expand the "Columns" node for the table,
while the filter dialog was open, no problem. The table is very small,
two columns, three records fullfill the filter criterion.

- open the filter dialog for table "ding", try again to expand its
"Columns" node. This time the rotating circle appears and the node
doesn't open.

- After about 10 minutes I try to open the Query Tool for the database,
but that panel tab only shows another rotating circle. I can close this
panel tab. Now I close the browser and stop the pgAdmin server.

As a matter of fact I could reproduce these steps a second time with the
same result, but that may be coincidence.

Thank you for looking into this!

Sibylle
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: 
<pgadmin.about.AboutModule object at 0x000001E37F9E99C8>
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: 
<pgadmin.browser.BrowserModule object at 0x000001E37E0744C8>
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: 
<pgadmin.dashboard.DashboardModule object at 0x000001E37F68AE08>
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: 
<pgadmin.help.HelpModule object at 0x000001E3011ED248>
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: 
<pgadmin.misc.MiscModule object at 0x000001E37FA87E48>
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: 
<pgadmin.preferences.PreferencesModule object at 0x000001E3010D8448>
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: 
<pgadmin.utils.PgAdminModule object at 0x000001E3013B3988>
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: 
<pgadmin.settings.SettingsModule object at 0x000001E37F84CE48>
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: 
<pgadmin.tools.ToolsModule object at 0x000001E37FA85AC8>
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 -

Reply via email to