Обсуждение: Profile a db connection time?

Поиск
Список
Период
Сортировка

Profile a db connection time?

От
Vijaykumar Jain
Дата:
Sorry if this is silly , but I have series of network outages and wanted to understand if I can profile a psql connection to various parts of it initialling a connection 
Like when using hostname, resolving dns
the time to actually establish a db connection and then the time to parse the query and run the query and time to return the results
I know a lot of the answers could be
Why not do a dns check before the connection,
run vacuum analyse to check only db time  and do not return any row, and then run with returning the rows and do a diff etc.
Am I asking something that makes sense?
Like google chrome does for page loading etc ? 

--

Regards,
Vijay