phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stepan Migunov <stepan.migu...@firstlinesoftware.com>
Subject Performance degradation on query analysis
Date Tue, 17 Sep 2019 07:58:37 GMT
Hi
We have an issue with our production environment - from time to time we notice a significant
performance degradation for some queries. The strange thing is that the EXPLAIN operator for
these queries takes the same time as queries execution (5 minutes or more). So, I guess, the
issue is related to query's analysis but not data extraction. Is it possible that issue is
related to SYSTEM.STATS access problem? Any other ideas?

Mime
View raw message