This tool can be used to verify if all tables involved in a query have optimal statistics. When a query is running slower than expected, it is possible that outdated or invalid statistics on the tables involved in the query are causing the slowness. This can happen if new data has been loaded into the table but
analyze was never executed, so the database is using wrong statistics when generating the query plan.
**gpmt** **gpstatscheck** -f QUERYFILE [-p PORT] [-d DATABASE\]
Execute the query in
query1.sql in database
Postgres and check for missing stats.
gpmt gpstatscheck -f query1.sql -d postgres
If invalid statistics are detected the tool will generate a script listing the suggested commands to run. For example:
$ cat gpstatscheck_20160926_134946.sql ANALYZE public.nums;
You can then run the provided script against the affected database:
$ psql -p 5432 -d postgres -f gpstatscheck_20160926_134946.sql