Commite17bd10

committed

Removed skipping indexes with estimated bloat < 10%

1 parent0ac3842 commite17bd10Copy full SHA for e17bd10

File tree

-8

lines changed

-8

lines changed

Lines changed: 4 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -11,7 +11,7 @@ A complete PostgreSQL monitoring solution with automated performance analysis an`
`11`	`11`
`12`	`12`	`Database:`
`13`	`13`	`- Supports PostgreSQL versions 14-17`
`14`		`--pg_stat_statements extension must beenabled forquery performance monitoring`
	`14`	`+-pg_stat_statements extension must becreated fordb used for connection`
`15`	`15`
`16`	`16`	`##⚠️ Security Notice`
`17`	`17`
`@@ -75,14 +75,16 @@ curl -o postgres_ai https://gitlab.com/postgres-ai/postgres_ai/-/raw/main/postgr`
`75`	`75`	`&& chmod +x postgres_ai`
`76`	`76`	```
`77`	`77`
`78`		-Now, start it and wait for a few minutes.Get a Postgres AI access token for your organizationathttps://console.postgres.ai (`Your org name → Manage → Access tokens`):
	`78`	+Now, start it and wait for a few minutes.To obtain Postgres AI access token for your organizationvisithttps://console.postgres.ai (`Your org name → Manage → Access tokens`):
`79`	`79`
`80`	`80`	```bash
`81`	`81`	`# Production setup with your Access token`
`82`	`82`	`./postgres_ai quickstart --api-key=your_access_token`
`83`	`83`	```
`84`	`84`	`Note: You can also add your database instance in the same command:`
	`85`	+```bash
`85`	`86`	`./postgres_ai quickstart --api-key=your_access_token --add-instance="postgresql://user:pass@host:port/db"`
	`87`	+```
`86`	`88`
`87`	`89`	`Or if you want to just check out how it works:`
`88`	`90`	```bash

Lines changed: 4 additions & 6 deletions

Original file line number	Diff line number	Diff line change
`@@ -764,13 +764,11 @@ def generate_f005_btree_bloat_report(self, cluster: str = "local", node_name: st`
`764`	`764`	`total_bloat_size=0`
`765`	`765`
`766`	`766`	`forindex_datainbloated_indexes.values():`
`767`		`-# Skip indexes with minimal bloat`
`768`		`-ifindex_data['bloat_pct']>=10:# Only report indexes with >= 10% bloat`
`769`		`-index_data['extra_size_pretty']=self.format_bytes(index_data['extra_size'])`
`770`		`-index_data['bloat_size_pretty']=self.format_bytes(index_data['bloat_size'])`
	`767`	`+index_data['extra_size_pretty']=self.format_bytes(index_data['extra_size'])`
	`768`	`+index_data['bloat_size_pretty']=self.format_bytes(index_data['bloat_size'])`
`771`	`769`
`772`		`-bloated_indexes_list.append(index_data)`
`773`		`-total_bloat_size+=index_data['bloat_size']`
	`770`	`+bloated_indexes_list.append(index_data)`
	`771`	`+total_bloat_size+=index_data['bloat_size']`
`774`	`772`
`775`	`773`	`# Sort by bloat percentage descending`
`776`	`774`	`bloated_indexes_list.sort(key=lambdax:x['bloat_pct'],reverse=True)`

Comments

(0)