Query Optimization

View 1 - vw_booking_overview

Without indexes we get

[2026-04-30 18:58:12] postgres.public> select * from vw_booking_overview where booking_status = 'CONFIRMED'
[2026-04-30 18:58:18] 500 rows retrieved starting from 1 in 6 s 361 ms (execution: 5 s 882 ms, fetching: 479 ms)

5s is not an acceptable time so we add indexes to try and optimize it From the picture we can see that the longest is from executing Full Scans