| 1 | -- pg_stat_monitor initialization script |
| 2 | CREATE EXTENSION IF NOT EXISTS pg_stat_monitor; |
| 3 | |
| 4 | CREATE TABLE IF NOT EXISTS public.sample ( |
| 5 | id SERIAL PRIMARY KEY, |
| 6 | name TEXT NOT NULL, |
| 7 | value INTEGER NOT NULL |
| 8 | ); |
| 9 | |
| 10 | INSERT INTO public.sample (name, value) |
| 11 | VALUES |
| 12 | ('alpha', 10), |
| 13 | ('beta', 20), |
| 14 | ('gamma', 30); |
| 15 | |
| 16 | SELECT COUNT(*) FROM public.sample; |
| 17 | SELECT * FROM public.sample WHERE value > 15; |
| 18 | UPDATE public.sample SET value = value + 1 WHERE name = 'alpha'; |