Optimizing SQL Queries to Improve the Performance of Information Systems
Mikhail E. Stavrovsky, T. A. Nosenko, Elena S. Postnikova, A. V. Ragutkin, I. M. Sidorov, M. I. Sidorov · 2025
This article addresses the issue of database performance, specifically the execution of SQL queries. Solving this problem is essential for improving the efficiency of information systems. The article examines various parameters that affect SQL query execution, identified using the PostgreSQL command EXPLAIN. The metrics are normalized using exponential smoothing, their sample correlation coefficient is calculated, and the parameters that have the most significant impact on the most comprehensive quality indicator of SQL queries - their cost - are identified.