Re: pgpgout/s without swapping--what does it mean? - Mailing list pgsql-general
| From | rahulraveendran |
|---|---|
| Subject | Re: pgpgout/s without swapping--what does it mean? |
| Date | |
| Msg-id | 1443519271064-5867809.post@n5.nabble.com Whole thread Raw |
| In response to | pgpgout/s without swapping--what does it mean? (Kevin Goess <kgoess@bepress.com>) |
| List | pgsql-general |
Hi , Me too have the same issue on PosgreSQL server. pgpgout/s is going high and the same time didn't observe any swapping or memory pressure on the host. Please refer below sar O/P. 12:00:01 PM pgpgin/s pgpgout/s fault/s majflt/s pgfree/s pgscank/s pgscand/s pgsteal/s %vmeff 12:10:01 PM 0.00 4.16 114.55 0.00 106.62 0.00 0.00 0.00 0.00 12:20:01 PM 0.00 3.94 38.37 0.00 57.85 0.00 0.00 0.00 0.00 12:30:01 PM 7.63 4.65 206.51 0.07 108.31 0.00 0.00 0.00 0.00 12:40:01 PM 3.08 4.99 110.57 0.02 93.15 0.00 0.00 0.00 0.00 12:50:01 PM 0.39 4.43 133.92 0.00 88.53 0.00 0.00 0.00 0.00 01:00:01 PM 0.00 4.93 134.93 0.00 88.07 0.00 0.00 0.00 0.00 01:10:01 PM 17.10 20652.46 233.39 0.18 14035.87 4165.03 0.00 4164.51 99.99 01:20:01 PM 9.37 15831.25 140.93 0.13 11912.22 4116.36 0.00 4116.36 100.00 01:30:01 PM 15.40 19688.21 164.96 0.18 14261.36 4938.36 0.00 4938.32 100.00 01:40:01 PM 11.52 11529.86 149.57 0.12 8133.76 2784.77 0.00 2784.77 100.00 01:50:01 PM 9.16 12416.42 140.14 0.13 8890.65 3057.49 0.00 3057.49 100.00 02:00:01 PM 12.19 9076.26 142.05 0.11 6756.87 2320.05 1.88 2321.92 100.00 02:10:01 PM 14.29 12839.23 219.15 0.17 9501.58 3257.99 0.00 3257.99 100.00 02:20:01 PM 12.78 10694.65 145.12 0.11 8268.03 2465.23 0.00 2465.23 100.00 02:30:01 PM 5.79 4.93 140.92 0.03 94.61 0.00 0.00 0.00 0.00 02:40:01 PM 0.06 4.57 147.94 0.00 109.82 0.00 0.00 0.00 0.00 02:50:01 PM 4.94 5.11 140.54 0.03 94.58 0.00 0.00 0.00 0.00 03:00:01 PM 0.00 4.92 138.82 0.00 94.25 0.00 0.00 0.00 0.00 03:10:01 PM 7.66 7.84 267.43 0.12 177.26 0.00 0.00 0.00 0.00 03:20:01 PM 0.00 4.57 138.89 0.00 94.06 0.00 0.00 0.00 0.00 03:30:01 PM 0.00 4.85 140.98 0.00 95.61 0.00 0.00 0.00 0.00 03:40:01 PM 0.00 4.54 148.36 0.00 110.78 0.00 0.00 0.00 0.00 03:50:01 PM 0.00 4.51 137.96 0.00 93.90 0.00 0.00 0.00 0.00 04:00:01 PM 0.00 5.08 143.63 0.00 95.18 0.00 0.00 0.00 0.00 04:10:01 PM 22.53 50746.42 230.90 0.22 35820.37 18562.07 0.00 11605.90 62.52 04:20:01 PM 23.93 60429.47 136.53 0.19 43166.45 22012.66 0.00 14525.16 65.99 04:30:01 PM 17.97 3110.80 140.26 0.10 2822.69 1505.53 0.00 601.17 39.93 And also observed that during this time . there some rsync jobs started by pgsql and consuming CPU resources. % CPU PID 30.8 10452 sshd 24.9 10454 rsync 3.0 10455 flush-253:2 postgres 10452 30.8 0.1 104372 6256 ? S 16:00 6:02 sshd: postgres@notty postgres 10453 0.0 0.0 110512 1496 ? Ss 16:00 0:00 rsync --server -logDtpre.iLs . /backup/ARCHIVELOGS/CLUSTER1 postgres 10454 24.9 0.0 110772 1056 ? S 16:00 4:53 rsync --server -logDtpre.iLs . /backup/ARCHIVELOGS/CLUSTER1 root 10455 3.0 0.0 0 0 ? S 16:00 0:35 [flush-253:2] VM stat . procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu----- r b swpd free buff cache si so bi bo in cs us sy id wa st 2 1 15704 173136 234692 5197108 0 0 167 4141 1 1 3 2 93 2 0 0 1 15704 120684 234692 5250312 0 0 0 242356 4374 3450 18 17 25 39 0 1 0 15704 131224 234688 5247532 0 0 0 102396 5525 2630 22 17 45 16 0 2 0 15704 159744 234688 5219992 0 0 0 56 3809 2555 17 10 74 0 0 1 0 15704 157636 234688 5221132 0 0 0 172 6719 4522 26 16 58 0 0 Can anyone suggest how to get rid of this pageout alert. -- View this message in context: http://postgresql.nabble.com/pgpgout-s-without-swapping-what-does-it-mean-tp5796346p5867809.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
pgsql-general by date: