Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

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

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitec22496

Browse files
author
dmitry
committed
add version 1.2
1 parentb2cf2a6 commitec22496

5 files changed

+143
-13
lines changed

‎pg_wait_sampling--1.0--1.1.sql

Lines changed: 1 addition & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -26,10 +26,7 @@ CREATE FUNCTION pg_wait_sampling_get_current (
2626
OUT pid int4,
2727
OUT event_typetext,
2828
OUT eventtext,
29-
OUT queryid int8,
30-
OUT isregularbackendboolean,
31-
OUT databaseidoid,
32-
OUT roleidoid
29+
OUT queryid int8
3330
)
3431
RETURNS SETOF record
3532
AS'MODULE_PATHNAME'

‎pg_wait_sampling--1.1--1.2.sql

Lines changed: 73 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,73 @@
1+
/* contrib/pg_wait_sampling/pg_wait_sampling--1.0--1.1.sql*/
2+
3+
DROPFUNCTION pg_wait_sampling_get_current (
4+
pid int4,
5+
OUT pid int4,
6+
OUT event_typetext,
7+
OUT eventtext
8+
) CASCADE;
9+
10+
DROPFUNCTION pg_wait_sampling_get_history (
11+
OUT pid int4,
12+
OUT tstimestamptz,
13+
OUT event_typetext,
14+
OUT eventtext
15+
) CASCADE;
16+
17+
DROPFUNCTION pg_wait_sampling_get_profile (
18+
OUT pid int4,
19+
OUT event_typetext,
20+
OUT eventtext,
21+
OUT countbigint
22+
) CASCADE;
23+
24+
CREATEFUNCTIONpg_wait_sampling_get_current (
25+
pid int4,
26+
OUT pid int4,
27+
OUT event_typetext,
28+
OUT eventtext,
29+
OUT queryid int8,
30+
OUT isregularbackendboolean,
31+
OUT databaseidoid,
32+
OUT roleidoid
33+
)
34+
RETURNS SETOF record
35+
AS'MODULE_PATHNAME'
36+
LANGUAGE C VOLATILE CALLEDONNULL INPUT;
37+
38+
CREATEVIEWpg_wait_sampling_currentAS
39+
SELECT*FROM pg_wait_sampling_get_current(NULL::integer);
40+
41+
GRANTSELECTON pg_wait_sampling_current TO PUBLIC;
42+
43+
CREATEFUNCTIONpg_wait_sampling_get_history (
44+
OUT pid int4,
45+
OUT tstimestamptz,
46+
OUT event_typetext,
47+
OUT eventtext,
48+
OUT queryid int8
49+
)
50+
RETURNS SETOF record
51+
AS'MODULE_PATHNAME'
52+
LANGUAGE C VOLATILE STRICT;
53+
54+
CREATEVIEWpg_wait_sampling_historyAS
55+
SELECT*FROM pg_wait_sampling_get_history();
56+
57+
GRANTSELECTON pg_wait_sampling_history TO PUBLIC;
58+
59+
CREATEFUNCTIONpg_wait_sampling_get_profile (
60+
OUT pid int4,
61+
OUT event_typetext,
62+
OUT eventtext,
63+
OUT queryid int8,
64+
OUT count int8
65+
)
66+
RETURNS SETOF record
67+
AS'MODULE_PATHNAME'
68+
LANGUAGE C VOLATILE STRICT;
69+
70+
CREATEVIEWpg_wait_sampling_profileAS
71+
SELECT*FROM pg_wait_sampling_get_profile();
72+
73+
GRANTSELECTON pg_wait_sampling_profile TO PUBLIC;

‎pg_wait_sampling--1.1.sql

Lines changed: 2 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -8,10 +8,7 @@ CREATE FUNCTION pg_wait_sampling_get_current (
88
OUT pid int4,
99
OUT event_typetext,
1010
OUT eventtext,
11-
OUT queryid int8,
12-
OUT isregularbackendboolean,
13-
OUT databaseidoid,
14-
OUT roleidoid
11+
OUT queryid int8
1512
)
1613
RETURNS SETOF record
1714
AS'MODULE_PATHNAME'
@@ -27,10 +24,7 @@ CREATE FUNCTION pg_wait_sampling_get_history (
2724
OUT tstimestamptz,
2825
OUT event_typetext,
2926
OUT eventtext,
30-
OUT queryid int8,
31-
OUT isregularbackendboolean,
32-
OUT databaseidoid,
33-
OUT roleidoid
27+
OUT queryid int8
3428
)
3529
RETURNS SETOF record
3630
AS'MODULE_PATHNAME'

‎pg_wait_sampling--1.2.sql

Lines changed: 66 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,66 @@
1+
/* contrib/pg_wait_sampling/setup.sql*/
2+
3+
-- complain if script is sourced in psql, rather than via CREATE EXTENSION
4+
\echo Use"CREATE EXTENSION pg_wait_sampling" to load this file. \quit
5+
6+
CREATEFUNCTIONpg_wait_sampling_get_current (
7+
pid int4,
8+
OUT pid int4,
9+
OUT event_typetext,
10+
OUT eventtext,
11+
OUT queryid int8,
12+
OUT isregularbackendboolean,
13+
OUT databaseidoid,
14+
OUT roleidoid
15+
)
16+
RETURNS SETOF record
17+
AS'MODULE_PATHNAME'
18+
LANGUAGE C VOLATILE CALLEDONNULL INPUT;
19+
20+
CREATEVIEWpg_wait_sampling_currentAS
21+
SELECT*FROM pg_wait_sampling_get_current(NULL::integer);
22+
23+
GRANTSELECTON pg_wait_sampling_current TO PUBLIC;
24+
25+
CREATEFUNCTIONpg_wait_sampling_get_history (
26+
OUT pid int4,
27+
OUT tstimestamptz,
28+
OUT event_typetext,
29+
OUT eventtext,
30+
OUT queryid int8,
31+
OUT isregularbackendboolean,
32+
OUT databaseidoid,
33+
OUT roleidoid
34+
)
35+
RETURNS SETOF record
36+
AS'MODULE_PATHNAME'
37+
LANGUAGE C VOLATILE STRICT;
38+
39+
CREATEVIEWpg_wait_sampling_historyAS
40+
SELECT*FROM pg_wait_sampling_get_history();
41+
42+
GRANTSELECTON pg_wait_sampling_history TO PUBLIC;
43+
44+
CREATEFUNCTIONpg_wait_sampling_get_profile (
45+
OUT pid int4,
46+
OUT event_typetext,
47+
OUT eventtext,
48+
OUT queryid int8,
49+
OUT count int8
50+
)
51+
RETURNS SETOF record
52+
AS'MODULE_PATHNAME'
53+
LANGUAGE C VOLATILE STRICT;
54+
55+
CREATEVIEWpg_wait_sampling_profileAS
56+
SELECT*FROM pg_wait_sampling_get_profile();
57+
58+
GRANTSELECTON pg_wait_sampling_profile TO PUBLIC;
59+
60+
CREATEFUNCTIONpg_wait_sampling_reset_profile()
61+
RETURNS void
62+
AS'MODULE_PATHNAME'
63+
LANGUAGE C VOLATILE STRICT;
64+
65+
-- Don't want this to be available to non-superusers.
66+
REVOKE ALLON FUNCTION pg_wait_sampling_reset_profile()FROM PUBLIC;

‎pg_wait_sampling.control

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
# pg_wait_sampling extension
22
comment = 'sampling based statistics of wait events'
3-
default_version = '1.1'
3+
default_version = '1.2'
44
module_pathname = '$libdir/pg_wait_sampling'
55
relocatable = true

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp