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 -