bidder impressions Table public impressions Column Type Collation Null

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
bidder=# \d+ impressions;
Table "public.impressions"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
----------------+------------------------+-----------+----------+---------+----------+--------------+-------------
auction_id | character varying(254) | | not null | | extended | |
impressiondate | date | | not null | | plain | |
Partition key: RANGE (impressiondate)
Partitions: impressions_y2019m02d24 FOR VALUES FROM ('2019-02-24') TO ('2019-02-25'),
impressions_y2019m02d25 FOR VALUES FROM ('2019-02-25') TO ('2019-02-26'),
impressions_y2019m02d26 FOR VALUES FROM ('2019-02-26') TO ('2019-02-27'),
impressions_y2019m02d27 FOR VALUES FROM ('2019-02-27') TO ('2019-02-28'),
impressions_y2019m02d28 FOR VALUES FROM ('2019-02-28') TO ('2019-03-01'),
impressions_y2019m03d01 FOR VALUES FROM ('2019-03-01') TO ('2019-03-02'),
impressions_y2019m03d02 FOR VALUES FROM ('2019-03-02') TO ('2019-03-03'),
impressions_y2019m03d03 FOR VALUES FROM ('2019-03-03') TO ('2019-03-04'),
impressions_y2019m03d04 FOR VALUES FROM ('2019-03-04') TO ('2019-03-05'),
impressions_y2019m03d05 FOR VALUES FROM ('2019-03-05') TO ('2019-03-06'),
impressions_y2019m03d06 FOR VALUES FROM ('2019-03-06') TO ('2019-03-07'),
impressions_y2019m03d07 FOR VALUES FROM ('2019-03-07') TO ('2019-03-08'),
impressions_y2019m03d08 FOR VALUES FROM ('2019-03-08') TO ('2019-03-09'),
impressions_y2019m03d09 FOR VALUES FROM ('2019-03-09') TO ('2019-03-10'),
impressions_y2019m03d10 FOR VALUES FROM ('2019-03-10') TO ('2019-03-11'),
impressions_y2019m03d11 FOR VALUES FROM ('2019-03-11') TO ('2019-03-12'),
impressions_y2019m03d12 FOR VALUES FROM ('2019-03-12') TO ('2019-03-13'),
impressions_y2019m03d13 FOR VALUES FROM ('2019-03-13') TO ('2019-03-14'),
impressions_y2019m03d14 FOR VALUES FROM ('2019-03-14') TO ('2019-03-15'),
impressions_y2019m03d15 FOR VALUES FROM ('2019-03-15') TO ('2019-03-16'),
impressions_y2019m03d16 FOR VALUES FROM ('2019-03-16') TO ('2019-03-17'),
impressions_y2019m03d17 FOR VALUES FROM ('2019-03-17') TO ('2019-03-18'),
impressions_y2019m03d18 FOR VALUES FROM ('2019-03-18') TO ('2019-03-19'),
impressions_y2019m03d19 FOR VALUES FROM ('2019-03-19') TO ('2019-03-20'),
impressions_y2019m03d20 FOR VALUES FROM ('2019-03-20') TO ('2019-03-21'),
impressions_y2019m03d21 FOR VALUES FROM ('2019-03-21') TO ('2019-03-22'),
impressions_y2019m03d22 FOR VALUES FROM ('2019-03-22') TO ('2019-03-23'),
impressions_y2019m03d23 FOR VALUES FROM ('2019-03-23') TO ('2019-03-24'),
impressions_y2019m03d24 FOR VALUES FROM ('2019-03-24') TO ('2019-03-25'),
impressions_y2019m03d25 FOR VALUES FROM ('2019-03-25') TO ('2019-03-26')