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