GiannisDimitriou commented on issue #5953: URL: https://github.com/apache/incubator-superset/issues/5953#issuecomment-671962136
@mistercrunch I am experiencing the same issue on superset metadata db (postgres). A lot of the connection are on "idle in transaction" state meaning that the handling of the transaction from Superset site is not optimal. Another observation is that the query for all those "idle in transaction" transactions is the same as shown below, if that helps pinpoint issue. `SELECT slices.created_on AS slices_created_on, slices.changed_on AS slices_changed_on, slices.id AS slices_id, slices.slice_name AS slices_slice_name, tables_1.created_on AS tables_1_created_on, tables_1.changed_on AS tables_1_changed_on, tables_1.id AS tables_1_id ....` Superset version 0.37.0rc1 ---------------------------------------------------------------- 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: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
