Re: Sudden drop in DBb performance

Поиск
Список
Период
Сортировка
От Gerhard Wohlgenannt
Тема Re: Sudden drop in DBb performance
Дата
Msg-id 4E65E01D.9020305@ai.wu.ac.at
обсуждение исходный текст
Ответ на Re: Sudden drop in DBb performance  ("Tomas Vondra" <tv@fuzzy.cz>)
Ответы Re: Sudden drop in DBb performance  ("Tomas Vondra" <tv@fuzzy.cz>)
Список pgsql-performance
> That's why I love dstat, just do this
>
> $ dstat -C 0,1,2,3,4,5,6,7
>
> and you know all you need.

dstat looks like a very nice tool, results below ..
(now the system load seems a bit lower then before when generating
results for vmstat and iostat)
>> Good catch, thanks Scott.
> Yes, good catch.
>
> Still, this does not explain why the queries were running fast before, and
> why the RAID array is so sluggish. Not to mention that we don't know what
> were the conditions when collecting those numbers (were the VMs off or
> running?).
>
the VMs were running. they are in something like production use, so i
shouldn't just turn them off ..  :-)
and the processes in the VMs cause a big portion of the DB load, so
turning them off would distort the results ...

and thanks again for all the replies!!! :-)


~# dstat -C 0,1,2,3,4,5,6,7

-------cpu0-usage--------------cpu1-usage--------------cpu2-usage--------------cpu3-usage--------------cpu4-usage--------------cpu5-usage--------------cpu6-usage--------------cpu7-usage------

-dsk/total- -net/total- ---paging-- ---system--
usr sys idl wai hiq siq:usr sys idl wai hiq siq:usr sys idl wai hiq
siq:usr sys idl wai hiq siq:usr sys idl wai hiq siq:usr sys idl wai hiq
siq:usr sys idl wai hiq siq:usr sys idl wai hiq siq| read  writ| recv
send|  in   out | int   csw
   7   1  75  17   0   0:  4   5  84   7   0   0:  5   3  80  12   0
0:  4   3  85   9   0   0:  7   2  75  16   0   0:  4   2  87   8   0
0:  7   2  75  16   0   0:  4   1  87   8   0   0|5071k 2578k|   0     0
|9760B 9431B|2468  4126
   0   0  98   2   0   0:  0   0  98   2   0   0:  6   2  22  71   0
0:  5   0  76  19   0   0:  0  12  82   6   0   0:  3   7  88   2   0
0:  3   1  84  12   0   0:  2   0  94   4   0   0|5160k 1376k|  60k
225k|   0     0 |2101  3879
  11   1  84   4   0   0:  2   0  93   6   0   0:  3   4  72  22   0
0:  2   2  92   3   0   1: 10  13  22  54   0   1:  6   7  75  12   0
0:  3   0  87  10   0   0: 12   0  81   7   0   0|6640k 1683k| 140k
240k|   0     0 |2860  4617
   1   1  29  68   0   1: 12   0  80   8   0   0:  6   0  78  16   0
1:  3   1  80  16   0   0: 14  14  57  16   0   0:  0  11  78  12   0
0:  9   1  83   7   0   0:  0   0  96   4   0   0|4448k 1266k| 102k
336k|   0     0 |2790  4645
   0   0  89  11   0   0:  1   0  98   1   0   0: 14   0  57  29   0
0:  1   1  89   9   0   0:  1  15  41  43   0   0:  3  15  75   7   0
0:  3   2  60  35   0   0:  0   0  95   5   0   0|  18M 1622k|  97k
285k|   0     0 |3303  4764
   0   0  96   4   0   0:  0   0  99   0   0   1:  1   2  14  83   0
0:  1  25  17  57   0   0:  1   0  87  12   0   0:  1   0  19  80   0
0:  3   3   0  94   0   0:  0   0  48  52   0   0|1320k   19M|  40k
113k|   0     0 |2909  4709
   1   0  63  36   0   0:  5   2  88   5   0   0: 34   2   0  63   1
0:  8   8  72  12   0   0:  0   9  85   6   0   0:  1   2  84  13   0
0:  2   1  60  37   0   0:  1   1  62  36   0   0|9160k 5597k|  52k
143k|  32k    0 |2659  4650
   4   0  43  53   0   0:  2   0  93   5   0   0:  9   0  63  28   0
0:  3   1  89   7   0   0:  2   9  72  16   0   1:  0  13  81   6   0
0:  9   1  52  38   0   0:  3   0  84  13   0   0|4980k 1358k| 106k
239k|   0     0 |2993  5158
   2   1  90   7   0   0:  2   0  95   3   0   0:  2   3  82  13   0
0:  0   0  87  13   0   0:  6  10  32  52   0   0:  2  10  82   6   0
0:  5   0  86   9   0   0: 10   5  81   4   0   0|4376k 2949k| 119k
295k|   0     0 |2729  4630
   1   0  93   6   0   0:  2   0  91   6   1   0: 15   4  71  11   0
0:  7   2  90   1   0   0: 13  10  12  65   0   0:  2  13  41  45   0
0:  1   0  97   2   0   0:  1   0  94   5   0   0|3896k   15M|  87k
242k|   0     0 |2809  5514
   2   0  98   0   0   0:  0   0  73  27   0   0:  0   0 100   0   0
0:  2   1  29  68   0   0:  4   5   0  92   0   0:  2   5  92   2   0
0:  0   0 100   0   0   0:  1   0  77  22   0   0| 172k   19M|  40k
127k|   0     0 |2221  4069
   0   0  48  52   0   0:  0   0  97   3   0   0:  0   0  92   8   0
0:  3   0  91   6   0   0:  2  10  10  78   0   0:  4  10  81   6   0
0:  2   0  29  69   0   0:  1   0  26  73   0   0| 652k 6931k|  66k
233k|   0     0 |2416  4389
   6   2  72  21   0   0:  3   1  86  10   0   0:  7   0  60  34   0
0:  2   2  91   6   0   0:  1  13  78   9   0   0:  2   8  84   6   0
0:  2   0  79  19   0   0:  0   2  87  11   0   0|2784k 1456k|  96k
206k|   0     0 |2854  5226
   9   4  50  37   0   0:  3   3  84  10   0   0:  4   0  84  12   0
0:  2   3  86   9   0   0: 10   2  73  15   0   0:  3   5  84   8   0
0:  8   4  81   6   0   0:  1   2  84  13   0   0|2952k 1374k| 133k
305k|   0     0 |3249  5076
   9   1  78  13   0   0:  4   4  83   9   0   0:  3   1  68  28   0
0:  3   3  82  12   0   0:  9   0  64  26   0   1:  2   1  83  13   0
1:  9   3  63  24   0   1:  3   1  91   5   0   0|3648k 1420k| 188k
444k|   0     0 |3560  5981
   3   1  63  33   0   0:  0   1  86  13   0   0:  1   0  67  32   0
0:  1   2  84  12   0   1:  4   2  49  45   0   0:  6   3  82   9   0
0:  1   1  93   5   0   0:  1   1  91   7   0   0|2980k 1385k| 181k
457k|   0     0 |3023  5230
   3   5  90   2   0   0:  3   9  84   4   0   0:  2   2  55  41   0
0: 21   3  69   7   0   0:  1   3  76  20   0   0:  2   1  93   4   0
0:  1   3  67  29   0   0:  0   1  93   6   0   0|2796k 1359k| 104k
237k|   0     0 |2339  4598
   6   5  74  15   0   0:  0   5  87   8   0   0:  4   0  91   5   0
0:  0   0  98   2   0   0: 11   0  74  16   0   0:  3   1  87   9   0
0: 26   4  53  17   0   0:  0   1  92   7   0   0|1920k 1401k| 107k
278k|   0     0 |2352  4480
   2   0  91   7   0   0:  1  10  84   5   0   0:  4   0  93   3   0
0:  3   2  93   2   0   0:  6   2  84   8   0   0:  1   0  97   2   0
0:  2   0  85  13   0   0:  3   2  89   6   0   0|1508k 1397k| 134k
313k|   0     0 |2374  4547
   2   0  74  24   0   0:  0   0  97   3   0   0:  1   0  97   2   0
0:  3   2  95   0   0   0:  1   0  96   3   0   0:  4   2  91   4   0
0:  0   5  89   6   0   0:  3   1  91   6   0   0|1464k 1464k|  68k
143k|   0     0 |1839  3950
   4   0  91   5   0   0:  5   4  89   3   0   0:  1   0  98   1   0
0:  0   1  97   2   0   0:  2   2  68  28   0   0:  1   0  91   8   0
0:  2   8  70  20   0   0:  1   5  91   2   0   1|1060k 1903k| 133k
142k|   0     0 |2358  4720
   3   0  91   6   0   0:  4   3  88   5   0   0:  1   0  95   4   0
0:  1   2  94   3   0   0:  3   1  53  43   0   0:  3   2  93   2   0
0:  0   2  86  13   0   0:  0   4  89   7   0   0|1580k 1332k|  91k
273k|   0     0 |2249  4564
   4   0  79  16   0   1:  3   6  84   8   0   0:  1   0  92   7   0
0:  2   3  88   7   0   0:  5   2  86   7   0   0:  2   4  90   3   0
1:  4   1  81  14   0   0:  7   3  81  10   0   0|1128k 1343k| 122k
263k|   0     0 |3262  5503
   0   2  60  38   0   0:  3   5  90   3   0   0:  0  11  78  12   0
0:  1   5  91   3   0   0:  2   4  90   4   0   0:  4   2  89   5   0
0:  3   0  94   3   0   0:  4   2  87   8   0   0|1252k 1255k| 329k
494k|   0     0 |3223  5661
   2   0  84  13   0   1:  3   6  84   7   0   0:  3   7  83   8   0
0:  5  15  72   8   0   0:  2   1  96   1   0   0:  1   2  93   4   0
0:  4   1  65  30   0   0:  1   0  89  10   0   0|1660k 2513k| 148k
460k|   0     0 |2597  5129
   1   2  92   5   0   0:  0   1  41  58   0   0: 10   5  83   2   0
0:  3  18  78   2   0   0:  3   0  93   4   0   0:  3   0  97   0   0
0:  4   0  80  17   0   0:  2   0  91   7   0   0| 652k   15M|  72k
198k|   0     0 |2340  6382
   0   1  88  11   0   0:  3   3  88   7   0   0:  2   1  80  17   0
0:  0  13  75  13   0   0:  1   1  73  25   0   0:  1   1  93   5   0
0:  0   1  94   5   0   0:  1   0  86  13   0   0|1568k 1155k|  68k
166k|   0     0 |2348  4738
   3   0  54  43   0   0:  4   9  82   6   0   0:  2   0  88  11   0
0:  2   5  88   6   0   0:  1   0  88  11   0   0:  2   0  93   5   0
0:  3   1  80  17   0   0:  0   0  88  12   0   0|1200k 1319k| 113k
233k|   0     0 |2660  5168
   0   1  91   8   0   0:  4   6  87   4   0   0:  1   0  72  27   0
0:  2   2  70  26   0   0:  2   0  85  13   0   0:  1   0  94   5   0
0:  2   0  95   3   0   0:  1   1  89   9   0   0|1032k 1346k| 119k
234k|   0     0 |2398  4808
   0   1  73  26   0   0:  3   5  83  10   0   0:  1   2  96   1   0
0:  4   0  91   5   0   0:  2   2  90   6   0   0:  2   0  94   4   0
0:  3   4  70  23   0   0:  3   6  85   6   0   0|1272k 1522k| 117k
279k|   0     0 |2739  5237
   1   0  56  43   0   0:  0   2  86  12   0   0:  2   1  89   8   0
0:  2   2  92   4   0   0:  7   1  82  10   0   0:  4   1  92   3   0
0:  5   2  80  13   0   0:  4   4  87   6   0   0|1080k 1637k| 141k
345k|   0     0 |2631  5142
   0   0  65  35   0   0:  0   1  89  10   0   0:  2   0  84  14   0
0:  1   3  92   4   0   0:  0   0  89  11   0   0:  2   0  91   7   0
0:  2   5  87   6   0   0:  2   7  87   5   0   0|1012k 1412k|  95k
215k|   0     0 |2304  4762
   1   0  93   6   0   0:  3   1  95   1   0   0:  2   1  97   0   0
0:  3   3  91   3   0   0:  2   0  72  26   0   0:  1   0  93   6   0
0:  0   7  70  23   0   0:  2   8  82   8   0   0|1152k 1548k| 101k
225k|   0     0 |2334  4706
   1   0  93   6   0   0:  2   3  93   2   0   0:  5   2  91   3   0
0:  6   3  91   1   0   0:  5   2  85   8   0   0:  2   1  91   6   0
0:  1   5  60  34   0   0:  2   6  86   6   0   0|1096k 1553k| 126k
289k|   0     0 |2471  4766
   0   0  63  37   0   0:  0   0  90  10   0   0:  1   0  99   0   0
0:  0   0  93   7   0   0:  1   0  86  13   0   0:  2   2  87   9   0
0:  0   7  70  24   0   0:  2   3  93   3   0   0|1256k 1262k| 110k
277k|   0     0 |2281  4534
   0   0  24  76   0   0:  2   1  81  16   0   0:  1   3  44  52   0
0:  2   2  65  31   0   0:  1   2  75  22   0   0:  1   0  94   5   0
0:  0   4  17  79   0   0:  5   3  93   0   0   0| 240k   19M|  83k
200k|   0     0 |2388  4131
   1   0  76  23   0   0:  1   1  94   4   0   0:  5   3  81  11   0
0:  2   4  80  14   0   0:  2   1  56  41   0   0:  0   0  77  23   0
0:  3   7  74  17   0   0:  1   5  90   5   0   0|1108k 3127k| 113k
262k|   0     0 |2584  4930
   2   1  90   8   0   0:  2   0  93   5   0   0:  2   1  75  22   0
0:  2   1  83  15   0   0:  0   1  79  20   0   0:  0   0  92   7   0
1:  2   6  77  14   0   1:  2   8  87   4   0   0|1220k 1358k| 152k
318k|   0    12k|2590  5104
   3   0  81  16   0   0:  3   1  88   9   0   0:  3   1  93   3   0
0:  2   3  90   5   0   0:  1   0  93   6   0   0:  4   1  92   4   0
0:  5  13  37  46   0   0:  2   7  81  10   0   0|1256k 1437k| 167k
336k|   0     0 |2734  5356
   0   0  93   7   0   0:  1   2  88   9   0   0:  2   0  92   5   0
1:  1   2  94   3   0   0:  0   0  50  50   0   0:  0   0  99   1   0
0:  3  11  81   5   0   0:  3   7  86   4   0   0|1108k 1448k| 109k
225k|   0     0 |2081  4316
   3   0  42  55   0   0:  0   3  92   5   0   0:  0   0 100   0   0
0:  1   0  92   7   0   0:  3   1  69  27   0   0:  1   0  66  33   0
0:  4   7  56  33   0   0:  3   3  61  33   0   0| 720k   17M| 104k
290k|   0     0 |2300  4168
   0   2  59  39   0   0:  3   7  75  15   0   0:  0   6  89   5   0
0: 12   9  75   4   0   0:  1   0  81  18   0   0:  2   1  94   3   0
0:  1   8  56  35   0   0:  3   5  57  35   0   1| 428k 8241k|  96k
259k|   0   124k|2082  5154
   1   1  90   8   0   0:  2   2  46  49   0   0:  1   0  93   6   0
0:  9   4  83   4   0   0:  0   0  95   5   0   0:  1   0  98   1   0
0:  6   7  76  11   0   0:  1   4  85  10   0   0| 592k   14M|  82k
194k|   0     0 |2195  5839
   4   1  82  13   0   0:  3   0  87  10   0   0:  4   3  81  12   0
0:  0   0  82  18   0   0:  1   1  88  11   0   0:  1   0  90   9   0
0:  5   7  64  24   0   0:  5   3  86   6   0   0|1876k 1273k| 145k
323k|   0     0 |2544  4949
   0   1  66  33   0   0:  5   1  89   6   0   0:  0   1  88  12   0
0:  1   3  82  14   0   0:  1   0  86  12   0   1:  1   1  88  10   0
0:  8   3  82   8   0   0:  6   7  84   3   0   0|2544k 1259k| 125k
280k|   0     0 |2487  4776
   0   1  85  14   0   0:  0   0 100   0   0   0:  3   0  95   2   0
0:  5   3  91   2   0   0:  0   0  94   6   0   0:  6   1  84  10   0
0:  1  10  50  39   0   0:  4   5  82   9   0   0| 896k 1378k|  92k
181k|   0     0 |2452  4823
   0   0  94   6   0   0:  2   1  97   0   0   0:  3   0  94   3   0
0:  0   0  89  11   0   0:  2   3  83  12   0   0:  2   2  83  13   0
0:  2   9  50  40   0   0:  5  10  66  19   0   0| 848k 1237k|  98k
204k|   0     0 |2309  4733
   3   0  93   3   0   1:  2   9  83   6   0   0:  1   0  98   1   0
0:  1   3  96   0   0   0:  3   2  84  12   0   0:  1   0  88  11   0
0:  1   0  39  60   0   0:  0   4  88   8   0   0| 992k 1113k|  99k
212k|   0     0 |2318  4696
  10   0  87   3   0   0:  1   8  90   2   0   0:  2   0  91   7   0
0:  4   2  90   4   0   0:  4   2  78  16   0   0:  3   0  89   9   0
0:  4   0  90   7   0   0:  0   0  99   1   0   0| 964k 1165k| 119k
291k|   0     0 |2505  4842
   8   3  83   6   0   0:  7   0  80  13   0   0:  2   6  67  25   0
0:  4   6  80  10   0   0:  2   1  77  20   0   0:  2   1  87   8   0
2:  2   1  82  16   0   0:  1   0  95   4   0   0| 888k 1154k| 158k
331k|   0     0 |2759  5495
   6   0  91   3   0   0:  4   1  93   2   0   0:  0  10  85   5   0
0:  1  10  85   5   0   0:  2   1  37  60   0   0:  0   0  88  12   0
0:  5   0  83  12   0   0:  2   1  88   9   0   0| 992k 1143k| 149k
300k|   0     0 |2606  5054
   5   0  75  19   0   1:  7   1  81  11   0   0:  4  11  73  12   0
0:  6  16  62  16   0   0:  5   1  88   6   0   0:  6   1  84   8   0
0:  1   4  71  24   0   1:  1   2  91   6   0   0|1372k 1109k| 193k
434k|   0     0 |3216  5887
   3   1  90   6   0   0: 10   3  80   7   0   0:  0   2  92   6   0
0:  2   0  94   4   0   0:  0   2  65  33   0   0:  2   0  95   3   0
0:  0   7  76  18   0   0:  5   6  79  10   0   0|1044k 1077k| 191k
409k|   0     0 |2815  5311
   1   0  90   9   0   0:  6   4  89   2   0   0:  3   0  92   5   0
0:  6   1  93   0   0   0:  3   3  45  50   0   0:  1   1  88  10   0
0:  3   7  88   3   0   0:  2   7  85   7   0   0| 800k 1214k| 135k
282k|   0     0 |2570  5140
   7   1  89   3   0   0:  0   3  91   6   0   0:  1   2  93   4   0
0:  3   4  90   3   0   0:  3   1  39  57   0   0:  1   0  88  11   0
0:  1   4  79  17   0   0:  3   2  85   9   0   1|1060k 1076k| 108k
225k|   0     0 |2681  5304
   1   1  85  13   0   0:  4   5  90   2   0   0:  2   5  91   2   0
0:  4   8  83   5   0   0:  2   0  41  58   0   0:  2   2  92   4   0
0:  0   2  62  36   0   0:  0   1  90   9   0   0|1956k  948k| 153k
360k|   0     0 |2802  5189
   2   0  92   6   0   0:  4   2  85   9   0   0:  0   2  95   3   0
0:  1   2  93   4   0   0:  2   3  34  61   0   0:  1   3  85  11   0
0:  3   0  55  42   0   0:  1   0  91   8   0   0|1768k  921k| 170k
367k|   0     0 |2511  4701



В списке pgsql-performance по дате отправления:

Предыдущее
От: Gerhard Wohlgenannt
Дата:
Сообщение: Re: Sudden drop in DBb performance
Следующее
От: Gerhard Wohlgenannt
Дата:
Сообщение: Re: Sudden drop in DBb performance