pg_stat_database

Поиск
Список
Период
Сортировка
От Crombleholme, Roy
Тема pg_stat_database
Дата
Msg-id 4F9235D7B7D2D611B8DB000802E65AC5062326@lccmail2.lancscc.gov.uk
обсуждение исходный текст
Список pgsql-novice
There are five columns in the view.  I am just looking for some confirmation
on what the terms mean.

Number of backends:   Is this just the number of active connections to the
database?

total transactions committed:  I think i get this one.

total rolled back: I don't have a clue what rolling back means, does anybody
else?

total disk blocks read:  I'm OK with this one.

total buffer hits:  OK with this one too :)

Any explanations wouyld be greatly appreciated.

Many thanks

Roy Crombleholme
Trainee ICT Engineer
ICT Services
Resources Directorate
Lancashire County Council
01772 5-31849
Email:  roy.crombleholme@its.lancscc.gov.uk



********************
This e-mail contains information intended for the addressee only.
It may be confidential and may be the subject of legal and/or professional privilege.
If you are not the addressee you are not authorised to disseminate, distribute, copy or use this e-mail or any
attachmentto it 
The content may be personal or contain personal opinions and unless specifically stated or followed up in writing, the
contentcannot be taken to form a contract or to be an expression of the County Council's position. 
LCC reserves the right to monitor all incoming and outgoing email
LCC has taken reasonable steps to ensure that outgoing communications do not contain  malicious software and it is your
responsibilityto carry out any checks on this email before accepting the email and opening attachments. 
********************


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

Предыдущее
От: "M. Bastin"
Дата:
Сообщение: OIDs of data types
Следующее
От: "M. Bastin"
Дата:
Сообщение: Re: MD5 salt