![]() ![]() RANK() OVER (PARTITION BY pid ORDER BY a. The second run of the load is 10 second which is 4x faster than the first and all the wait for io/auroraredologflush is gone. ![]() Finally there is a 10 second wide spike representing the workload with autocommit off and waiting mainly on io/aurorarespondtoclient. This example shows current and the top three (3) cumulative wait type and wait events for allĪctive sessions ( pg_stat_activity state 'idle') excluding current session After that there is a 20 second idle gap while the script sleeps. +-+-+-+-+-+-+-+-+-ģ0099 | postgres | pgbench | Lock | transactionid | active | LWLock | wal_insert | 1937 | 29975ģ0099 | postgres | pgbench | Lock | transactionid | active | LWLock | buffer_content | 22903 | 760498ģ0099 | postgres | pgbench | Lock | transactionid | active | LWLock | lock_manager | 10012 | 223207ģ0099 | postgres | pgbench | Lock | transactionid | active | Lock | tuple | 20315 | 63081529ģ0099 | postgres | pgbench | Lock | transactionid | active | IO | WALWrite | 93293 | 237440ģ0099 | postgres | pgbench | Lock | transactionid | active | IO | XactSync | 13010 | 19525143ģ0100 | postgres | pgbench | Lock | transactionid | active | LWLock | ProcArrayLock | 6 | 53ģ0100 | postgres | pgbench | Lock | transactionid | active | LWLock | wal_insert | 1913 | 25450ģ0100 | postgres | pgbench | Lock | transactionid | active | LWLock | buffer_content | 22874 | 778005ģ0109 | postgres | pgbench | IO | XactSync | active | LWLock | ProcArrayLock | 3 | 71ģ0109 | postgres | pgbench | IO | XactSync | active | LWLock | wal_insert | 1940 | 27741ģ0109 | postgres | pgbench | IO | XactSync | active | LWLock | buffer_content | 22962 | 776352ģ0109 | postgres | pgbench | IO | XactSync | active | LWLock | lock_manager | 9879 | 218826ģ0109 | postgres | pgbench | IO | XactSync | active | Lock | tuple | 20401 | 63581306ģ0109 | postgres | pgbench | IO | XactSync | active | Lock | transactionid | 50769 | 211645008ģ0109 | postgres | pgbench | IO | XactSync | active | Client | ClientRead | 89901 | 44192439 NATURAL JOIN aurora_stat_wait_event() we pid | usename | app_name | current_wait_type | current_wait_event | current_state | wait_type | wait_event | waits | wait_time Coalesce(wait_event_type,'CPU') AS current_wait_type,Ĭoalesce(wait_event,'CPU') AS current_wait_event, Most of the time (92 of pgstatactivity samples) my session is not on a wait event, which means running in CPU.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |