Changeset 43ec19ac079e004379a4c8d8117756c8d622eff8 for sql

Timestamp:

09/25/08 01:18:36 (5 years ago)

Author:

Denish Patel <denish@omniti.com>

git-committer:

Denish Patel <denish@omniti.com> 1222305516 +0000

git-parent:

[cbb1d8e025f39b356b154b10978d5c4139ad52db]

git-author:

Denish Patel <denish@omniti.com> 1222305516 +0000

Message:

added index

Files:

• sql/reconnoiter_ddl_dump.sql (modified) (4 diffs)

sql/reconnoiter_ddl_dump.sql

@@ -1149 +1149 @@
-ref_hostname text;
-ref_metric_name text;
+ref_alias text;
-v_ts_search_all tsvector;
-BEGIN
@@ -1170 +1171 @@
-     WHERE module='dns' AND s.name='in-addr.arpa' AND target = ref_target;
-
+    SELECT mt.value INTO ref_alias
+      FROM stratcon.current_metric_text mt
+      JOIN stratcon.mv_loading_dock_check_s s USING(sid)
+     WHERE s.module='snmp' AND mt.name='alias' AND s.sid=in_sid;
+
-    ref_hostname := coalesce(replace(ref_hostname, '.', ' '), ' ');
-    ref_metric_name := regexp_replace(in_metric_name, E'[_\`/.\\134]', ' ', 'g');
+    ref_alias := coalesce(regexp_replace(ref_alias, E'[_\`/.\\134]', ' ', 'g'), ' ');
-
-    v_ts_search_all=to_tsvector(ref_metric_name || ' ' ||
@@ -1178 +1185 @@
-                                ref_target || ' ' ||
-                                ref_hostname || ' ' ||
+                                ref_alias || ' ' ||
-                                ref_tags);
-    RETURN v_ts_search_all;
@@ -2202 +2210 @@
-
---
+-- Name: idx_metric_name_summary_ts_search_all; Type: INDEX; Schema: stratcon; Owner: reconnoiter; Tablespace: 
+--
+
+CREATE INDEX idx_metric_name_summary_ts_search_all ON metric_name_summary USING btree (ts_search_all);
+
+
+--
--- Name: idx_mv_loading_dock_check_s_module; Type: INDEX; Schema: stratcon; Owner: reconnoiter; Tablespace: 
---