Open templatedop opened 4 months ago
@jackc Can you please help me how to add tracer and log And what is the pre-requisite in enabling it.
You've got several layers of non-core pgx code there. I don't know what is going on with it.
But if you want working examples of tracing and logging I suggest looking at https://github.com/jackc/pgx/blob/master/tracer_test.go and https://github.com/jackc/pgx/blob/master/tracelog/tracelog_test.go.
Hey! thanks for reply. I need to implement this. Kindly guide. I tried both but I might be missing something.
For log
config, err := pgxpool.ParseConfig(dsn)
logger := &testLogger{}
tracer := &tracelog.TraceLog{
Logger: logger,
LogLevel: tracelog.LogLevelTrace,
}
config.ConnConfig.Tracer = tracer
For testLogger above, added code available in (https://github.com/jackc/pgx/blob/master/tracelog/tracelog_test.go)
An then executed queries like Exec and Query thinking that logs at each stage will be printed in console. But nothing is getting printed. Is my understanding correct. Shall I need to add anything else. Am I missing something.
For tracer
config, err := pgxpool.ParseConfig(dsn)
tracer := &testTracer{}
config.ConnConfig.Tracer = tracer
For testTracer above added available at https://github.com/jackc/pgx/blob/master/tracer_test.go An then executed queries like Exec and Query thinking that trace details will be printed in console.
Am I missing something. Please guide further.
After adding all the config details
I was using pgxpool.New instead of pgxpool.Newwithconfig.
I found the mistake
Logger is working fine after changing from pgxpool.New to pgxpool.NewWithConfig
It's logging all the details.
But while connecting tracer nothing is shown
Do we need to explicitly call something for the sake of tracer...
I don't know. You probably will want to step through the connection process with a debugger and see what happens when you get to the connect trace points.
Hey! With limited resources/knowledge I was trying to add tracer and logger to an application. The intention is to trace queries and connections to find what's happening with application and database. However, I was not able to trace/log anything.
I am sure I am missing something please guide.
Kindly guide or point towards resources which can be utilised to enable logger and tracer.