Commit108161b

committed

pg_stat_statements: Remove duplicated tests for SET statements

This looks like a copy-paste mistake introduced inde2aca2, thathas added checks for more patterns of SET statements while ignoring theoriginal test block that existed.Backpatch down to where this has been introduced, as this shaves somecycles.Author: Sergei KornilovDiscussion:https://postgr.es/m/5689421699428803@mail-sendbernar-production-main-46.myt.yp-c.yandex.netBackpatch-through: 16

1 parent8f4a1ab commit108161bCopy full SHA for 108161b

File tree

-40

lines changed

-40

lines changed

Lines changed: 0 additions & 27 deletions

Original file line number	Diff line number	Diff line change
`@@ -664,30 +664,3 @@ SELECT pg_stat_statements_reset();`
`664`	`664`
`665`	`665`	`(1 row)`
`666`	`666`
`667`		`--- SET statements.`
`668`		`--- These use two different strings, still they count as one entry.`
`669`		`-SET work_mem = '1MB';`
`670`		`-Set work_mem = '1MB';`
`671`		`-SET work_mem = '2MB';`
`672`		`-RESET work_mem;`
`673`		`-SET enable_seqscan = off;`
`674`		`-SET enable_seqscan = on;`
`675`		`-RESET enable_seqscan;`
`676`		`-SELECT calls, rows, query FROM pg_stat_statements ORDER BY query COLLATE "C";`
`677`		`- calls \| rows \| query`
`678`		`--------+------+-----------------------------------`
`679`		`- 1 \| 0 \| RESET enable_seqscan`
`680`		`- 1 \| 0 \| RESET work_mem`
`681`		`- 1 \| 1 \| SELECT pg_stat_statements_reset()`
`682`		`- 1 \| 0 \| SET enable_seqscan = off`
`683`		`- 1 \| 0 \| SET enable_seqscan = on`
`684`		`- 2 \| 0 \| SET work_mem = '1MB'`
`685`		`- 1 \| 0 \| SET work_mem = '2MB'`
`686`		`-(7 rows)`
`687`		`-`
`688`		`-SELECT pg_stat_statements_reset();`
`689`		`- pg_stat_statements_reset`
`690`		`---------------------------`
`691`		`-`
`692`		`-(1 row)`
`693`		`-`

Lines changed: 0 additions & 13 deletions

Original file line number	Diff line number	Diff line change
`@@ -329,16 +329,3 @@ DROP TABLE pgss_ctas;`
`329`	`329`	`DROPTABLE pgss_select_into;`
`330`	`330`
`331`	`331`	`SELECT pg_stat_statements_reset();`
`332`		`-`
`333`		`--- SET statements.`
`334`		`--- These use two different strings, still they count as one entry.`
`335`		`-SET work_mem='1MB';`
`336`		`-Set work_mem='1MB';`
`337`		`-SET work_mem='2MB';`
`338`		`-RESET work_mem;`
`339`		`-SET enable_seqscan= off;`
`340`		`-SET enable_seqscan=on;`
`341`		`-RESET enable_seqscan;`
`342`		`-`
`343`		`-SELECT calls, rows, queryFROM pg_stat_statementsORDER BY query COLLATE"C";`
`344`		`-SELECT pg_stat_statements_reset();`

Comments

(0)