PGCon2016 - 20180510

PGCon 2016
The PostgreSQL Conference

Ronan Dunklau
Day Talks - Day 2 - 2016-05-20
Room DMS 1120
Start time 14:00
Duration 00:45
ID 951
Event type Lecture
Track DBA
Language used for presentation English

PoWA 3: towards a computer assisted DBA

My brand new application is damn slow, what have I done wrong ? How much faster would be my production if someone would take some time to check all the missing index ? And by the way, how many I have missed ? If any of these questione rings a bell, you may be interested in PoWA version 3.

Featuring new dedicated performance analysis extensions like pgqualstats, pgstatkcache and hypopg and famous ones like pgstat_statements, PoWA can tell you what's slow, when it's slow and why it's slow with just a few clicks. And of course, it'll suggest you a solution, providing indexes are part of the solution !

Unlike other tools, PoWA provides a global workload index suggestion feature, discovering pattern on your data usage, and is able to check its suggestions against the optimizer.

In detail, we will present the various tools making the PoWA stack, and how they truly shine when used together. This will include:

  • presentation of pgqualstats, pgstat_kcache, hypopg
  • presentation of powa-archivist, the stats aggregator
  • use cases where PoWA can provide exactly the kind of information that is hard to reach for the DBA
  • how does the global workload index suggestion works
  • future developments, and where this will take us.