Comments (3)
Hi,
The example queries are currently stored in regular shared memory, so it has to be a fixed size. You can control the maximum size using the regular postgres configuration option `track_activity_query_size'. But keep in mind that it will greatly increase memory consumption.
That being said, I don't know what implementation you're using but I would recommend to use the global index adviser implemented in pg_qualstats itself. See for instance https://rjuju.github.io/postgresql/2020/01/06/pg_qualstats-2-global-index-advisor.html for more details about its approach and how to use it.
from pg_qualstats.
Thank you for the guidance.
I am using the index advisor but need some custom code around it as it suggests (or seems to) indexes that would cause duplication of primary/foreign key/ and other indexes already in place.
pg_qualstats is a great help in the quest to get indexes right 👍
from pg_qualstats.
Thanks.
Yes, it doesn't seem surprising that (partially) redundant indexes can be suggested, at least for the adviser in pg_qualstats.
I will try to implement such a check as soon as I have time for that, but note that even if (partially) redundant indexes were not suggested, you would still need to validate the suggestion and decide if the related queries are important enough to justify adding a new index, or if an index is the best solution to the query problem.
The tool is only designed to help users concentrate on that part, and avoid wasting time on coming up with possible index.
from pg_qualstats.
Related Issues (20)
- pg_qualstats_indexes usage post 2.0 HOT 2
- Detect columns with dependencies and suggest to create extended statistics on it HOT 1
- [Doc] ALTER EXTENSION UPDATE fails HOT 4
- version 2.0.2 has no update path from version "1.0.7" and could not find function "pg_qualstats_2_0" in file HOT 2
- Support for Citus HOT 2
- PostgreSQL 14 support HOT 3
- can you make a setup for pg12 on windows systems? HOT 19
- pg_qualstats_example_query() and queries() don't fill in all the predicate values HOT 1
- different utf8const handling HOT 4
- cppcheck find bug HOT 2
- set-valued function called in context that cannot accept a set HOT 1
- multi node stat collection HOT 5
- Provide context for index advice HOT 4
- ERROR: there is no parameter $1 when i try execute the function. HOT 3
- pg_qualstats_index_advisor functionality HOT 14
- pg_qualstats_index_advisor index within JSON HOT 1
- PG15 binary for Windows HOT 2
- PG16 binary for Windows HOT 3
- Dereference after null HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from pg_qualstats.