PGCon2016 - 20180510
PGCon 2016
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Ronan Dunklau |
| Schedule | |
|---|---|
| Day | Talks - Day 2 - 2016-05-20 |
| Room | DMS 1120 |
| Start time | 14:00 |
| Duration | 00:45 |
| Info | |
| 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.