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 2021/10/14 01:21:02 UTC

[GitHub] [superset] harshgadhia opened a new issue #17103: Operational Metrics for SuperSet

harshgadhia opened a new issue #17103:
URL: https://github.com/apache/superset/issues/17103


   **Problem**
   I have installed SuperSet for some of our querying and visualizing needs. However, sometimes queries take longer than expected time to execute. Once the application is installed and running in a production, it is very vital to get operational insights for the application's performance. This kind of metrics is missing in SuperSet.
   
   I am leveraging Apache SuperSet to enable stakeholders / users to query data from various pre-configured data sources. 
   As a product owner, I would like to get insights on:
   1. Query metrics such as `query/count`, `query/success/count`, `query/failed/count`, `query/interrupted/count`, `query/timeout/count`, `user`, `execution_time` etc.
   2. Number of queries ran over time (e.g. how many queries ran in the past hour / day etc) 
   
   **Describe the solution you'd like**
   There should be a way to expose the operational metrics for a metrics server to use as a part of the API specification available [here](https://superset.apache.org/docs/rest-api). So potentially an API endpoint like `/api/v1/metrics` that can have all the operational metrics in TSDB format.
   Having this type of insights via Apache SuperSet seems to be missing. 
   
   **Additional context**
   Please let me know if there is any way community is deriving these insights at the moment from Apache SuperSet?
   


-- 
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.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


[GitHub] [superset] nytai commented on issue #17103: Operational Metrics for SuperSet

Posted by GitBox <gi...@apache.org>.
nytai commented on issue #17103:
URL: https://github.com/apache/superset/issues/17103#issuecomment-946981855


   Everything can be handled via these configs https://github.com/apache/superset/blob/20627755a5f4e47abc38e43694be6161c479abaf/superset/config.py#L69


-- 
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.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


[GitHub] [superset] harshgadhia commented on issue #17103: Operational Metrics for SuperSet

Posted by GitBox <gi...@apache.org>.
harshgadhia commented on issue #17103:
URL: https://github.com/apache/superset/issues/17103#issuecomment-946846730


   @nytai thank you for the response, I am aware that SuperSet emits the query logs to local postgres db. However, I am looking to obtain the operational metrics in a TSDB format. By your reply, it seems possible to configure it to send it to other places like statsd. If so, could you please guide me on how to do it? Appreciate your help!


-- 
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.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


[GitHub] [superset] nytai commented on issue #17103: Operational Metrics for SuperSet

Posted by GitBox <gi...@apache.org>.
nytai commented on issue #17103:
URL: https://github.com/apache/superset/issues/17103#issuecomment-946164107


   Superset currently has a log event emitter, where user events are published. By default these events are sent to the metadata db in the logs table


-- 
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.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


[GitHub] [superset] geido closed issue #17103: Operational Metrics for SuperSet

Posted by GitBox <gi...@apache.org>.
geido closed issue #17103:
URL: https://github.com/apache/superset/issues/17103


   


-- 
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.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org