3 ms·
Not natively. There is pg_store_plans [0] which I haven’t used, but looks interesting. Most of the time, query flips are due to inaccurate statistics over time
by sgarland 3y ago
Not natively. There is pg_store_plans [0] which I haven’t used, but looks interesting.
Most of the time, query flips are due to inaccurate statistics over time. Try changing the default statistics target for the affected column.
[0]: https://github.com/ossc-db/pg_store_plans https://github.com/ossc-db/pg_store_plans