Query Optimization

Overview

The purpose of this phase was to analyze and optimize the performance of the database views used in the Laboratory Management System. Performance testing was performed using PostgreSQL's EXPLAIN ANALYZE command.

For each view, the execution plan was analyzed in order to identify potential bottlenecks, evaluate index usage, and determine whether additional optimization was required. Special attention was given to Sequential Scan, Parallel Sequential Scan, Index Scan, and Index Only Scan operations.

The database contains large amounts of generated data, including millions of patients, samples, payments, and laboratory requests, making query optimization an important aspect of the system.

Analyzed Views

• v_lab_request_details
• v_invoice_payment_summary
• v_sample_details
• v_test_result_details
• v_patient_statistics
• v_ordered_test_details
• v_ordered_package_details
• v_employee_schedule_details
• v_lab_equipment_skills

The detailed performance analysis, execution plans, and optimization results for each view are presented below.