I have a problem about memory leak. My program always query data from db by lib/pg, and I find a memory leak problem. I have used pprof to debug where the problem occured.
Here is the result:
flat flat% sum% cum cum%
1.51MB 100% 100% 1.51MB 100% github.com/lib/pq.DialOpen
0 0% 100% 1.51MB 100% database/sql.(*DB).conn
0 0% 100% 1.51MB 100% database/sql.(*Stmt).Query
0 0% 100% 1.51MB 100% database/sql.(*Stmt).QueryContext
0 0% 100% 1.51MB 100% database/sql.(*Stmt).connStmt
0 0% 100% 1.51MB 100% github.com/lib/pq.(*Driver).Open
0 0% 100% 1.51MB 100% github.com/lib/pq.Open
0 0% 100% 1.51MB 100% github.com/traffic/traffic-worker/drivers/parking.(*BillGenerator).queryJobs
0 0% 100% 1.51MB 100% github.com/traffic/traffic-worker/drivers/pg.(*Client).QueryParkingRecordsByStatus
0 0% 100% 1.51MB 100% runtime.goexit
and this is heap profile
heap profile: 4: 16384 [29: 2783280] @ heap/1048576
4: 16384 [4: 16384] @ 0x80dbf3 0x80d2f7 0x80c665 0x7fdab6 0x804296 0x8048e5 0x804dd5 0x830aea 0x85a028 0x45a9d1
0x80dbf2 github.com/lib/pq.DialOpen+0x8b2 /opt/gopath/src/github.com/lib/pq/conn.go:333
0x80d2f6 github.com/lib/pq.Open+0x66 /opt/gopath/src/github.com/lib/pq/conn.go:241
0x80c664 github.com/lib/pq.(*Driver).Open+0x34 /opt/gopath/src/github.com/lib/pq/conn.go:41
0x7fdab5 database/sql.(*DB).conn+0x145 /usr/local/go/src/database/sql/sql.go:965
0x804295 database/sql.(*Stmt).connStmt+0x1e5 /usr/local/go/src/database/sql/sql.go:1903
0x8048e4 database/sql.(*Stmt).QueryContext+0xe4 /usr/local/go/src/database/sql/sql.go:1941
0x804dd4 database/sql.(*Stmt).Query+0x64 /usr/local/go/src/database/sql/sql.go:1978
0x830ae9 github.com/traffic/traffic-worker/drivers/pg.(*Client).QueryParkingRecordsByStatus+0x2a9 /opt/gopath/src/github.com/traffic/traffic-worker/drivers/pg/pgClient.go:210
0x85a027 github.com/traffic/traffic-worker/drivers/parking.(*BillGenerator).queryJobs+0x107 /opt/gopath/src/github.com/traffic/traffic-worker/drivers/parking/parking.go:119
0: 0 [0: 0] @ 0x40adfa 0x80d459 0x80d2f7 0x80c665 0x7fdab6 0x804296 0x8048e5 0x804dd5 0x830aea 0x85a028 0x45a9d1
0x80d458 github.com/lib/pq.DialOpen+0x118 /opt/gopath/src/github.com/lib/pq/conn.go:258
0x80d2f6 github.com/lib/pq.Open+0x66 /opt/gopath/src/github.com/lib/pq/conn.go:241
0x80c664 github.com/lib/pq.(*Driver).Open+0x34 /opt/gopath/src/github.com/lib/pq/conn.go:41
0x7fdab5 database/sql.(*DB).conn+0x145 /usr/local/go/src/database/sql/sql.go:965
0x804295 database/sql.(*Stmt).connStmt+0x1e5 /usr/local/go/src/database/sql/sql.go:1903
0x8048e4 database/sql.(*Stmt).QueryContext+0xe4 /usr/local/go/src/database/sql/sql.go:1941
0x804dd4 database/sql.(*Stmt).Query+0x64 /usr/local/go/src/database/sql/sql.go:1978
0x830ae9 github.com/traffic/traffic-worker/drivers/pg.(*Client).QueryParkingRecordsByStatus+0x2a9 /opt/gopath/src/github.com/traffic/traffic-worker/drivers/pg/pgClient.go:210
0x85a027 github.com/traffic/traffic-worker/drivers/parking.(*BillGenerator)
So how to resole this memory leak problem? By the way how to read the heap profile? thanks in advanced!