search

powa-team / powa

PostgreSQL Workload Analyzer
http://powa.readthedocs.io/
PostgreSQL License
778 stars 57 forks source link

Powa and postgres read-only slave. #38

Closed pavelbrm closed 6 years ago

pavelbrm commented 10 years ago

Hi. My setup - postgresql master and slave (one at this time). Powa gathering stats from master, writing stats to the powa database. But most of read queries runs on slave, and I want to get stats about those queries too.

Any suggestions?

marco44 commented 10 years ago

We have nothing for now to collect on the slave... as we need a database to store data.

mtrofimm commented 9 years ago

would it be possible to define a different postgres cluster for powa to store data?

rdunklau commented 9 years ago

Its not possible at the moment, but at patch for such an addition would most definitely be welcome. Its not at the top of our priority list though...