Changes between Initial Version and Version 1 of QueryOptimization


Ignore:
Timestamp:
04/30/26 19:28:23 (4 days ago)
Author:
231035
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • QueryOptimization

    v1 v1  
     1= Query Optimization
     2== View 1 - vw_booking_overview
     3Without indexes we get
     4{{{
     5[2026-04-30 18:58:12] postgres.public> select * from vw_booking_overview where booking_status = 'CONFIRMED'
     6[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)
     7}}}
     85s is not an acceptable time so we add indexes to try and optimize it
     9From the picture we can see that the longest is from executing Full Scans