<b>Análisis de logs y wait events como metodología estructurada para el diagnóstico del rendimiento en bases de datos relacionales gestionadas</b>
PDF

Palabras clave

Rendimiento
Wait Events
Bases de Datos
Diagnóstico
Optimización
Índices
Concurrencia
Observabilidad

Categorías

Cómo citar

Análisis de logs y wait events como metodología estructurada para el diagnóstico del rendimiento en bases de datos relacionales gestionadas. (2026). Sciencevolution, 5(4). https://doi.org/10.61325/rnzrw588

Resumen

El diagnóstico de problemas de rendimiento en bases de datos relacionales suele realizarse de manera reactiva y mediante el análisis aislado de métricas, lo que dificulta identificar sus causas. El objetivo fue medir la efectividad de una metodología estructurada basada en logs y wait events. Se empleó un enfoque cuantitativo, con diseño cuasi-experimental de carácter aplicado, comparando dos condiciones sobre una misma instancia de PostgreSQL 16: una condición base sin índices de apoyo y otra optimizada mediante una intervención derivada del diagnóstico. La carga concurrente se generó con pgbench sobre un conjunto sintético de 32,050,000 registros. Se utilizaron Performance Insights, EXPLAIN ANALYZE y pg_stat_statements para analizar los eventos de espera, los planes de ejecución y las estadísticas de las consultas. Durante los tres minutos completos de la condición base, la carga activa promedio fue de 14.867 sesiones frente a 2 vCPU disponibles. Tras la intervención, el rendimiento aumentó de 0.43 a 203.48 transacciones por segundo y la latencia media disminuyó de 18,409 a 39 milisegundos. Los resultados aportaron evidencia favorable sobre la efectividad de la metodología en las condiciones evaluadas, aunque su aplicación a otros entornos requiere validaciones adicionales.

PDF

Referencias

Abadi, D., Ailamaki, A., Andersen, D. G., Bailis, P., Balazinska, M., Bernstein, P. A., Boncz, P. A., Chaudhuri, S., Cheung, A., Doan, A., Dong, L., Franklin, M. J., Freire, J., Halevy, A. Y., Hellerstein, J. M., Idreos, S., Kossmann, D., Kraska, T., Krishnamurthy, S., ... Suciu, D. (2022). The Seattle report on database research. Communications of the ACM, 65(8), 72–79. https://doi.org/10.1145/3524284

Abbasi, M., Bernardo, M. V., Váz, P., Silva, J., & Martins, P. (2024). Revisiting database indexing for parallel and accelerated computing: A comprehensive study and novel approaches. Information, 15(8), Article 429. https://doi.org/10.3390/info15080429

Anchlia, A. (2024). Enhancing query performance through relational database indexing. International Journal of Computer Trends and Technology, 72(8), 130–133. https://doi.org/10.14445/22312803/IJCTT-V72I8P119

Barbosa, D., Gruenwald, L., D’Orazio, L., & Bernardino, J. (2024). QRLIT: Quantum reinforcement learning for database index tuning. Future Internet, 16(12), Article 439. https://doi.org/10.3390/fi16120439

Currim, S., Snodgrass, R. T., & Suh, Y. K. (2024). Identifying the root causes of DBMS suboptimality. ACM Transactions on Database Systems, 49(1), Article 4. https://doi.org/10.1145/3636425

Das, S., Grbic, M., Ilic, I., Jovandic, I., Jovanovic, A., Narasayya, V. R., Radulovic, M., Stikic, M., Xu, G., & Chaudhuri, S. (2019). Automatically indexing millions of databases in Microsoft Azure SQL Database. In Proceedings of the 2019 International Conference on Management of Data (pp. 666–679). Association for Computing Machinery. https://doi.org/10.1145/3299869.3314035

Harizopoulos, S., Abadi, D. J., Madden, S., & Stonebraker, M. (2018). OLTP through the looking glass, and what we found there. En M. L. Brodie (Ed.), Making databases work: The pragmatic wisdom of Michael Stonebraker (pp. 409–439). Association for Computing Machinery. https://doi.org/10.1145/3226595.3226635

Hashim, H. B. (2026). Performance evaluation of B-Tree and hash indexing under varying data sizes in relational database systems. Computing and Artificial Intelligence, 4(1), Article 4104. https://doi.org/10.59400/cai4104

Huang, S., Wang, Z., Wu, Y., Tu, Y., Wang, J., & Cui, B. (2025). OpDiag: Unveiling database performance anomalies through query operator attribution. IEEE Transactions on Knowledge and Data Engineering, 37(6), 3613–3626. https://doi.org/10.1109/TKDE.2025.3557049

Kleppmann, M. (2017). Designing data-intensive applications: The big ideas behind reliable, scalable, and maintainable systems. O’Reilly Media.

Kompalli, K. (2024). Automated monitoring and alerting frameworks for enterprise databases: Architecture, thresholds, and root-cause identification. International Journal of Scientific Research in Science and Technology, 11(4), 766–780. https://doi.org/10.32628/IJSRST25125216

Kurmanji, M., & Triantafillou, P. (2023). Detect, distill and update: Learned DB systems facing out of distribution data. Proceedings of the ACM on Management of Data, 1(1), 1–27. https://doi.org/10.1145/3588713

Lao, J., Wang, Y., Li, Y., Wang, J., Zhang, Y., Cheng, Z., Chen, W., Tang, M., & Wang, J. (2024). GPTuner: A manual-reading database tuning system via GPT-guided Bayesian optimization. Proceedings of the VLDB Endowment, 17(8), 1939–1952. https://doi.org/10.14778/3659437.3659449

Leis, V., Gubichev, A., Mirchev, A., Boncz, P., Kemper, A., & Neumann, T. (2015). How good are query optimizers, really? Proceedings of the VLDB Endowment, 9(3), 204–215. https://doi.org/10.14778/2850583.2850594

Li, Z., Tu, Y., & Ma, Z. (2023). A sample-aware database tuning system with deep reinforcement learning. Journal of Database Management, 35(1), 1–25. https://doi.org/10.4018/JDM.333519

Lim, W. S., Ma, L., Zhang, W., Butrovich, M., Arch, S., & Pavlo, A. (2024). Hit the gym: Accelerating query execution to efficiently bootstrap behavior models for self-driving database management systems. Proceedings of the VLDB Endowment, 17(11), 3680–3693. https://doi.org/10.14778/3681954.3682030

Ma, L., Van Aken, D., Hefny, A., Mezerhane, G., Pavlo, A., & Gordon, G. J. (2018). Query-based workload forecasting for self-driving database management systems. In Proceedings of the 2018 International Conference on Management of Data (pp. 631–645). Association for Computing Machinery. https://doi.org/10.1145/3183713.3196908

Ma, L., Zhang, W., Jiao, J., Wang, W., Butrovich, M., Lim, W. S., Menon, P., & Pavlo, A. (2021). MB2: Decomposed behavior modeling for self-driving database management systems. In Proceedings of the 2021 International Conference on Management of Data (pp. 1248–1261). Association for Computing Machinery. https://doi.org/10.1145/3448016.3457276

Shin, Y., Ahn, J., & Im, D. (2022). Join optimization for inverted index technique on relational database management systems. Expert Systems with Applications, 198, Article 116956. https://doi.org/10.1016/j.eswa.2022.116956

Solohub, V., & Pashkevych, V. (2026). Comparative analysis of query optimization techniques in modern relational database systems. Journal of Computer Sciences Institute, 39, 132–137. https://doi.org/10.35784/jcsi.8944

Stonebraker, M., & Pavlo, A. (2024). What goes around comes around... and around. ACM SIGMOD Record, 53(2), 21–37. https://doi.org/10.1145/3685980.3685984

Tong, Y., Liu, F., Xu, J., Wang, H., Zhou, K., & Miao, J. (2025). BISLearner: Block-aware index selection using attention-based reinforcement learning for data analytics. ACM Transactions on Database Systems, 51(1), Article 2. https://doi.org/10.1145/3760773

Trummer, I. (2022). DB-BERT: A database tuning tool that reads the manual. In Proceedings of the 2022 International Conference on Management of Data (pp. 190–203). Association for Computing Machinery. https://doi.org/10.1145/3514221.3517843

Van Aken, D., Yang, D., Brillard, S., Fiorino, A., Zhang, B., Billian, C., & Pavlo, A. (2021). An inquiry into machine learning-based automatic configuration tuning services on real-world database management systems. Proceedings of the VLDB Endowment, 14(7), 1241–1253. https://doi.org/10.14778/3450980.3450992

Zhang, J., Liu, Y., Zhou, K., Li, G., Xiao, Z., Cheng, B., Xing, J., Wang, Y., Cheng, T., Liu, L., Ran, M., & Li, Z. (2019). An end-to-end automatic cloud database tuning system using deep reinforcement learning. In Proceedings of the 2019 International Conference on Management of Data (pp. 415–432). Association for Computing Machinery. https://doi.org/10.1145/3299869.3300085

Creative Commons License

Esta obra está bajo una licencia internacional Creative Commons Atribución-NoComercial-SinDerivadas 4.0.

Derechos de autor 2026 Angel Enrique Romero Cuevas, Gabriel Sánchez Bautista