You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2019/11/19 10:18:45 UTC
[GitHub] [incubator-superset] SyamprasadNakka edited a comment on issue
#8548: Dashboard results are very slow when pointed to Postgres Database
SyamprasadNakka edited a comment on issue #8548: Dashboard results are very slow when pointed to Postgres Database
URL: https://github.com/apache/incubator-superset/issues/8548#issuecomment-554985220
>
>
> That is unexpected to me, can anyone provide further insights?
>
> Can you post the server logs for this, showing the 30 seconds delay?
>
> Thank you
Hello @dpgaspar ,
Please find the below log and provide your inputs if any. Have accessed the dashboard **@18/Nov/2019:06:22:39** and you can find the same in logs.
Due to some security constraints have removed the report queries and marked the URL's with custom names.
>
```
>[2019-11-18 06:22:18 -0500] [37356] [INFO] Starting gunicorn 19.8.0
>[2019-11-18 06:22:18 -0500] [37356] [INFO] Listening at: https://0.0.0.0:8088 (37356)
>[2019-11-18 06:22:18 -0500] [37356] [INFO] Using worker: threads
>[2019-11-18 06:22:18 -0500] [37356] [INFO] Server is ready. Spawning workers
>[2019-11-18 06:22:18 -0500] [37360] [INFO] Booting worker with pid: 37360
>[2019-11-18 06:22:18 -0500] [37360] [INFO] Worker spawned (pid: 37360)
>[2019-11-18 06:22:18 -0500] [37361] [INFO] Booting worker with pid: 37361
>[2019-11-18 06:22:18 -0500] [37361] [INFO] Worker spawned (pid: 37361)
>[2019-11-18 06:22:18 -0500] [37362] [INFO] Booting worker with pid: 37362
>[2019-11-18 06:22:18 -0500] [37362] [INFO] Worker spawned (pid: 37362)
>172.30.128.117 - - [18/Nov/2019:06:22:34 -0500] "GET /login/?ticket=ST-3434-nIIAeCVBTpu25dlxdmzH5AYJhzUasdf1212 HTTP/1.1" 302 209 "https://ssobaseurl/sso/login?service=https%3A%2F%2Fhostname%3A8088%2Flogin%2F" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>172.30.128.117 - - [18/Nov/2019:06:22:35 -0500] "GET / HTTP/1.1" 302 241 "https://ssobaseurl/sso/login?service=https%3A%2F%2Fhostname%3A8088%2Flogin%2F" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>172.30.128.117 - - [18/Nov/2019:06:22:35 -0500] "GET /superset/welcome HTTP/1.1" 200 2875 "https://ssobaseurl/sso/login?service=https%3A%2F%2Fhostname%3A8088%2Flogin%2F" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>172.30.128.117 - - [18/Nov/2019:06:22:35 -0500] "GET /static/appbuilder/css/flags/flags16.css HTTP/1.1" 200 1639 "https://hostname:8088/superset/welcome" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>172.30.128.117 - - [18/Nov/2019:06:22:36 -0500] "GET /static/appbuilder/css/font-awesome.min.css HTTP/1.1" 200 7050 "https://hostname:8088/superset/welcome" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>172.30.128.117 - - [18/Nov/2019:06:22:36 -0500] "GET /static/assets/dist/theme.7f85921c9fdb511ef878.entry.css HTTP/1.1" 200 24036 "https://hostname:8088/superset/welcome" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>172.30.128.117 - - [18/Nov/2019:06:22:36 -0500] "GET /static/assets/dist/welcome.558ee6136ef3404b39d9.entry.css HTTP/1.1" 200 351 "https://hostname:8088/superset/welcome" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>172.30.128.117 - - [18/Nov/2019:06:22:37 -0500] "GET /static/assets/dist/theme.7f85921c9fdb511ef878.entry.js HTTP/1.1" 200 501 "https://hostname:8088/superset/welcome" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>172.30.128.117 - - [18/Nov/2019:06:22:37 -0500] "GET /static/assets/images/superset-logo@2x.png HTTP/1.1" 200 3054 "https://hostname:8088/superset/welcome" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>172.30.128.117 - - [18/Nov/2019:06:22:37 -0500] "GET /static/assets/images/loading.gif HTTP/1.1" 200 2239 "https://hostname:8088/superset/welcome" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>172.30.128.117 - - [18/Nov/2019:06:22:37 -0500] "GET /static/appbuilder/img/flags/flags16.png HTTP/1.1" 200 63284 "https://hostname:8088/static/appbuilder/css/flags/flags16.css" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>172.30.128.117 - - [18/Nov/2019:06:22:37 -0500] "GET /static/assets/dist/0.190559e74fa3fd59b550.chunk.js HTTP/1.1" 200 65840 "https://hostname:8088/superset/welcome" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>172.30.128.117 - - [18/Nov/2019:06:22:37 -0500] "GET /static/appbuilder/fonts/fontawesome-webfont.woff2?v=4.7.0 HTTP/1.1" 200 77160 "https://hostname:8088/static/appbuilder/css/font-awesome.min.css" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>172.30.128.117 - - [18/Nov/2019:06:22:38 -0500] "GET /static/assets/dist/welcome.558ee6136ef3404b39d9.entry.js HTTP/1.1" 200 177974 "https://hostname:8088/superset/welcome" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>172.30.128.117 - - [18/Nov/2019:06:22:38 -0500] "GET /static/assets/dist/vendors-major.a1019ec98dbcb99bd05d.chunk.js HTTP/1.1" 200 371838 "https://hostname:8088/superset/welcome" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>172.30.128.117 - - [18/Nov/2019:06:22:38 -0500] "GET /superset/fave_slices/3/ HTTP/1.1" 200 2 "https://hostname:8088/superset/welcome" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>172.30.128.117 - - [18/Nov/2019:06:22:38 -0500] "GET /superset/fave_dashboards/3/ HTTP/1.1" 200 2 "https://hostname:8088/superset/welcome" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>172.30.128.117 - - [18/Nov/2019:06:22:38 -0500] "GET /superset/recent_activity/3/?limit=50 HTTP/1.1" 200 758 "https://hostname:8088/superset/welcome" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>172.30.128.117 - - [18/Nov/2019:06:22:39 -0500] "GET /dashboardasync/api/read?_oc_DashboardModelViewAsync=changed_on&_od_DashboardModelViewAsync=desc HTTP/1.1" 200 908 "https://hostname:8088/superset/welcome" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>2019-11-18 06:22:53,010:DEBUG:root:[36m[stats_logger] (incr) dashboard[0m
>2019-11-18 06:22:53,099:INFO:root:Database.get_sqla_engine(). Masked URL: oracle://username:password@hostname:port/dbname
>2019-11-18 06:22:53,102:INFO:root:Database.get_sqla_engine(). Masked URL: oracle://username:password@hostname:port/dbname
>172.30.128.117 - - [18/Nov/2019:06:22:53 -0500] "GET /superset/dashboard/11234567804/ HTTP/1.1" 200 11713 "https://hostname:8088/superset/welcome" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>172.30.128.117 - - [18/Nov/2019:06:22:53 -0500] "GET /static/assets/dist/dashboard.89d23e20b5125b47fc95.entry.css HTTP/1.1" 200 4604 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>172.30.128.117 - - [18/Nov/2019:06:22:55 -0500] "GET /static/assets/dist/dashboard.89d23e20b5125b47fc95.entry.js HTTP/1.1" 200 535459 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>172.30.128.117 - - [18/Nov/2019:06:22:55 -0500] "GET /csstemplateasyncmodelview/api/read HTTP/1.1" 200 734 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>172.30.128.117 - - [18/Nov/2019:06:22:56 -0500] "GET /superset/favstar/Dashboard/11234567804/count HTTP/1.1" 301 363 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>172.30.128.117 - - [18/Nov/2019:06:22:56 -0500] "GET /static/assets/dist/23.e6a34598d17b83819447.chunk.css HTTP/1.1" 200 1579 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>172.30.128.117 - - [18/Nov/2019:06:22:56 -0500] "GET /static/assets/dist/3.6baabb844bf1e5311ea2.chunk.css HTTP/1.1" 200 2420 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>172.30.128.117 - - [18/Nov/2019:06:22:56 -0500] "GET /static/assets/dist/36.b5e9b5278b1896c25bde.chunk.css HTTP/1.1" 200 586 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>172.30.128.117 - - [18/Nov/2019:06:22:57 -0500] "GET /static/assets/dist/50.0c5dc6a6d7c7b2a9960c.chunk.css HTTP/1.1" 200 261 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>172.30.128.117 - - [18/Nov/2019:06:22:57 -0500] "GET /static/assets/dist/7.17568c96ecfcb9d4610d.chunk.css HTTP/1.1" 200 2156 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>172.30.128.117 - - [18/Nov/2019:06:22:57 -0500] "GET /static/assets/dist/12.c8d9abe8d73e75d8fcc8.chunk.css HTTP/1.1" 200 943 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>2019-11-18 06:22:57,325:DEBUG:root:[36m[stats_logger] (incr) explore_json[0m
>2019-11-18 06:22:57,430:INFO:root:Cache key: df4888b706b0d23c7d2cdf6f7c91c772
>2019-11-18 06:22:57,441:INFO:root:Database.get_sqla_engine(). Masked URL: oracle://username:password@hostname:port/dbname
>2019-11-18 06:22:57,445:INFO:root:
>
>SELECT
>
>##################### Database Query Generated ########### Removed the query, as this is sensitive data ##############
>
>WHERE ROWNUM <= 1000
>
>2019-11-18 06:22:57,452:INFO:root:Database.get_sqla_engine(). Masked URL: oracle://username:password@hostname:port/dbname
>2019-11-18 06:22:57,525:DEBUG:root:[36m[stats_logger] (incr) explore_json[0m
>2019-11-18 06:22:57,601:INFO:root:Cache key: c06e2d38845633af72a38326a6aaf327
>2019-11-18 06:22:57,613:INFO:root:Database.get_sqla_engine(). Masked URL: oracle://username:password@hostname:port/dbname
>2019-11-18 06:22:57,615:INFO:root:SELECT
>
>##################### Database Query Generated ########### Removed the query for as this is sensitive data ##############
>WHERE ROWNUM <= 512345678
>
>
>2019-11-18 06:22:57,645:INFO:root:Database.get_sqla_engine(). Masked URL: oracle://username:password@hostname:port/dbname
>2019-11-18 06:22:57,830:DEBUG:root:[36m[stats_logger] (incr) explore_json[0m
>2019-11-18 06:22:57,896:DEBUG:root:[36m[stats_logger] (incr) loaded_from_source[0m
>2019-11-18 06:22:57,897:INFO:root:Cache key: 9c207fe9fa22522893958347be568d5d
>2019-11-18 06:22:57,901:INFO:root:SELECT
>
>##################### Database Query Generated ########### Removed the query, as this is sensitive data ##############
>
>
>WHERE ROWNUM <= 1000
>
>2019-11-18 06:22:57,930:INFO:root:Cache key: acc8b8ca33f74db8f985755ade233c20
>2019-11-18 06:22:57,945:INFO:root:Database.get_sqla_engine(). Masked URL: oracle://username:password@hostname:port/dbname
>2019-11-18 06:22:57,946:INFO:root:SELECT
>
>##################### Database Query Generated ########### Removed the query, as this is sensitive data ##############
>
>WHERE ROWNUM <= 512345678
>
>2019-11-18 06:22:57,979:INFO:root:Database.get_sqla_engine(). Masked URL: oracle://username:password@hostname:port/dbname
>2019-11-18 06:22:58,324:DEBUG:root:[36m[stats_logger] (incr) loaded_from_source[0m
>2019-11-18 06:22:58,324:INFO:root:Cache key: None
>VPD Successfully Applied for the User : username
>VPD Successfully Applied for the User : username
>172.30.128.117 - - [18/Nov/2019:06:22:58 -0500] "POST /superset/explore_json/?form_data=%7B%22slice_id%22%3A1000198%7D HTTP/1.1" 200 625 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>2019-11-18 06:22:58,589:DEBUG:root:[36m[stats_logger] (incr) explore_json[0m
>2019-11-18 06:22:58,659:INFO:root:Cache key: 03d9562c997db8e94dd86889cf8d6d92
>2019-11-18 06:22:58,672:INFO:root:Database.get_sqla_engine(). Masked URL: oracle://username:password@hostname:port/dbname
>2019-11-18 06:22:58,673:INFO:root:SELECT
>
>##################### Database Query Generated ########### Removed the query, as this is sensitive data ##############
>
>WHERE ROWNUM <= 512345678
>
>2019-11-18 06:22:58,702:INFO:root:Database.get_sqla_engine(). Masked URL: oracle://username:password@hostname:port/dbname
>2019-11-18 06:23:00,322:DEBUG:root:[36m[stats_logger] (incr) explore_json[0m
>2019-11-18 06:23:00,378:INFO:root:Cache key: ecece617269112a0e00465cae57ca87b
>2019-11-18 06:23:00,392:INFO:root:Database.get_sqla_engine(). Masked URL: oracle://username:password@hostname:port/dbname
>2019-11-18 06:23:00,393:INFO:root:SELECT
>
>##################### Database Query Generated ########### Removed the query, as this is sensitive data ##############
>
>WHERE ROWNUM <= 512345678
>
>2019-11-18 06:23:00,418:INFO:root:Database.get_sqla_engine(). Masked URL: oracle://username:password@hostname:port/dbname
>2019-11-18 06:23:06,755:DEBUG:root:[36m[stats_logger] (incr) loaded_from_source[0m
>VPD Successfully Applied for the User : username
>VPD Successfully Applied for the User : username
>172.30.128.117 - - [18/Nov/2019:06:23:06 -0500] "POST /superset/explore_json/?form_data=%7B%22slice_id%22%3A1000217%7D HTTP/1.1" 200 1037 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>2019-11-18 06:23:07,010:DEBUG:root:[36m[stats_logger] (incr) explore_json[0m
>2019-11-18 06:23:07,076:INFO:root:Cache key: 9d99ee4ac42b004572a78b84c427806e
>2019-11-18 06:23:07,088:INFO:root:Database.get_sqla_engine(). Masked URL: oracle://username:password@hostname:port/dbname
>2019-11-18 06:23:07,090:INFO:root:SELECT
>
>##################### Database Query Generated ########### Removed the query, as this is sensitive data ##############
>
>WHERE ROWNUM <= 512345678
>
>2019-11-18 06:23:07,115:INFO:root:Database.get_sqla_engine(). Masked URL: oracle://username:password@hostname:port/dbname
>2019-11-18 06:23:08,472:DEBUG:root:[36m[stats_logger] (incr) loaded_from_source[0m
>VPD Successfully Applied for the User : username
>172.30.128.117 - - [18/Nov/2019:06:23:08 -0500] "POST /superset/explore_json/?form_data=%7B%22slice_id%22%3A1000227%7D HTTP/1.1" 200 976 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>2019-11-18 06:23:08,736:DEBUG:root:[36m[stats_logger] (incr) explore_json[0m
>2019-11-18 06:23:08,803:INFO:root:Cache key: 9ee8fe1150feb03553a2584b808153de
>2019-11-18 06:23:08,835:INFO:root:Database.get_sqla_engine(). Masked URL: oracle://username:password@hostname:port/dbname
>2019-11-18 06:23:08,837:INFO:root:SELECT
>
>##################### Database Query Generated ########### Removed the query, as this is sensitive data ##############
>
>WHERE ROWNUM <= 112345678
>
>2019-11-18 06:23:08,913:INFO:root:Database.get_sqla_engine(). Masked URL: oracle://username:password@hostname:port/dbname
>2019-11-18 06:23:09,576:DEBUG:root:[36m[stats_logger] (incr) loaded_from_source[0m
>VPD Successfully Applied for the User : username
>VPD Successfully Applied for the User : username
>172.30.128.117 - - [18/Nov/2019:06:23:09 -0500] "POST /superset/explore_json/?form_data=%7B%22slice_id%22%3A1000215%7D HTTP/1.1" 200 1175 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>2019-11-18 06:23:09,594:DEBUG:root:[36m[stats_logger] (incr) explore_json[0m
>2019-11-18 06:23:09,647:DEBUG:root:[36m[stats_logger] (incr) loaded_from_source[0m
>VPD Successfully Applied for the User : username
>172.30.128.117 - - [18/Nov/2019:06:23:09 -0500] "POST /superset/explore_json/?form_data=%7B%22slice_id%22%3A1000216%7D HTTP/1.1" 200 1110 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>2019-11-18 06:23:09,669:INFO:root:Cache key: a3fd1a6f4f865841976f75b7d67b7eb8
>2019-11-18 06:23:09,689:INFO:root:Database.get_sqla_engine(). Masked URL: oracle://username:password@hostname:port/dbname
>2019-11-18 06:23:09,691:INFO:root:SELECT
>
>##################### Database Query Generated ########### Removed the query, as this is sensitive data ##############
>
>WHERE ROWNUM <= 1000
>
>2019-11-18 06:23:09,733:INFO:root:Database.get_sqla_engine(). Masked URL: oracle://username:password@hostname:port/dbname
>2019-11-18 06:23:09,913:DEBUG:root:[36m[stats_logger] (incr) explore_json[0m
>2019-11-18 06:23:09,980:INFO:root:Cache key: a4c4e35bfafe1f20ff79edb3ec80342a
>2019-11-18 06:23:09,989:INFO:root:Database.get_sqla_engine(). Masked URL: oracle://username:password@hostname:port/dbname
>2019-11-18 06:23:09,991:INFO:root:SELECT
>
>##################### Database Query Generated ########### Removed the query, as this is sensitive data ##############
>
>WHERE ROWNUM <= 1000
>
>2019-11-18 06:23:10,011:INFO:root:Database.get_sqla_engine(). Masked URL: oracle://username:password@hostname:port/dbname
>2019-11-18 06:23:10,820:DEBUG:root:[36m[stats_logger] (incr) loaded_from_source[0m
>VPD Successfully Applied for the User : username
>172.30.128.117 - - [18/Nov/2019:06:23:10 -0500] "POST /superset/explore_json/?form_data=%7B%22slice_id%22%3A1000230%7D HTTP/1.1" 200 11855 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>2019-11-18 06:23:11,037:DEBUG:root:[36m[stats_logger] (incr) loaded_from_source[0m
>172.30.128.117 - - [18/Nov/2019:06:23:11 -0500] "POST /superset/explore_json/?form_data=%7B%22slice_id%22%3A1000214%7D HTTP/1.1" 200 2607 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>2019-11-18 06:23:11,109:DEBUG:root:[36m[stats_logger] (incr) explore_json[0m
>2019-11-18 06:23:11,123:DEBUG:root:[36m[stats_logger] (incr) loaded_from_source[0m
>VPD Successfully Applied for the User : username
>172.30.128.117 - - [18/Nov/2019:06:23:11 -0500] "POST /superset/explore_json/?form_data=%7B%22slice_id%22%3A1000225%7D HTTP/1.1" 200 1028 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>2019-11-18 06:23:11,183:INFO:root:Cache key: 011921c76c9878320f597b15302bc630
>2019-11-18 06:23:11,193:INFO:root:Database.get_sqla_engine(). Masked URL: oracle://username:password@hostname:port/dbname
>2019-11-18 06:23:11,195:INFO:root:SELECT
>
>##################### Database Query Generated ########### Removed the query, as this is sensitive data ##############
>
>WHERE ROWNUM <= 1000
>
>2019-11-18 06:23:11,216:INFO:root:Database.get_sqla_engine(). Masked URL: oracle://username:password@hostname:port/dbname
>172.30.128.117 - - [18/Nov/2019:06:23:11 -0500] "GET /superset/favstar/Dashboard/11234567804/count/ HTTP/1.1" 200 12 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>2019-11-18 06:23:11,397:DEBUG:root:[36m[stats_logger] (incr) explore_json[0m
>2019-11-18 06:23:11,466:INFO:root:Cache key: 0bc52b5111d00fdfccb0c66ac43ddd59
>2019-11-18 06:23:11,481:INFO:root:Database.get_sqla_engine(). Masked URL: oracle://username:password@hostname:port/dbname
>2019-11-18 06:23:11,483:INFO:root:SELECT
>
>##################### Database Query Generated ########### Removed the query, as this is sensitive data ##############
>
>WHERE ROWNUM <= 1000
>
>2019-11-18 06:23:11,509:INFO:root:Database.get_sqla_engine(). Masked URL: oracle://username:password@hostname:port/dbname
>VPD Successfully Applied for the User : username
>172.30.128.117 - - [18/Nov/2019:06:23:12 -0500] "GET /static/assets/dist/23.e6a34598d17b83819447.chunk.js HTTP/1.1" 200 163602 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>2019-11-18 06:23:12,531:DEBUG:root:[36m[stats_logger] (incr) loaded_from_source[0m
>172.30.128.117 - - [18/Nov/2019:06:23:12 -0500] "POST /superset/explore_json/?form_data=%7B%22slice_id%22%3A1000226%7D HTTP/1.1" 200 964 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>172.30.128.117 - - [18/Nov/2019:06:23:12 -0500] "GET /static/assets/dist/36.b5e9b5278b1896c25bde.chunk.js HTTP/1.1" 200 4721 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>172.30.128.117 - - [18/Nov/2019:06:23:12 -0500] "GET /static/assets/dist/12.c8d9abe8d73e75d8fcc8.chunk.js HTTP/1.1" 200 28822 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>172.30.128.117 - - [18/Nov/2019:06:23:13 -0500] "GET /static/assets/dist/50.0c5dc6a6d7c7b2a9960c.chunk.js HTTP/1.1" 200 1838 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>172.30.128.117 - - [18/Nov/2019:06:23:13 -0500] "GET /static/assets/dist/1.616b4cfd2933fa214795.chunk.js HTTP/1.1" 200 132746 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>172.30.128.117 - - [18/Nov/2019:06:23:13 -0500] "GET /static/assets/dist/2.379e75833d1629cefd8a.chunk.js HTTP/1.1" 200 54679 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>172.30.128.117 - - [18/Nov/2019:06:23:13 -0500] "GET /static/assets/dist/3.6baabb844bf1e5311ea2.chunk.js HTTP/1.1" 200 6126 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>2019-11-18 06:23:14,037:DEBUG:root:[36m[stats_logger] (incr) log[0m
>172.30.128.117 - - [18/Nov/2019:06:23:14 -0500] "POST /superset/log/?explode=events&dashboard_id=11234567804 HTTP/1.1" 200 20 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>2019-11-18 06:23:14,289:DEBUG:root:[36m[stats_logger] (incr) log[0m
>172.30.128.117 - - [18/Nov/2019:06:23:14 -0500] "POST /superset/log/?explode=events&dashboard_id=11234567804 HTTP/1.1" 200 20 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>2019-11-18 06:23:14,541:DEBUG:root:[36m[stats_logger] (incr) log[0m
>172.30.128.117 - - [18/Nov/2019:06:23:14 -0500] "POST /superset/log/?explode=events&dashboard_id=11234567804 HTTP/1.1" 200 20 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>2019-11-18 06:23:14,797:DEBUG:root:[36m[stats_logger] (incr) log[0m
>172.30.128.117 - - [18/Nov/2019:06:23:14 -0500] "POST /superset/log/?explode=events&dashboard_id=11234567804 HTTP/1.1" 200 20 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>2019-11-18 06:23:15,054:DEBUG:root:[36m[stats_logger] (incr) log[0m
>172.30.128.117 - - [18/Nov/2019:06:23:15 -0500] "POST /superset/log/?explode=events&dashboard_id=11234567804 HTTP/1.1" 200 20 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>2019-11-18 06:23:15,309:DEBUG:root:[36m[stats_logger] (incr) log[0m
>172.30.128.117 - - [18/Nov/2019:06:23:15 -0500] "POST /superset/log/?explode=events&dashboard_id=11234567804 HTTP/1.1" 200 20 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>172.30.128.117 - - [18/Nov/2019:06:23:15 -0500] "GET /static/assets/dist/448c34a56d699c29117adc64c43affeb.woff2 HTTP/1.1" 200 18028 "https://hostname:8088/static/assets/dist/theme.7f85921c9fdb511ef878.entry.css" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>2019-11-18 06:23:16,755:DEBUG:root:[36m[stats_logger] (incr) log[0m
>172.30.128.117 - - [18/Nov/2019:06:23:16 -0500] "POST /superset/log/?explode=events&dashboard_id=11234567804 HTTP/1.1" 200 20 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>2019-11-18 06:23:17,703:DEBUG:root:[36m[stats_logger] (incr) loaded_from_source[0m
>VPD Successfully Applied for the User : username
>172.30.128.117 - - [18/Nov/2019:06:23:17 -0500] "POST /superset/explore_json/?form_data=%7B%22slice_id%22%3A1000224%7D HTTP/1.1" 200 1001 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>172.30.128.117 - - [18/Nov/2019:06:23:17 -0500] "GET /static/assets/dist/7.17568c96ecfcb9d4610d.chunk.js HTTP/1.1" 200 8993 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>2019-11-18 06:23:19,052:DEBUG:root:[36m[stats_logger] (incr) log[0m
>172.30.128.117 - - [18/Nov/2019:06:23:19 -0500] "POST /superset/log/?explode=events&dashboard_id=11234567804 HTTP/1.1" 200 20 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>2019-11-18 06:23:21,440:DEBUG:root:[36m[stats_logger] (incr) loaded_from_source[0m
>172.30.128.117 - - [18/Nov/2019:06:23:21 -0500] "POST /superset/explore_json/?form_data=%7B%22slice_id%22%3A1000220%7D HTTP/1.1" 200 1267 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>2019-11-18 06:23:22,724:DEBUG:root:[36m[stats_logger] (incr) log[0m
>172.30.128.117 - - [18/Nov/2019:06:23:22 -0500] "POST /superset/log/?explode=events&dashboard_id=11234567804 HTTP/1.1" 200 20 "https://hostname:8088/superset/dashboard/11234567804/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36"
>
```
Please let me know if need any more details.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org