NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit7124c93

Amit Kapila

committed

Match the buffer usage tracking for leader and worker backends.

In the leader backend, we don't track the buffer usage for ExecutorStartphase whereas in worker backend we track it for ExecutorStart phase aswell. This leads to different value for buffer usage stats for theparallel and non-parallel query. Change the code so that worker backendalso starts tracking buffer usage after ExecutorStart.Author: Amit Kapila and Robert HaasReviewed-by: Robert Haas and Andres FreundBackpatch-through: 9.6 where this code was introducedDiscussion:https://postgr.es/m/86137f17-1dfb-42f9-7421-82fd786b04a1@anayrat.info

1 parent764e21d commit7124c93Copy full SHA for 7124c93

File tree

1 file changed

+10

-3

lines changed

src/backend/executor
- execParallel.c

1 file changed

+10

-3

lines changed

`‎src/backend/executor/execParallel.c`

Lines changed: 10 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -735,12 +735,19 @@ ParallelQueryMain(dsm_segment seg, shm_toc toc)`
`735`	`735`	`instrument_options=instrumentation->instrument_options;`
`736`	`736`	`queryDesc=ExecParallelGetQueryDesc(toc,receiver,instrument_options);`
`737`	`737`
`738`		`-/* Prepare to track buffer usage during query execution. */`
`739`		`-InstrStartParallelQuery();`
`740`		`-`
`741`	`738`	`/* Start up the executor, have it run the plan, and then shut it down. */`
`742`	`739`	`ExecutorStart(queryDesc,0);`
`743`	`740`	`ExecParallelInitializeWorker(queryDesc->planstate,toc);`
	`741`	`+`
	`742`	`+/*`
	`743`	`+ * Prepare to track buffer usage during query execution.`
	`744`	`+ *`
	`745`	`+ * We do this after starting up the executor to match what happens in the`
	`746`	`+ * leader, which also doesn't count buffer accesses that occur during`
	`747`	`+ * executor startup.`
	`748`	`+ */`
	`749`	`+InstrStartParallelQuery();`
	`750`	`+`
`744`	`751`	`ExecutorRun(queryDesc,ForwardScanDirection,0L);`
`745`	`752`	`ExecutorFinish(queryDesc);`
`746`	`753`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit7124c93

File tree

1 file changed

1 file changed

`‎src/backend/executor/execParallel.c`

0 commit comments