Ad Widget

Collapse

memory usage of postgres

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • tekknokrat
    Senior Member
    • Sep 2008
    • 140

    #1

    memory usage of postgres

    I have created an item for monitoring postgres memory consumption:

    key: proc.mem[postgres,postgres]

    last data shows: 1.27 GB

    but top shows entries which imo are double. How do i get correct memory usage for postgres?

    Code:
    11629 postgres  20   0 83708  68m  66m S  0.3 13.7 176:11.14 postgres                                                                                        
    11631 postgres  20   0 83580  68m  66m S  1.3 13.6 176:09.19 postgres                                                                                        
     4634 postgres  20   0 81812  66m  66m S  0.0 13.3  44:40.13 postgres                                                                                        
    11656 postgres  20   0 82844  66m  64m S  0.0 13.2  26:33.07 postgres                                                                                        
    11657 postgres  20   0 82776  65m  63m S  0.3 12.9  30:27.71 postgres                                                                                        
    11633 postgres  20   0 82936  60m  59m S  0.0 12.1  17:15.38 postgres                                                                                        
    11654 postgres  20   0 82804  22m  21m S  0.0  4.5   2:23.91 postgres                                                                                        
     6581 www-data  20   0 35792  18m 4828 S  0.0  3.7   0:15.97 ops.fcgi                                                                                        
     6518 www-data  20   0 35592  18m 4760 S  0.0  3.6   0:15.83 ops.fcgi                                                                                        
     5107 www-data  20   0 32464  14m 4788 S  0.0  2.9   0:09.36 apache2                                                                                         
    23125 www-data  20   0 32196  14m 4868 S  0.0  2.9   0:14.08 apache2                                                                                         
    22225 www-data  20   0 32168  14m 4872 S  0.0  2.9   0:13.42 apache2                                                                                         
    20774 www-data  20   0 31920  14m 4872 S  0.0  2.8   0:18.26 apache2                                                                                         
    22213 www-data  20   0 31900  13m 4868 S  0.0  2.8   0:13.88 apache2                                                                                         
    22292 www-data  20   0 32304  13m 4256 S  0.0  2.7   0:04.62 apache2                                                                                         
    20039 www-data  20   0 32336  13m 4172 S  0.0  2.7   0:05.56 apache2                                                                                         
    14905 www-data  20   0 31756  13m 4372 S  0.0  2.7   0:07.68 apache2                                                                                         
    11635 postgres  20   0 82756  13m  12m S  0.0  2.6   0:06.62 postgres                                                                                        
    22007 www-data  20   0 31788  12m 4048 S  0.0  2.6   0:04.70 apache2                                                                                         
    32102 www-data  20   0 31248  12m 4048 S  0.0  2.5   0:00.62 apache2                                                                                         
    11651 postgres  20   0 82784 9592 8036 S  0.0  1.9   2:22.75 postgres                                                                                        
    22724 root      20   0 26208 9468 5668 S  0.0  1.8   3:28.43 apache2                                                                                         
     1190 nobody    20   0  8476 6992 1896 S  0.0  1.4   0:00.20 postfix-policyd                                                                                 
    11655 postgres  20   0 82748 6564 5304 S  0.0  1.3   0:02.26 postgres                                                                                        
    11645 postgres  20   0 82748 6164 4896 S  0.0  1.2   1:30.36 postgres                                                                                        
     6560 postgres  20   0 82776 6076 4760 S  0.0  1.2   0:00.24 postgres                                                                                        
    21606 postgres  20   0 82776 5848 4436 S  0.0  1.1   0:00.04 postgres                                                                                        
     4605 postgres  20   0 81812 5120 4512 S  0.0  1.0   8:29.11 postgres
  • tekknokrat
    Senior Member
    • Sep 2008
    • 140

    #2
    With max argument proc.mem[,postgres,max,postgres] it looks more realistic.
    Still not sure if this is the real postgres memory footprint. Someone else?

    Comment

    Working...