Flow Production Tracking Enterprise 8.16.0.5484
Local installations of Flow Production Tracking are no longer offered. This documentation is intended only for those with existing instances of Flow Production Tracking Enterprise Docker. Click here for a list of our current offerings.
The 8.16.0.5484 release includes some indexing of the event_log_entries table that could take a long time during the upgrade process.
In order to minimize the impact on your production server, we advise you to test the 8.16.0.5484 update first on staging to get an estimate of the production upgrade time. If the upgrade time is too high, execute the Manual event_log_entries indexing instructions below on your production instance before deploying 8.16.0.5484.
Manual event_log_entries indexing
Using the psql tool to connect to your db, run the following commands :
CREATE INDEX CONCURRENTLY ele_email_for_new_ctes ON event_log_entries(id) WHERE event_type = ANY('{"Shotgun_Note_New", "Shotgun_Ticket_New", "Shotgun_Delivery_New", "Shotgun_Reply_New", "Shotgun_Task_New", "Shotgun_Task_Change", "Shotgun_Version_New", "Shotgun_CustomThreadedEntity01_New", "Shotgun_CustomThreadedEntity02_New", "Shotgun_CustomThreadedEntity03_New", "Shotgun_HumanUser_Welcome_Email", "Shotgun_CustomThreadedEntity04_New", "Shotgun_CustomThreadedEntity05_New", "Shotgun_NotesApp_Summary_Email", "Shotgun_CustomThreadedEntity06_New", "Shotgun_CustomThreadedEntity07_New", "Shotgun_CustomThreadedEntity08_New", "Shotgun_CustomThreadedEntity09_New", "Shotgun_CustomThreadedEntity10_New", "Shotgun_CustomThreadedEntity11_New", "Shotgun_CustomThreadedEntity12_New", "Shotgun_CustomThreadedEntity13_New", "Shotgun_CustomThreadedEntity14_New", "Shotgun_CustomThreadedEntity15_New"}'::text[]) AND entity_type = ANY('{"Note", "Ticket", "Delivery", "Reply", "Task", "Version", "CustomThreadedEntity01", "Playlist", "CustomThreadedEntity02", "CustomThreadedEntity03", "CustomThreadedEntity04", "CustomThreadedEntity05", "HumanUser", "CustomThreadedEntity06", "CustomThreadedEntity07", "CustomThreadedEntity08", "CustomThreadedEntity09", "CustomThreadedEntity10", "CustomThreadedEntity11", "CustomThreadedEntity12", "CustomThreadedEntity13", "CustomThreadedEntity14", "CustomThreadedEntity15"}'::text[]) AND (1 <= notification_trial AND notification_trial <= 10);