These are chat archives for ManageIQ/manageiq/performance
@psuriset that list of unused indexes looks pretty big / depressing
after you enabled the
pg_stat extension, what backend workloads did you run through the app?
Did you run a script to exercise the ui as well?
just trying to figure out which ones are false positives.
Thanks for running this
@psuriset what does this say?
Some user procedures does not have custom cost and rows settings :
sysctl -pto reload it.
This will disable memory overcommitment and avoid postgresql killed by OOM killer.
Configure your system to use noop or deadline io scheduler when on virtual machines :smile:
echo deadline > /sys/block/sdX/queue/scheduler
- update your kernel parameters line with
elevator=deadlineto keep this parameter at next reboot
pg_stat_statementsis not enabled. Does that mean if the query is quicker than
log_min_duration_statementthat it will not mark that an index as used?