From: | Jean Baro <jfbaro(at)gmail(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Continuous Performance Test |
Date: | 2019-08-14 16:18:29 |
Message-ID: | CA+fQeenoiMsgHMtKcJxEnccmQzrpXzFjCkJPHqUFaJXf7Oz-vQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hello!
I was wondering if there is any external tool or extention to PostgreSQL >
10 (EC2 or RDS) which would:
- Collect the TOP X statements (queries or DML) used in the last Y days
IN PRODUCTION;
- Everytime there is a change in the DATABASE Structure (Migrations,
properties, Tables, Indexes) run these TOP X statements against a
PERFORMANCE TEST DATABASE (Which would be very similar to production, on
both HARDWARE and DATABASE SIZE)
- Collect the metrics for these tests
- Plot the results over time so that the PRODUCT team can be sure how
the performance of the DATABASE is being affected by the chances over time
(also as the number of rows changes). Something like this:
[image: image.png]
Query vs new change to the DATABASE (+ its size). So that we can see which
migration affect the database the most.
Is there such a thing? It doesn't need to be open source nor free. But it
would be good if it is :)
If the answer is "NO", would it be possible to create such a tool and make
it available as OOS? I think so, but I would need some professional help
(and would pay for this).
Thanks
From | Date | Subject | |
---|---|---|---|
Next Message | Jean Baro | 2019-08-14 17:56:15 | Continuous Performance Test |
Previous Message | Adrian Klaver | 2019-08-14 14:13:43 | Re: ORA-24345: A Truncation or null fetch error occurred -ora2pg |