pgstac
pgstac copied to clipboard
Update maintain_partition_queries format
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 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?
No, it's just for the aesthetics of the query_queue content.