Definitions More Info.
Definition ID	840
Title	POSTGRESQL
Category	NOTES
Definition	Vacuum and analayse tables script
Definition Description	SELECT 'VACUUM (VERBOSE, ANALYZE)' || '"' || schemaname || '"' || '.' || '"' || relname || '"' || ';' FROM pg_stat_all_tables WHERE n_dead_tup <> 0 ORDER BY n_dead_tup DESC;
RecordBy	cunay
Record Date	06-06-2018 13:19:14
Düzenle
Kopyala
Sil