AW: Load test - Mailing list pgsql-admin

I am a newbie, just sharing what I have learnt so far.

Try creating queries on pg_stat_activity and run them periodically during the load test to get the metrics. ( Maybe append to a CSV file that you can import into excel and analyze later ) .

If you store sufficient pg_stat_statement ( based on your pg_stat_statement.max value in your conf file ) , you may be able analyze more details after the load test is done.

Clean up your pg_stat_statement

select pg_stat_statements_reset();

Set the parm to a higher value than the number of SQLs you expect to run during the load test.  Restart your instance.

Let the load test finish.

Look into your pg_stat_statements for all kinds of beautiful metrics.

Clean up your pg_stat_statements if not needed anymore, reset your max value and restart the instance.

You can build on some basic queries like this

SELECT pid,

       backend_type

FROM   pg_stat_activity

ORDER BY pid, backend_type ;

SELECT pid,

       usename,

       datname,

       client_addr,

       application_name,

       state,

       wait_event_type,

       wait_event,

       backend_start,

       query_start,

       now() - query_start AS runtime,

       query

FROM pg_stat_activity

WHERE state = 'active'

ORDER BY runtime DESC;

SELECT pid,

       now() - query_start AS duration,

       usename,

       query

FROM pg_stat_activity

WHERE state = 'active'

  AND now() - query_start > interval '10 seconds'

ORDER BY duration DESC;

~

Freundliche Grüße

i. A. Ramachandran Subramanian

Zentralbereich Informationstechnologie

Alte Leipziger Lebensversicherung a. G.

Hallesche Krankenversicherung a. G.

______________________

ALH Gruppe
Alte Leipziger-Platz 1, 61440 Oberursel
Tel: +49 (6171) 66-4882
Fax: +49 (6171) 66-800-4882
E-Mail: ramachandran.subramanian@alte-leipziger.de
www.alte-leipziger.de
www.hallesche.de

Alte Leipziger Lebensversicherung a. G., Alte Leipziger-Platz 1, 61440 Oberursel

Vors. des Aufsichtsrats: Dr. Walter Botermann · Vorstand: Christoph Bohn (Vors.), Dr. Jürgen Bierbaum (stv. Vors.), Frank Kettnaker, Dr. Jochen Kriegmeier, Alexander Mayer, Christian Pape, Wiltrud Pekarek, Udo Wilcsek

Sitz Oberursel (Taunus) · Rechtsform VVaG · Amtsgericht Bad Homburg v. d. H. HRB 1583 · USt.-IdNr. DE 114106814

Hallesche Krankenversicherung a. G., Löffelstraße 34-38, 70597 Stuttgart

Vors. des Aufsichtsrats: Dr. Walter Botermann · Vorstand: Christoph Bohn (Vors.), Dr. Jürgen Bierbaum (stv. Vors.), Frank Kettnaker, Dr. Jochen Kriegmeier, Alexander Mayer, Christian Pape, Wiltrud Pekarek, Udo Wilcsek

Sitz Stuttgart · Rechtsform VVaG · Amtsgericht Stuttgart HRB 2686 · USt.-IdNr. DE 147802285

Beiträge zu privaten Kranken- und Pflegekrankenversicherungen unterliegen nicht der Versicherungsteuer (§ 4 (1) Nr. 5 b VersStG) · Versicherungsleistungen sowie Umsätze aus Versicherungsvertreter-/Maklertätigkeiten sind umsatzsteuerfrei

Pflichtangaben der ALH Gruppe gemäß § 35a GmbHG bzw. § 80 AktG