I investigate these issue with long query and figure out that source is Faceted module.
During day I dont have issue, query is done but during night something happen and query stuck and become long query.
Also I run cronjob for price indexer for each 30 minutes.
In attachment you will find query from database.