MCPcopy Create free account
hub / github.com/PostHog/duckgres / queryPgStatActivity

Function queryPgStatActivity

tests/integration/pg_stat_activity_test.go:70–86  ·  view source on GitHub ↗

queryPgStatActivity returns all rows from pg_stat_activity as maps.

(db *sql.DB)

Source from the content-addressed store, hash-verified

68
69// queryPgStatActivity returns all rows from pg_stat_activity as maps.
70func queryPgStatActivity(db *sql.DB) ([]map[string]interface{}, error) {
71 rows, err := db.Query("SELECT * FROM pg_stat_activity")
72 if err != nil {
73 return nil, err
74 }
75 defer func() { _ = rows.Close() }()
76
77 var result []map[string]interface{}
78 for rows.Next() {
79 row, err := scanPgStatActivityRow(rows)
80 if err != nil {
81 return nil, err
82 }
83 result = append(result, row)
84 }
85 return result, rows.Err()
86}
87
88// TestPgStatActivity tests the pg_stat_activity virtual table.
89func TestPgStatActivity(t *testing.T) {

Callers 1

TestPgStatActivityFunction · 0.85

Calls 5

scanPgStatActivityRowFunction · 0.85
QueryMethod · 0.65
CloseMethod · 0.65
NextMethod · 0.65
ErrMethod · 0.65

Tested by

no test coverage detected