pgstac icon indicating copy to clipboard operation
pgstac copied to clipboard

Update maintain_partition_queries format

Open drnextgis opened this issue 1 year ago • 2 comments

Fixes query_queue table being poorly formatted:

postgis=> select * from pgstac.query_queue;
                                  query                                  |             added             
-------------------------------------------------------------------------+-------------------------------
 SELECT update_partition_stats('_items_19362_202407', 'f');              | 2024-07-02 13:26:12.703653+00
 SELECT update_partition_stats('_items_19363_202407', 'f');              | 2024-07-02 13:26:12.8475+00
 SELECT maintain_index(                                                 +| 2024-07-02 13:34:41.589782+00
                                                                        +| 
                 '_items_19362_202407_end_datetime_idx',NULL,'f','f','f'+| 
                                                                        +| 
             );                                                          | 
 SELECT update_partition_stats('_items_19362_202407', 't');              | 2024-07-02 13:34:41.589782+00
 SELECT maintain_index(                                                 +| 2024-07-02 13:34:41.821157+00
                                                                        +| 
                 '_items_19363_202407_end_datetime_idx',NULL,'f','f','f'+| 
                                                                        +| 
             );

drnextgis avatar Jul 02 '24 16:07 drnextgis

@drnextgis Hah, I actually prefer the formatting with the line separators as, to me, it's easier to see the full query when the query gets large. Do you have any reason other than just aesthetics to change the formatting here?

bitner avatar Jul 29 '24 15:07 bitner

No, it's just for the aesthetics of the query_queue content.

drnextgis avatar Jul 29 '24 16:07 drnextgis