statistics Archives

Is sys.stats_columns incorrect?

By adminPosted on October 1, 2023

Question : Let’s say I have a table Foo with columns ID1, ID2 and a composite primary key defined over […]

By adminPosted on September 25, 2023

Question : In MS SQL Server 2005, how can I extract statistical information about NULL fraction (or NULL count) for […]

By adminPosted on September 19, 2023

Question : I am working with pg_stat_activity in postgres. It is working and I can see queries in this view […]

By adminPosted on September 17, 2023

Question : I hope you guys can help me here. Our application polls a message table every 3 seconds looking […]

By adminPosted on September 16, 2023

Question : I have question about query planner in PostgreSQL. I know, that this planner is taking data from pg_statistics, […]

By adminPosted on September 9, 2023

Question : We are using dbms_datapump to copy data between different servers or to setup new schemas quickly. However importing […]

By adminPosted on September 3, 2023

Question : Hi I have been working on a script to update statistics of all tables on all my DBs. […]

By adminPosted on September 3, 2023

Question : I know I can reset some counters by running: select pg_stat_reset() but some counters like xact_commit aren’t reset. […]

By adminPosted on August 19, 2023

Question : We have this problem in our production environment. Microsoft SQL Server 2008 R2 (SP1) – 10.50.2500.0 (X64) – […]

By adminPosted on August 14, 2023

Question : I’m administering a server where a tool using a PostgreSQL runs. The tool takes care of most PostgreSQL […]