Jira (PDB-5596) Audit index usage

0 views
Skip to first unread message

Austin Blatt (Jira)

unread,
Feb 16, 2023, 11:47:02 AM2/16/23
to puppe...@googlegroups.com
Austin Blatt created an issue
 
PuppetDB / Task PDB-5596
Audit index usage
Issue Type: Task Task
Assignee: Unassigned
Created: 2023/02/16 8:46 AM
Priority: Normal Normal
Reporter: Austin Blatt
Add Comment Add Comment
 
This message was sent by Atlassian Jira (v8.20.11#820011-sha1:0629dd8)
Atlassian logo

Austin Blatt (Jira)

unread,
Feb 16, 2023, 3:06:03 PM2/16/23
to puppe...@googlegroups.com
Austin Blatt updated an issue
Change By: Austin Blatt
Our indexes have accumulated over time, and some may not be necessary anymore. In addition to our own reasoning, and checking the git history for why they were added, we can get index usage statistics out Postgres from data gathered by PE support scripts to see which indexes are used most at customer sites. We should be sure to get scripts from multiple customers because their usage of PuppetDB may differ.

Austin Blatt (Jira)

unread,
Feb 16, 2023, 3:07:03 PM2/16/23
to puppe...@googlegroups.com
Austin Blatt updated an issue
Our indexes have accumulated over time, and some may not be necessary anymore. In addition to our own reasoning, and checking the git history for why they were added, we can get index usage statistics out Postgres from data gathered by PE support scripts to see which indexes are used most at customer sites. We should be sure to get scripts from multiple customers because their usage of PuppetDB may differ.

Create tickets to remove any indexes we no longer need /want

Austin Blatt (Jira)

unread,
Feb 16, 2023, 3:07:03 PM2/16/23
to puppe...@googlegroups.com
Austin Blatt updated an issue
 
PuppetDB / Task PDB-5596
Audit index usage
Change By: Austin Blatt
Our indexes have accumulated over time, and some may not be necessary anymore. In addition to our own reasoning, and checking the git history for why they were added, we can get index usage statistics out Postgres from data gathered by PE support scripts to see which indexes are used most at customer sites. We should be sure to get scripts from multiple customers because their usage of PuppetDB may differ.

Create tickets to remove any indexes we no longer need
Reply all
Reply to author
Forward
0 new messages