From 0d10b3e89a029ebb64051c3c3b53212c50baccc1 Mon Sep 17 00:00:00 2001 From: Andreas Gerler Date: Sun, 26 Nov 2023 16:55:43 +0100 Subject: [PATCH] update vertica-snippets Signed-off-by: Andreas Gerler --- .../vertica-snippets-autoloads.el | 32 ------------------- .../sql-interactive-mode/.dir-locals.el | 0 .../snippets/sql-interactive-mode/busy-hours | 0 .../sql-interactive-mode/check_rle_overridden | 0 .../sql-interactive-mode/config-changes | 0 .../sql-interactive-mode/current_epoch | 0 .../sql-interactive-mode/dc_refresh_columns | 7 ++++ .../snippets/sql-interactive-mode/errors | 0 .../external_table_details | 0 .../sql-interactive-mode/format_numbers | 0 .../sql-interactive-mode/get-partitions | 0 .../sql-interactive-mode/get-projections | 0 .../snippets/sql-interactive-mode/grants | 0 .../last-statement-timing | 0 .../sql-interactive-mode/last-vertica-updates | 0 .../sql-interactive-mode/licence-history | 0 .../sql-interactive-mode/list-backups | 0 .../list-tables-row-count-size | 4 +-- .../snippets/sql-interactive-mode/nodes | 0 .../snippets/sql-interactive-mode/pool_queues | 0 .../sql-interactive-mode/projection_storage | 0 .../snippets/sql-interactive-mode/pset_footer | 0 .../snippets/sql-interactive-mode/qp_session | 18 +++++++++++ .../snippets/sql-interactive-mode/qp_slow | 18 +++++++++++ .../query-acquisition-queue | 0 .../sql-interactive-mode/query-event-issues | 0 .../query-long-acquisitions | 0 .../sql-interactive-mode/query-requests | 0 .../query-requests-expensive | 0 .../query-requests-overview | 0 .../snippets/sql-interactive-mode/query-times | 0 .../rebalance_projection_status | 0 .../sql-interactive-mode/rebalance_status | 0 .../sql-interactive-mode/rebalance_times | 0 .../sql-interactive-mode/resource-pool-move | 0 .../sql-interactive-mode/resource_pool_status | 0 .../resource_pool_status2 | 0 .../sql-interactive-mode/resource_pools | 0 .../snippets/sql-interactive-mode/resources | 0 .../snippets/sql-interactive-mode/ros_count | 0 .../snippets/sql-interactive-mode/seg-keys | 15 +++++++++ .../segmentation-islands1 | 0 .../segmentation-islands2 | 0 .../snippets/sql-interactive-mode/sessions | 0 .../sql-interactive-mode/storage-containers | 0 .../sql-interactive-mode/storage-locations | 0 .../snippets/sql-interactive-mode/table_locks | 0 .../sql-interactive-mode/user_sessions | 0 .../sql-interactive-mode/varchar_column_check | 17 ++++++++++ .../sql-interactive-mode/vertica_users | 0 .../snippets/sql-mode/.yas-parents | 0 .../vertica-snippets-autoloads.el | 31 ++++++++++++++++++ .../vertica-snippets-pkg.el | 6 ++-- .../vertica-snippets.el | 0 54 files changed, 112 insertions(+), 36 deletions(-) delete mode 100644 elpa/vertica-snippets-20200423.1200/vertica-snippets-autoloads.el rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/.dir-locals.el (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/busy-hours (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/check_rle_overridden (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/config-changes (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/current_epoch (100%) create mode 100644 elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/dc_refresh_columns rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/errors (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/external_table_details (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/format_numbers (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/get-partitions (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/get-projections (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/grants (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/last-statement-timing (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/last-vertica-updates (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/licence-history (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/list-backups (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/list-tables-row-count-size (64%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/nodes (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/pool_queues (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/projection_storage (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/pset_footer (100%) create mode 100644 elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/qp_session create mode 100644 elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/qp_slow rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/query-acquisition-queue (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/query-event-issues (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/query-long-acquisitions (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/query-requests (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/query-requests-expensive (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/query-requests-overview (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/query-times (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/rebalance_projection_status (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/rebalance_status (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/rebalance_times (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/resource-pool-move (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/resource_pool_status (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/resource_pool_status2 (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/resource_pools (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/resources (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/ros_count (100%) create mode 100644 elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/seg-keys rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/segmentation-islands1 (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/segmentation-islands2 (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/sessions (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/storage-containers (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/storage-locations (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/table_locks (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/user_sessions (100%) create mode 100644 elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/varchar_column_check rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-interactive-mode/vertica_users (100%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/snippets/sql-mode/.yas-parents (100%) create mode 100644 elpa/vertica-snippets-20231010.1104/vertica-snippets-autoloads.el rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/vertica-snippets-pkg.el (61%) rename elpa/{vertica-snippets-20200423.1200 => vertica-snippets-20231010.1104}/vertica-snippets.el (100%) diff --git a/elpa/vertica-snippets-20200423.1200/vertica-snippets-autoloads.el b/elpa/vertica-snippets-20200423.1200/vertica-snippets-autoloads.el deleted file mode 100644 index 5f769b7b..00000000 --- a/elpa/vertica-snippets-20200423.1200/vertica-snippets-autoloads.el +++ /dev/null @@ -1,32 +0,0 @@ -;;; vertica-snippets-autoloads.el --- automatically extracted autoloads -;; -;;; Code: - -(add-to-list 'load-path (directory-file-name - (or (file-name-directory #$) (car load-path)))) - - -;;;### (autoloads nil "vertica-snippets" "vertica-snippets.el" (0 -;;;;;; 0 0 0)) -;;; Generated autoloads from vertica-snippets.el - -(autoload 'vertica-snippets-initialize "vertica-snippets" "\ -Add snippet dir to yas-snippet-dirs and load it." nil nil) - -(eval-after-load 'yasnippet '(vertica-snippets-initialize)) - -(if (fboundp 'register-definition-prefixes) (register-definition-prefixes "vertica-snippets" '("vertica-snippets-dir"))) - -;;;*** - -;;;### (autoloads nil nil ("vertica-snippets-pkg.el") (0 0 0 0)) - -;;;*** - -;; Local Variables: -;; version-control: never -;; no-byte-compile: t -;; no-update-autoloads: t -;; coding: utf-8 -;; End: -;;; vertica-snippets-autoloads.el ends here diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/.dir-locals.el b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/.dir-locals.el similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/.dir-locals.el rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/.dir-locals.el diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/busy-hours b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/busy-hours similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/busy-hours rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/busy-hours diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/check_rle_overridden b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/check_rle_overridden similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/check_rle_overridden rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/check_rle_overridden diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/config-changes b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/config-changes similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/config-changes rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/config-changes diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/current_epoch b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/current_epoch similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/current_epoch rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/current_epoch diff --git a/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/dc_refresh_columns b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/dc_refresh_columns new file mode 100644 index 00000000..88005351 --- /dev/null +++ b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/dc_refresh_columns @@ -0,0 +1,7 @@ +# -*- mode: snippet -*- +# name: dc_refresh_columns +# key: dc_refresh_columns +# group: vertica +# expand-env: ((yas/indent-line 'auto) (yas/wrap-around-region 't)) +# -- +SELECT * FROM dc_refresh_columns where tablenames='$1' ORDER BY time DESC LIMIT 2;$0 \ No newline at end of file diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/errors b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/errors similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/errors rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/errors diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/external_table_details b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/external_table_details similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/external_table_details rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/external_table_details diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/format_numbers b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/format_numbers similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/format_numbers rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/format_numbers diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/get-partitions b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/get-partitions similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/get-partitions rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/get-partitions diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/get-projections b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/get-projections similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/get-projections rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/get-projections diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/grants b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/grants similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/grants rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/grants diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/last-statement-timing b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/last-statement-timing similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/last-statement-timing rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/last-statement-timing diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/last-vertica-updates b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/last-vertica-updates similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/last-vertica-updates rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/last-vertica-updates diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/licence-history b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/licence-history similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/licence-history rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/licence-history diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/list-backups b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/list-backups similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/list-backups rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/list-backups diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/list-tables-row-count-size b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/list-tables-row-count-size similarity index 64% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/list-tables-row-count-size rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/list-tables-row-count-size index 6cc9169c..4bf7ec7c 100644 --- a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/list-tables-row-count-size +++ b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/list-tables-row-count-size @@ -6,8 +6,8 @@ # -- SELECT tbl.table_schema AS "Schema Name", tbl.table_name AS "Table Name", - to_char(sum(prs.ros_row_count)/count(DISTINCT prs.projection_name), '999G999G999G999') AS "No Of Rows", - to_char(sum(prs.ros_used_bytes)/count(DISTINCT prs.projection_name), '999G999G999G999G999') AS "Size In Bytes" + to_char(sum(prs.row_count)/count(DISTINCT prs.projection_name), '999G999G999G999') AS "No Of Rows", + to_char(sum(prs.used_bytes)/count(DISTINCT prs.projection_name), '999G999G999G999G999') AS "Size In Bytes" FROM TABLES tbl JOIN projections prj ON tbl.table_id = prj.anchor_table_id JOIN projection_storage prs ON prj.projection_name = prs.projection_name diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/nodes b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/nodes similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/nodes rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/nodes diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/pool_queues b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/pool_queues similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/pool_queues rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/pool_queues diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/projection_storage b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/projection_storage similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/projection_storage rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/projection_storage diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/pset_footer b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/pset_footer similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/pset_footer rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/pset_footer diff --git a/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/qp_session b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/qp_session new file mode 100644 index 00000000..43836c70 --- /dev/null +++ b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/qp_session @@ -0,0 +1,18 @@ +# -*- mode: snippet -*- +# name: qp_session +# key: qp_session +# group: vertica +# expand-env: ((yas/indent-line 'auto) (yas/wrap-around-region 't)) +# https://www.vertica.com/kb/System-Tables-For-Performance/Content/BestPractices/System-Tables-For-Performance.htm +# -- +SELECT DATE_TRUNC('second',query_start::TIMESTAMP), + session_id, + transaction_id, + statement_id, + node_name, + LEFT(query,100) query, + ROUND((query_duration_us/1000000)::NUMERIC(10,3),3) duration_sec + FROM query_profiles + WHERE session_id = '$1' + AND query_duration_us > 60000000 + ORDER BY duration_sec DESC;$0 diff --git a/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/qp_slow b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/qp_slow new file mode 100644 index 00000000..3c436233 --- /dev/null +++ b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/qp_slow @@ -0,0 +1,18 @@ +# -*- mode: snippet -*- +# name: qp_slow +# key: qp_slow +# group: vertica +# expand-env: ((yas/indent-line 'auto) (yas/wrap-around-region 't)) +# https://www.vertica.com/kb/System-Tables-For-Performance/Content/BestPractices/System-Tables-For-Performance.htm +# -- +SELECT DATE_TRUNC('second',query_start::TIMESTAMP), + session_id, + transaction_id, + statement_id, + node_name, + LEFT(query,100), + ROUND((query_duration_us/1000000)::NUMERIC(10,3),3) duration_sec + FROM query_profiles + WHERE query ILIKE '%$1%' + AND query_start BETWEEN TIMESTAMPADD( HOUR, -4, STATEMENT_TIMESTAMP())::VARCHAR AND STATEMENT_TIMESTAMP()::VARCHAR + ORDER BY duration_sec DESC;$0 diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/query-acquisition-queue b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/query-acquisition-queue similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/query-acquisition-queue rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/query-acquisition-queue diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/query-event-issues b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/query-event-issues similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/query-event-issues rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/query-event-issues diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/query-long-acquisitions b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/query-long-acquisitions similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/query-long-acquisitions rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/query-long-acquisitions diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/query-requests b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/query-requests similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/query-requests rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/query-requests diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/query-requests-expensive b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/query-requests-expensive similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/query-requests-expensive rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/query-requests-expensive diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/query-requests-overview b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/query-requests-overview similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/query-requests-overview rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/query-requests-overview diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/query-times b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/query-times similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/query-times rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/query-times diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/rebalance_projection_status b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/rebalance_projection_status similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/rebalance_projection_status rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/rebalance_projection_status diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/rebalance_status b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/rebalance_status similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/rebalance_status rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/rebalance_status diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/rebalance_times b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/rebalance_times similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/rebalance_times rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/rebalance_times diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/resource-pool-move b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/resource-pool-move similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/resource-pool-move rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/resource-pool-move diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/resource_pool_status b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/resource_pool_status similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/resource_pool_status rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/resource_pool_status diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/resource_pool_status2 b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/resource_pool_status2 similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/resource_pool_status2 rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/resource_pool_status2 diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/resource_pools b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/resource_pools similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/resource_pools rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/resource_pools diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/resources b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/resources similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/resources rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/resources diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/ros_count b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/ros_count similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/ros_count rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/ros_count diff --git a/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/seg-keys b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/seg-keys new file mode 100644 index 00000000..7f50dde5 --- /dev/null +++ b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/seg-keys @@ -0,0 +1,15 @@ +# -*- mode: snippet -*- +# name: seg-keys +# key: sk_ +# group: vertica +# condition: (if (string-equal sql-product 'vertica)t) +# expand-env: ((yas/indent-line 'auto) (yas/wrap-around-region 't)) +# +# https://www.vertica.com/blog/determining-candidate-segmentation-keys-quick-tip/ +# +# -- +SELECT FLOOR(HASH(${1:Candidate-Keys-Separated-by-Comma})/((9223372036854775807/${2:Cluster-Node-Count}) + 1)) AS Node, + COUNT(*) AS row_count + FROM ${3:Table-Schema.Table-Name} + GROUP BY 1 + ORDER BY 1;$0 \ No newline at end of file diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/segmentation-islands1 b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/segmentation-islands1 similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/segmentation-islands1 rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/segmentation-islands1 diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/segmentation-islands2 b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/segmentation-islands2 similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/segmentation-islands2 rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/segmentation-islands2 diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/sessions b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/sessions similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/sessions rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/sessions diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/storage-containers b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/storage-containers similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/storage-containers rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/storage-containers diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/storage-locations b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/storage-locations similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/storage-locations rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/storage-locations diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/table_locks b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/table_locks similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/table_locks rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/table_locks diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/user_sessions b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/user_sessions similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/user_sessions rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/user_sessions diff --git a/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/varchar_column_check b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/varchar_column_check new file mode 100644 index 00000000..7588759b --- /dev/null +++ b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/varchar_column_check @@ -0,0 +1,17 @@ +# -*- mode: snippet -*- +# name: varchar_column_check +# key: varchar_column_check +# group: vertica +# condition: (if (string-equal sql-product 'vertica)t) +# expand-env: ((yas/indent-line 'auto) (yas/wrap-around-region 't)) +# -- +\t +SELECT 'SELECT columnname, MAX(MAX), SUM(data_type_length) AS data_type_length FROM (' AS query FROM dual +UNION ALL +SELECT 'SELECT ''' || COLUMN_NAME || ''' AS columnname, MAX(CHAR_LENGTH(' || COLUMN_NAME || ')), NULL AS data_type_length FROM $1.$2 UNION' AS query +FROM v_catalog.columns +WHERE table_schema = '$1' + AND TABLE_NAME = '$2' + AND data_type LIKE 'varchar%' + UNION ALL + SELECT 'SELECT COLUMN_NAME AS columnname, NULL AS MAX, data_type_length FROM v_catalog.columns WHERE table_schema = ''$1'' AND TABLE_NAME = ''$2'' AND data_type LIKE ''varchar%'' )a GROUP BY 1 ORDER BY 1;' AS query FROM dual;$0 diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/vertica_users b/elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/vertica_users similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/vertica_users rename to elpa/vertica-snippets-20231010.1104/snippets/sql-interactive-mode/vertica_users diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-mode/.yas-parents b/elpa/vertica-snippets-20231010.1104/snippets/sql-mode/.yas-parents similarity index 100% rename from elpa/vertica-snippets-20200423.1200/snippets/sql-mode/.yas-parents rename to elpa/vertica-snippets-20231010.1104/snippets/sql-mode/.yas-parents diff --git a/elpa/vertica-snippets-20231010.1104/vertica-snippets-autoloads.el b/elpa/vertica-snippets-20231010.1104/vertica-snippets-autoloads.el new file mode 100644 index 00000000..1f7dfd1c --- /dev/null +++ b/elpa/vertica-snippets-20231010.1104/vertica-snippets-autoloads.el @@ -0,0 +1,31 @@ +;;; vertica-snippets-autoloads.el --- automatically extracted autoloads (do not edit) -*- lexical-binding: t -*- +;; Generated by the `loaddefs-generate' function. + +;; This file is part of GNU Emacs. + +;;; Code: + +(add-to-list 'load-path (or (and load-file-name (directory-file-name (file-name-directory load-file-name))) (car load-path))) + + + +;;; Generated autoloads from vertica-snippets.el + +(autoload 'vertica-snippets-initialize "vertica-snippets" "\ +Add snippet dir to yas-snippet-dirs and load it.") +(eval-after-load 'yasnippet '(vertica-snippets-initialize)) +(register-definition-prefixes "vertica-snippets" '("vertica-snippets-dir")) + +;;; End of scraped data + +(provide 'vertica-snippets-autoloads) + +;; Local Variables: +;; version-control: never +;; no-byte-compile: t +;; no-update-autoloads: t +;; no-native-compile: t +;; coding: utf-8-emacs-unix +;; End: + +;;; vertica-snippets-autoloads.el ends here diff --git a/elpa/vertica-snippets-20200423.1200/vertica-snippets-pkg.el b/elpa/vertica-snippets-20231010.1104/vertica-snippets-pkg.el similarity index 61% rename from elpa/vertica-snippets-20200423.1200/vertica-snippets-pkg.el rename to elpa/vertica-snippets-20231010.1104/vertica-snippets-pkg.el index 683f2a74..0c869bf2 100644 --- a/elpa/vertica-snippets-20200423.1200/vertica-snippets-pkg.el +++ b/elpa/vertica-snippets-20231010.1104/vertica-snippets-pkg.el @@ -1,6 +1,8 @@ -(define-package "vertica-snippets" "20200423.1200" "Yasnippets for Vertica" +(define-package "vertica-snippets" "20231010.1104" "Yasnippets for Vertica" '((yasnippet "0.6.1")) - :commit "6ced718d9120878878700592fab430a8542b748f" :authors + :commit "6f0df19d36a9670484e84b347716f305301359ad" :authors + '(("Andreas Gerler" . "baron@bundesbrandschatzamt.de")) + :maintainers '(("Andreas Gerler" . "baron@bundesbrandschatzamt.de")) :maintainer '("Andreas Gerler" . "baron@bundesbrandschatzamt.de") diff --git a/elpa/vertica-snippets-20200423.1200/vertica-snippets.el b/elpa/vertica-snippets-20231010.1104/vertica-snippets.el similarity index 100% rename from elpa/vertica-snippets-20200423.1200/vertica-snippets.el rename to elpa/vertica-snippets-20231010.1104/vertica-snippets.el -- 2.47.3