File: ddl_create_table.sql

package info (click to toggle)
libpg-query 17-6.2.0-2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 33,416 kB
  • sloc: ansic: 175,684; sql: 79,564; ruby: 1,605; makefile: 276; cpp: 221
file content (14 lines) | stat: -rw-r--r-- 503 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
 
CREATE TABLE public.vacuum_run_stats_35d (
    vacuum_run_stats_id uuid DEFAULT public.gen_random_uuid() NOT NULL,
    server_id uuid NOT NULL,
    vacuum_run_id uuid NOT NULL,
    collected_at timestamp NOT NULL,
    phase int NOT NULL,
    heap_blks_total bigint NOT NULL,
    heap_blks_scanned bigint NOT NULL,
    heap_blks_vacuumed bigint NOT NULL,
    index_vacuum_count bigint NOT NULL,
    max_dead_tuples bigint NOT NULL,
    num_dead_tuples bigint NOT NULL
)
PARTITION BY RANGE (collected_at)