This is an automated email from the ASF dual-hosted git repository.
lhotari pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/pulsar-manager.git
The following commit(s) were added to refs/heads/master by this push:
new 672863e Create Index on topics_stats to fix tenants tab latency (#420)
672863e is described below
commit 672863e1a8cdbfc9b392e1b676b48507cd9f6d9d
Author: Sourabh Agrawal <[email protected]>
AuthorDate: Thu Apr 4 13:16:20 2024 +0530
Create Index on topics_stats to fix tenants tab latency (#420)
* Create Index on topics_stats to fix tenants tab latency
* Trigger Build
---
src/main/resources/META-INF/sql/postgresql-schema.sql | 2 ++
1 file changed, 2 insertions(+)
diff --git a/src/main/resources/META-INF/sql/postgresql-schema.sql
b/src/main/resources/META-INF/sql/postgresql-schema.sql
index 40d1d32..3376023 100644
--- a/src/main/resources/META-INF/sql/postgresql-schema.sql
+++ b/src/main/resources/META-INF/sql/postgresql-schema.sql
@@ -46,6 +46,8 @@ CREATE TABLE IF NOT EXISTS topics_stats (
time_stamp BIGINT
);
+CREATE INDEX IF NOT EXISTS ix_topics_stats_timestamp on
topics_stats(time_stamp);
+
CREATE TABLE IF NOT EXISTS publishers_stats (
publisher_stats_id BIGSERIAL PRIMARY KEY,
producer_id BIGINT,
