pgFouine: PostgreSQL VACUUM log analysis report
- Generated on 2007-03-30 21:17
- Parsed /home/gsmet/work/pgfouine/vacuum_sample.log (13,686 lines) in 2s
- Executed on edgewood
- Filtered on exilog.public
FSM information ^
- FSM size: 22,125 kB
| Current value | Limit | Percentage | |
|---|---|---|---|
| Page slots | 32,480 | 2,000,000 | 1.6 % |
| Relations | 123 | 100,000 | 0.1 % |
Vacuum overall statistics ^
| Tables | Pages | Pages truncated | % | Row versions | Removable row versions | % | CPU usage | Duration | |
|---|---|---|---|---|---|---|---|---|---|
| exilog | 7 | 21,811 | 18,481 | 84.7 | 100,114 | 298 | 0.3 | 10.7s | 1m43s |
Vacuumed tables ^
Click on a column header to sort the rows. Note that it can be quite long to sort all the rows if you vacuumed a lot of tables.
| # | Table | Pages | Pages truncated | % | Row versions | Removable row versions | % | CPU usage | Duration | Details |
|---|---|---|---|---|---|---|---|---|---|---|
| 4 | exilog - public.queue | 4 | 3 | 75.0 | 11 | 4 | 36.4 | 0.00 | 0.00 | Details |
| 3 | exilog - public.messages | 1075 | 505 | 47.0 | 18074 | 294 | 1.6 | 1.15 | 4.41 | Details |
| 7 | exilog - public.deliveries | 618 | 238 | 38.5 | 17861 | 0 | 0.0 | 0.68 | 5.22 | Details |
| 6 | exilog - public.deferrals | 23 | 19 | 82.6 | 120 | 0 | 0.0 | 0.00 | 0.01 | Details |
| 1 | exilog - public.unknown | 150 | 90 | 60.0 | 3399 | 0 | 0.0 | 0.15 | 0.74 | Details |
| 2 | exilog - public.errors | 38 | 23 | 60.5 | 323 | 0 | 0.0 | 0.00 | 0.08 | Details |
| 5 | exilog - public.rejects | 19903 | 17603 | 88.4 | 60326 | 0 | 0.0 | 8.75 | 92.54 | Details |
Vacuumed tables details ^
1 - exilog - public.unknown
- Pages: 150
- Pages truncated: 90 ( 60.0% )
- Row versions: 3399
- Removable row versions: 0 ( 0.0% )
- Non removable dead rows: 0
- Non removable row size: from 90 bytes to 282 bytes
- Unused item pointers: 6370
- CPU usage: sys: 0.1s / user: 0.1s
- Duration: 0.7s
| Index | Pages | Deleted pages | Reusable pages | Row versions | Removed row versions | CPU usage | Duration |
|---|---|---|---|---|---|---|---|
| unknown_server | 300 | 206 | 206 | 3399 | 0 | sys: 0.0s / user: 0.0s | 0.0s |
| unknown_message_id | 612 | 474 | 474 | 3399 | 0 | sys: 0.0s / user: 0.0s | 0.0s |
| unknown_timestamp | 369 | 276 | 276 | 3399 | 0 | sys: 0.0s / user: 0.0s | 0.0s |
| unknown_server_message_id | 917 | 761 | 761 | 3399 | 0 | sys: 0.0s / user: 0.0s | 0.0s |
| unknown_primary | 2182 | 1910 | 1910 | 3399 | 0 | sys: 0.0s / user: 0.0s | 0.1s |
| unknown_server | 300 | 216 | 216 | 3399 | 1377 | sys: 0.0s / user: 0.0s | 0.0s |
| unknown_message_id | 612 | 467 | 467 | 3399 | 1377 | sys: 0.0s / user: 0.0s | 0.0s |
| unknown_timestamp | 369 | 272 | 272 | 3399 | 1377 | sys: 0.0s / user: 0.0s | 0.0s |
| unknown_server_message_id | 917 | 755 | 755 | 3399 | 1377 | sys: 0.0s / user: 0.0s | 0.0s |
| unknown_primary | 2182 | 1890 | 1890 | 3399 | 1377 | sys: 0.0s / user: 0.0s | 0.0s |
2 - exilog - public.errors
- Pages: 38
- Pages truncated: 23 ( 60.5% )
- Row versions: 323
- Removable row versions: 0 ( 0.0% )
- Non removable dead rows: 0
- Non removable row size: from 130 bytes to 463 bytes
- Unused item pointers: 604
- CPU usage: sys: 0.0s / user: 0.0s
- Duration: 0.1s
| Index | Pages | Deleted pages | Reusable pages | Row versions | Removed row versions | CPU usage | Duration |
|---|---|---|---|---|---|---|---|
| errors_server | 10 | 5 | 5 | 323 | 0 | sys: 0.0s / user: 0.0s | 0.0s |
| errors_message_id | 12 | 7 | 7 | 323 | 0 | sys: 0.0s / user: 0.0s | 0.0s |
| errors_timestamp | 6 | 2 | 2 | 323 | 0 | sys: 0.0s / user: 0.0s | 0.0s |
| errors_rcpt | 9 | 0 | 0 | 323 | 0 | sys: 0.0s / user: 0.0s | 0.0s |
| errors_rcpt_final | 9 | 0 | 0 | 323 | 0 | sys: 0.0s / user: 0.0s | 0.0s |
| errors_host_addr | 7 | 0 | 0 | 323 | 0 | sys: 0.0s / user: 0.0s | 0.0s |
| errors_server_message_id | 14 | 8 | 8 | 323 | 0 | sys: 0.0s / user: 0.0s | 0.0s |
| errors_primary | 30 | 18 | 18 | 323 | 0 | sys: 0.0s / user: 0.0s | 0.0s |
| errors_server | 11 | 5 | 5 | 323 | 176 | sys: 0.0s / user: 0.0s | 0.0s |
| errors_message_id | 12 | 6 | 6 | 323 | 176 | sys: 0.0s / user: 0.0s | 0.0s |
| errors_timestamp | 7 | 2 | 2 | 323 | 176 | sys: 0.0s / user: 0.0s | 0.0s |
| errors_rcpt | 9 | 0 | 0 | 323 | 176 | sys: 0.0s / user: 0.0s | 0.0s |
| errors_rcpt_final | 9 | 0 | 0 | 323 | 176 | sys: 0.0s / user: 0.0s | 0.0s |
| errors_host_addr | 7 | 0 | 0 | 323 | 176 | sys: 0.0s / user: 0.0s | 0.0s |
| errors_server_message_id | 14 | 8 | 8 | 323 | 176 | sys: 0.0s / user: 0.0s | 0.0s |
| errors_primary | 30 | 17 | 17 | 323 | 176 | sys: 0.0s / user: 0.0s | 0.0s |
3 - exilog - public.messages
- Pages: 1075
- Pages truncated: 505 ( 47.0% )
- Row versions: 18074
- Removable row versions: 294 ( 1.6% )
- Non removable dead rows: 0
- Non removable row size: from 120 bytes to 360 bytes
- Unused item pointers: 18283
- CPU usage: sys: 0.2s / user: 0.9s
- Duration: 4.4s
| Index | Pages | Deleted pages | Reusable pages | Row versions | Removed row versions | CPU usage | Duration |
|---|---|---|---|---|---|---|---|
| server | 294 | 132 | 132 | 17780 | 294 | sys: 0.0s / user: 0.0s | 0.1s |
| message_id | 464 | 196 | 196 | 17780 | 294 | sys: 0.0s / user: 0.0s | 0.1s |
| msgid | 650 | 190 | 190 | 17780 | 294 | sys: 0.0s / user: 0.0s | 0.1s |
| timestamp | 254 | 108 | 108 | 17780 | 294 | sys: 0.0s / user: 0.0s | 0.0s |
| host_addr | 233 | 100 | 100 | 17780 | 294 | sys: 0.0s / user: 0.0s | 0.0s |
| bounce_parent | 256 | 116 | 116 | 17780 | 294 | sys: 0.0s / user: 0.0s | 0.1s |
| user | 234 | 105 | 105 | 17780 | 294 | sys: 0.0s / user: 0.0s | 0.1s |
| mailfrom | 490 | 153 | 153 | 17780 | 294 | sys: 0.0s / user: 0.0s | 0.1s |
| messages_server_message_id | 648 | 266 | 266 | 17780 | 294 | sys: 0.0s / user: 0.0s | 0.1s |
| primary | 560 | 209 | 209 | 17780 | 294 | sys: 0.0s / user: 0.0s | 0.6s |
| server | 294 | 172 | 172 | 17780 | 10195 | sys: 0.0s / user: 0.0s | 0.0s |
| message_id | 464 | 194 | 194 | 17780 | 10195 | sys: 0.0s / user: 0.0s | 0.0s |
| msgid | 650 | 182 | 182 | 17780 | 10195 | sys: 0.0s / user: 0.0s | 0.1s |
| timestamp | 254 | 105 | 105 | 17780 | 10195 | sys: 0.0s / user: 0.0s | 0.0s |
| host_addr | 233 | 138 | 138 | 17780 | 10195 | sys: 0.0s / user: 0.0s | 0.0s |
| bounce_parent | 256 | 159 | 159 | 17780 | 10195 | sys: 0.0s / user: 0.0s | 0.0s |
| user | 234 | 136 | 136 | 17780 | 10195 | sys: 0.0s / user: 0.0s | 0.1s |
| mailfrom | 489 | 129 | 129 | 17780 | 10195 | sys: 0.0s / user: 0.0s | 0.5s |
| messages_server_message_id | 648 | 264 | 264 | 17780 | 10195 | sys: 0.0s / user: 0.0s | 0.1s |
| primary | 560 | 207 | 207 | 17780 | 10195 | sys: 0.0s / user: 0.0s | 0.0s |
4 - exilog - public.queue
- Pages: 4
- Pages truncated: 3 ( 75.0% )
- Row versions: 11
- Removable row versions: 4 ( 36.4% )
- Non removable dead rows: 0
- Non removable row size: from 677 bytes to 1570 bytes
- Unused item pointers: 31
- CPU usage: sys: 0.0s / user: 0.0s
- Duration: 0.0s
| Index | Pages | Deleted pages | Reusable pages | Row versions | Removed row versions | CPU usage | Duration |
|---|---|---|---|---|---|---|---|
| queue_server | 2 | 0 | 0 | 7 | 4 | sys: 0.0s / user: 0.0s | 0.0s |
| queue_message_id | 4 | 0 | 0 | 7 | 4 | sys: 0.0s / user: 0.0s | 0.0s |
| queue_mailfrom | 4 | 0 | 0 | 7 | 4 | sys: 0.0s / user: 0.0s | 0.0s |
| queue_timestamp | 2 | 0 | 0 | 7 | 4 | sys: 0.0s / user: 0.0s | 0.0s |
| queue_frozen | 2 | 0 | 0 | 7 | 4 | sys: 0.0s / user: 0.0s | 0.0s |
| queue_spool_path | 4 | 0 | 0 | 7 | 4 | sys: 0.0s / user: 0.0s | 0.0s |
| queue_msgid | 5 | 1 | 1 | 7 | 4 | sys: 0.0s / user: 0.0s | 0.0s |
| queue_action | 2 | 0 | 0 | 7 | 4 | sys: 0.0s / user: 0.0s | 0.0s |
| queue_server_message_id | 4 | 0 | 0 | 7 | 4 | sys: 0.0s / user: 0.0s | 0.0s |
| queue_primary | 4 | 0 | 0 | 7 | 4 | sys: 0.0s / user: 0.0s | 0.0s |
| queue_server | 2 | 0 | 0 | 7 | 4 | sys: 0.0s / user: 0.0s | 0.0s |
| queue_message_id | 4 | 0 | 0 | 7 | 4 | sys: 0.0s / user: 0.0s | 0.0s |
| queue_mailfrom | 4 | 0 | 0 | 7 | 4 | sys: 0.0s / user: 0.0s | 0.0s |
| queue_timestamp | 2 | 0 | 0 | 7 | 4 | sys: 0.0s / user: 0.0s | 0.0s |
| queue_frozen | 2 | 0 | 0 | 7 | 4 | sys: 0.0s / user: 0.0s | 0.0s |
| queue_spool_path | 4 | 0 | 0 | 7 | 4 | sys: 0.0s / user: 0.0s | 0.0s |
| queue_msgid | 5 | 1 | 1 | 7 | 4 | sys: 0.0s / user: 0.0s | 0.0s |
| queue_action | 2 | 0 | 0 | 7 | 4 | sys: 0.0s / user: 0.0s | 0.0s |
| queue_server_message_id | 4 | 0 | 0 | 7 | 4 | sys: 0.0s / user: 0.0s | 0.0s |
| queue_primary | 4 | 0 | 0 | 7 | 4 | sys: 0.0s / user: 0.0s | 0.0s |
5 - exilog - public.rejects
- Pages: 19903
- Pages truncated: 17603 ( 88.4% )
- Row versions: 60326
- Removable row versions: 0 ( 0.0% )
- Non removable dead rows: 0
- Non removable row size: from 194 bytes to 428 bytes
- Unused item pointers: 492453
- CPU usage: sys: 4.7s / user: 4.0s
- Duration: 1m32s
| Index | Pages | Deleted pages | Reusable pages | Row versions | Removed row versions | CPU usage | Duration |
|---|---|---|---|---|---|---|---|
| rejects_server | 3547 | 3163 | 3163 | 60326 | 0 | sys: 0.1s / user: 0.0s | 0.8s |
| rejects_timestamp | 2517 | 2296 | 2296 | 60326 | 0 | sys: 0.1s / user: 0.0s | 0.1s |
| rejects_host_addr | 2687 | 2390 | 2390 | 60326 | 0 | sys: 0.1s / user: 0.0s | 1.0s |
| rejects_mailfrom | 3533 | 1676 | 1676 | 60326 | 0 | sys: 0.1s / user: 0.0s | 3.1s |
| rejects_rcpt | 4417 | 3487 | 3487 | 60326 | 0 | sys: 0.1s / user: 0.0s | 0.3s |
| rejects_message_id | 2632 | 390 | 390 | 60326 | 0 | sys: 0.0s / user: 0.0s | 0.1s |
| rejects_server_message_id | 3951 | 741 | 741 | 60326 | 0 | sys: 0.1s / user: 0.0s | 0.7s |
| rejects_unique | 29644 | 26824 | 26824 | 60326 | 0 | sys: 0.6s / user: 0.1s | 2.4s |
| rejects_server | 3547 | 3241 | 3241 | 60326 | 29073 | sys: 0.1s / user: 0.0s | 1.5s |
| rejects_timestamp | 2517 | 2198 | 2198 | 60326 | 29073 | sys: 0.1s / user: 0.0s | 0.5s |
| rejects_host_addr | 2687 | 2456 | 2456 | 60326 | 29073 | sys: 0.1s / user: 0.0s | 0.6s |
| rejects_mailfrom | 3533 | 1710 | 1710 | 60326 | 29073 | sys: 0.1s / user: 0.1s | 0.3s |
| rejects_rcpt | 4417 | 3655 | 3655 | 60326 | 29073 | sys: 0.1s / user: 0.0s | 2.4s |
| rejects_message_id | 2632 | 381 | 381 | 60326 | 29073 | sys: 0.0s / user: 0.0s | 0.1s |
| rejects_server_message_id | 3951 | 730 | 730 | 60326 | 29073 | sys: 0.1s / user: 0.1s | 0.3s |
| rejects_unique | 29644 | 25862 | 25862 | 60326 | 29073 | sys: 0.7s / user: 0.2s | 7.2s |
6 - exilog - public.deferrals
- Pages: 23
- Pages truncated: 19 ( 82.6% )
- Row versions: 120
- Removable row versions: 0 ( 0.0% )
- Non removable dead rows: 0
- Non removable row size: from 171 bytes to 420 bytes
- Unused item pointers: 645
- CPU usage: sys: 0.0s / user: 0.0s
- Duration: 0.0s
| Index | Pages | Deleted pages | Reusable pages | Row versions | Removed row versions | CPU usage | Duration |
|---|---|---|---|---|---|---|---|
| deferrals_server | 5 | 1 | 1 | 120 | 0 | sys: 0.0s / user: 0.0s | 0.0s |
| deferrals_message_id | 9 | 5 | 5 | 120 | 0 | sys: 0.0s / user: 0.0s | 0.0s |
| deferrals_timestamp | 7 | 3 | 3 | 120 | 0 | sys: 0.0s / user: 0.0s | 0.0s |
| deferrals_rcpt | 8 | 1 | 1 | 120 | 0 | sys: 0.0s / user: 0.0s | 0.0s |
| deferrals_rcpt_final | 9 | 0 | 0 | 120 | 0 | sys: 0.0s / user: 0.0s | 0.0s |
| deferrals_host_addr | 4 | 0 | 0 | 120 | 0 | sys: 0.0s / user: 0.0s | 0.0s |
| deferrals_server_message_id | 11 | 6 | 6 | 120 | 0 | sys: 0.0s / user: 0.0s | 0.0s |
| deferrals_primary | 22 | 15 | 15 | 120 | 0 | sys: 0.0s / user: 0.0s | 0.0s |
| deferrals_server | 5 | 1 | 1 | 120 | 100 | sys: 0.0s / user: 0.0s | 0.0s |
| deferrals_message_id | 9 | 5 | 5 | 120 | 100 | sys: 0.0s / user: 0.0s | 0.0s |
| deferrals_timestamp | 7 | 3 | 3 | 120 | 100 | sys: 0.0s / user: 0.0s | 0.0s |
| deferrals_rcpt | 8 | 1 | 1 | 120 | 100 | sys: 0.0s / user: 0.0s | 0.0s |
| deferrals_rcpt_final | 9 | 0 | 0 | 120 | 100 | sys: 0.0s / user: 0.0s | 0.0s |
| deferrals_host_addr | 4 | 0 | 0 | 120 | 100 | sys: 0.0s / user: 0.0s | 0.0s |
| deferrals_server_message_id | 11 | 6 | 6 | 120 | 100 | sys: 0.0s / user: 0.0s | 0.0s |
| deferrals_primary | 22 | 13 | 13 | 120 | 100 | sys: 0.0s / user: 0.0s | 0.0s |
7 - exilog - public.deliveries
- Pages: 618
- Pages truncated: 238 ( 38.5% )
- Row versions: 17861
- Removable row versions: 0 ( 0.0% )
- Non removable dead rows: 0
- Non removable row size: from 137 bytes to 377 bytes
- Unused item pointers: 11710
- CPU usage: sys: 0.1s / user: 0.6s
- Duration: 5.2s
| Index | Pages | Deleted pages | Reusable pages | Row versions | Removed row versions | CPU usage | Duration |
|---|---|---|---|---|---|---|---|
| deliveries_server | 167 | 74 | 74 | 17861 | 0 | sys: 0.0s / user: 0.0s | 0.0s |
| deliveries_message_id | 234 | 97 | 97 | 17861 | 0 | sys: 0.0s / user: 0.0s | 0.0s |
| deliveries_timestamp | 129 | 51 | 51 | 17861 | 0 | sys: 0.0s / user: 0.0s | 0.0s |
| deliveries_rcpt | 223 | 84 | 84 | 17861 | 0 | sys: 0.0s / user: 0.0s | 0.0s |
| deliveries_rcpt_final | 264 | 71 | 71 | 17861 | 0 | sys: 0.0s / user: 0.0s | 0.0s |
| deliveries_host_addr | 132 | 49 | 49 | 17861 | 0 | sys: 0.0s / user: 0.0s | 0.0s |
| deliveries_server_message_id | 351 | 151 | 151 | 17861 | 0 | sys: 0.0s / user: 0.0s | 0.0s |
| deliveries_primary | 620 | 229 | 229 | 17861 | 0 | sys: 0.0s / user: 0.0s | 0.0s |
| deliveries_server | 167 | 70 | 70 | 17861 | 7411 | sys: 0.0s / user: 0.0s | 0.1s |
| deliveries_message_id | 234 | 47 | 47 | 17861 | 7411 | sys: 0.0s / user: 0.0s | 0.0s |
| deliveries_timestamp | 129 | 24 | 24 | 17861 | 7411 | sys: 0.0s / user: 0.0s | 0.0s |
| deliveries_rcpt | 223 | 74 | 74 | 17861 | 7411 | sys: 0.0s / user: 0.0s | 0.1s |
| deliveries_rcpt_final | 264 | 44 | 44 | 17861 | 7411 | sys: 0.0s / user: 0.0s | 0.1s |
| deliveries_host_addr | 132 | 46 | 46 | 17861 | 7411 | sys: 0.0s / user: 0.0s | 0.0s |
| deliveries_server_message_id | 351 | 80 | 80 | 17861 | 7411 | sys: 0.0s / user: 0.0s | 0.0s |
| deliveries_primary | 620 | 75 | 75 | 17861 | 7411 | sys: 0.0s / user: 0.0s | 0.1s |