Skip to content

Commit c5a032e

Browse files
danielgustafssondanielgustafsson
committed
Update oldextversions test for pg_stat_statements 1.11
Commit 5a3423a updated pg_stat_statements to 1.11 due to added columns in the view for jit deform counters. Fixing oldextversion was however missed in that commit. This adds a test for the 1.11 version view definition. Author: Nazir Bilal Yavuz <byavuz81@gmail.com> Discussion: https://postgr.es/m/CAN55FZ2Y7c2VEg4S1KDXFcaHjyF8=KZa_rMV6WOe+KwE-KE97g@mail.gmail.com
1 parent 536f410 commit c5a032e

File tree

2 files changed

+63
-0
lines changed

2 files changed

+63
-0
lines changed

‎contrib/pg_stat_statements/expected/oldextversions.out

+58
Original file line numberDiff line numberDiff line change
@@ -250,4 +250,62 @@ SELECT count(*) > 0 AS has_data FROM pg_stat_statements;
250250
t
251251
(1 row)
252252

253+
-- New views for pg_stat_statements in 1.11
254+
AlTER EXTENSION pg_stat_statements UPDATE TO '1.11';
255+
\d pg_stat_statements
256+
View "public.pg_stat_statements"
257+
Column | Type | Collation | Nullable | Default
258+
------------------------+------------------+-----------+----------+---------
259+
userid | oid | | |
260+
dbid | oid | | |
261+
toplevel | boolean | | |
262+
queryid | bigint | | |
263+
query | text | | |
264+
plans | bigint | | |
265+
total_plan_time | double precision | | |
266+
min_plan_time | double precision | | |
267+
max_plan_time | double precision | | |
268+
mean_plan_time | double precision | | |
269+
stddev_plan_time | double precision | | |
270+
calls | bigint | | |
271+
total_exec_time | double precision | | |
272+
min_exec_time | double precision | | |
273+
max_exec_time | double precision | | |
274+
mean_exec_time | double precision | | |
275+
stddev_exec_time | double precision | | |
276+
rows | bigint | | |
277+
shared_blks_hit | bigint | | |
278+
shared_blks_read | bigint | | |
279+
shared_blks_dirtied | bigint | | |
280+
shared_blks_written | bigint | | |
281+
local_blks_hit | bigint | | |
282+
local_blks_read | bigint | | |
283+
local_blks_dirtied | bigint | | |
284+
local_blks_written | bigint | | |
285+
temp_blks_read | bigint | | |
286+
temp_blks_written | bigint | | |
287+
blk_read_time | double precision | | |
288+
blk_write_time | double precision | | |
289+
temp_blk_read_time | double precision | | |
290+
temp_blk_write_time | double precision | | |
291+
wal_records | bigint | | |
292+
wal_fpi | bigint | | |
293+
wal_bytes | numeric | | |
294+
jit_functions | bigint | | |
295+
jit_generation_time | double precision | | |
296+
jit_inlining_count | bigint | | |
297+
jit_inlining_time | double precision | | |
298+
jit_optimization_count | bigint | | |
299+
jit_optimization_time | double precision | | |
300+
jit_emission_count | bigint | | |
301+
jit_emission_time | double precision | | |
302+
jit_deform_count | bigint | | |
303+
jit_deform_time | double precision | | |
304+
305+
SELECT count(*) > 0 AS has_data FROM pg_stat_statements;
306+
has_data
307+
----------
308+
t
309+
(1 row)
310+
253311
DROP EXTENSION pg_stat_statements;

‎contrib/pg_stat_statements/sql/oldextversions.sql

+5
Original file line numberDiff line numberDiff line change
@@ -48,4 +48,9 @@ AlTER EXTENSION pg_stat_statements UPDATE TO '1.10';
4848
\d pg_stat_statements
4949
SELECT count(*) > 0 AS has_data FROM pg_stat_statements;
5050

51+
-- New views for pg_stat_statements in 1.11
52+
AlTER EXTENSION pg_stat_statements UPDATE TO '1.11';
53+
\d pg_stat_statements
54+
SELECT count(*) > 0 AS has_data FROM pg_stat_statements;
55+
5156
DROP EXTENSION pg_stat_statements;

0 commit comments

Comments
 (0)