File: activity.sql

package info (click to toggle)
pg-stat-plans 2.0.0-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 588 kB
  • sloc: ansic: 2,388; sql: 134; makefile: 22; sh: 2
file content (19 lines) | stat: -rw-r--r-- 414 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
 

SELECT pg_stat_plans_reset() IS NOT NULL AS t;

--
-- check if we see our own plan in activity
--

SELECT plan FROM pg_stat_plans_activity WHERE pid = pg_backend_pid();


--
-- check if we handle showing our plan for named prepared statements correctly
--

PREPARE x AS SELECT plan FROM pg_stat_plans_activity WHERE pid = pg_backend_pid();
EXECUTE x;
DEALLOCATE x;

SELECT pg_stat_plans_reset() IS NOT NULL AS t;