Database at a glance

[VaderHaze]

Is there a way to analyze my database at a glance.

Meaning a way to sum up the 100's of thousands of hands it has.


A way to determine if the math adds up?


I thought that "Vacuum analyze database" would be the way to go but I guess it does something else?.

[_Loki_]

###
Hi VaderHaze - At a glance ? No chance

###
You're right about vacuum analyse:
FAQ - Hold'em Manager Poker Tracking Software :: Vacuum Analyze Database (http://faq.holdemmanager.com/questions/88/Vacuum+Analyze+Database+)
'ANALYZE' collects statistics about the contents of tables in the database, and stores the results. After that postgreSQL uses these statistics to help determine the most efficient execution plans for queries. In simple terms it's part of making your DB more efficient in accessing data

###
This is most of what you want but it's not 'at a glance':
FAQ - Hold'em Manager Poker Tracking Software :: Check Total Amount of Hands in Database (http://faq.holdemmanager.com/questions/115/Check+Total+Amount+of+Hands+in+Database+)
[see especially the extra queries at the bottom]

###