pg 进程
postgres: checkpointer process
postgres: writer process
postgres: wal writer process
postgres: autovacuum launcher process
postgres: stats collector process
postgres: bgworker: logical replication launcher
postgres: {user} db 127.0.0.1(pid) idle
postgres: {user} default 127.0.0.1(pid) idle
pg query解析
main.c main
postmaster.c PostmasterMain
postmaster.c ServerLoop
postmaster.c BackendStartup
postmaster.c BackendRun
postgres.c PostgresMain
postgres.c exec_simple_query
pquery.c PortalRun
pquery.c PortalRunMulti
pquery.c ProcessQuery
ProcessQuery(PlannedStmt *plan,
const char *sourceText,
ParamListInfo params,
QueryEnvironment *queryEnv,
DestReceiver *dest,
char *completionTag)
{
QueryDesc *queryDesc;
queryDesc = CreateQueryDesc(plan, sourceText,
GetActiveSnapshot(),