= 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