Timing is on. Pager usage is off. Timing is off. Table "public.siri_vm" Column | Type | Modifiers ------------+--------------------------+------------------------------------------------------ id | bigint | not null default nextval('siri_vm_id_seq'::regclass) acp_id | text | location4d | geography(PointZM,4326) | acp_ts | timestamp with time zone | info | jsonb | file_ts | timestamp with time zone | line_ref | text | Indexes: "siri_vm_pkey" PRIMARY KEY, btree (id) "siri_vm_acp_id" btree (acp_id) "siri_vm_info" gin (info) "siri_vm_location4d" gist (location4d) "siri_vm_location4d_geom" gist ((location4d::geometry)) "siri_vm_ts" btree (acp_ts) Table "public.siri_vm2" Column | Type | Modifiers ---------------------+--------------------------+------------------------------------------------------- id | bigint | not null default nextval('siri_vm2_id_seq'::regclass) file_ts | timestamp with time zone | not null acp_id | character(20) | not null acp_ts | timestamp with time zone | not null location4d | geometry(PointZM,27700) | line_ref | character(10) | not null origin_ref | character(20) | not null origin_departure_ts | timestamp with time zone | not null info | jsonb | not null temp_geom | geometry(PointZM,4326) | not null Indexes: "siri_vm2_pkey" PRIMARY KEY, btree (id) "siri_vm2_acp_id" btree (acp_id) "siri_vm2_acp_ts" btree (acp_ts) "siri_vm2_line_ref" btree (line_ref) "siri_vm2_location4d" gist (location4d) "siri_vm2_origin_departure_ts" btree (origin_departure_ts) "siri_vm2_origin_ref" btree (origin_ref) Table "public.siri_vm_3" Column | Type | Modifiers ---------------+--------------------------+----------- file_ts | timestamp with time zone | not null location | geometry(Point,4326) | not null recorded_ts | timestamp with time zone | not null recorded_date | date | not null departure_ts | timestamp with time zone | not null info | jsonb | not null Indexes: "siri_vm_3_departure_ts" btree (departure_ts) "siri_vm_3_info" gin (info) "siri_vm_3_location" gist (location) "siri_vm_3_recorded_date" btree (recorded_date) "siri_vm_3_recorded_ts" btree (recorded_ts) Table "public.siri_vm_4" Column | Type | Modifiers ------------+-------------------------+----------- acp_id | character(20) | not null acp_lng | double precision | not null acp_lat | double precision | not null acp_ts | bigint | not null location2d | geography(Point,4326) | not null location4d | geography(PointZM,4326) | not null info | jsonb | not null Indexes: "siri_vm_4_acp_id" btree (acp_id) "siri_vm_4_acp_lat" btree (acp_lat) "siri_vm_4_acp_lng" btree (acp_lng) "siri_vm_4_acp_ts" btree (acp_ts) "siri_vm_4_info" gin (info) "siri_vm_4_location2d" gist (location2d) "siri_vm_4_location2d_geom" gist ((location2d::geometry)) "siri_vm_4_location4d" gist (location4d) "siri_vm_4_location4d_geom_nd" gist ((location4d::geometry) gist_geometry_ops_nd) Table "public.siri_vm_5" Column | Type | Modifiers -------------+-------------------------+----------- acp_id | character(20) | not null acp_lng | double precision | not null acp_lat | double precision | not null acp_ts | bigint | not null location2d | geography(Point,4326) | not null location4d | geography(PointZM,4326) | not null info | jsonb | not null acp_ts_date | date | Triggers: insert_siri_vm_5_trigger BEFORE INSERT ON siri_vm_5 FOR EACH ROW EXECUTE PROCEDURE siri_vm_5_insert_trigger() Number of child tables: 17 (Use \d+ to list them.) Table "public.siri_vm_5_2017_41" Column | Type | Modifiers -------------+-------------------------+----------- acp_id | character(20) | not null acp_lng | double precision | not null acp_lat | double precision | not null acp_ts | bigint | not null location2d | geography(Point,4326) | not null location4d | geography(PointZM,4326) | not null info | jsonb | not null acp_ts_date | date | Indexes: "siri_vm_5_2017_41_acp_id" btree (acp_id) "siri_vm_5_2017_41_acp_lat" btree (acp_lat) "siri_vm_5_2017_41_acp_lng" btree (acp_lng) "siri_vm_5_2017_41_acp_ts" btree (acp_ts) "siri_vm_5_2017_41_info" gin (info) "siri_vm_5_2017_41_location2d" gist (location2d) "siri_vm_5_2017_41_location2d_geom" gist ((location2d::geometry)) "siri_vm_5_2017_41_location4d" gist (location4d) "siri_vm_5_2017_41_location4d_geom_nd" gist ((location4d::geometry) gist_geometry_ops_nd) Check constraints: "siri_vm_5_2017_41_acp_ts_check" CHECK (acp_ts >= 1507507200 AND acp_ts < 1508112000) Inherits: siri_vm_5 tablename | records -------------------+-------------- siri_vm | 31,589,550 siri_vm2 | 35,614,880 siri_vm_3 | 37,214,904 siri_vm_4 | 37,980,660 siri_vm_5 | 0 siri_vm_5_2017_41 | 2,787,498 siri_vm_5_2017_42 | 4,825,375 siri_vm_5_2017_43 | 4,722,852 siri_vm_5_2017_44 | 4,770,517 siri_vm_5_2017_45 | 4,724,160 siri_vm_5_2017_46 | 4,746,715 siri_vm_5_2017_47 | 4,415,158 siri_vm_5_2017_48 | 4,740,164 siri_vm_5_2017_49 | 2,720,903 siri_vm_5_2017_50 | 0 siri_vm_5_2017_51 | 0 siri_vm_5_2017_52 | 0 siri_vm_5_2018_01 | 0 siri_vm_5_2018_02 | 0 siri_vm_5_2018_03 | 0 siri_vm_5_2018_04 | 0 siri_vm_5_2018_05 | 0 (22 rows) tablename | main | free_space_map | visability_map | initialisation | total -------------------+---------+----------------+----------------+----------------+--------- siri_vm | 30 GB | 7632 kB | 432 kB | 0 bytes | 30 GB siri_vm2 | 67 GB | 17 MB | 1080 kB | 0 bytes | 67 GB siri_vm_3 | 32 GB | 0 bytes | 0 bytes | 0 bytes | 32 GB siri_vm_4 | 32 GB | 8368 kB | 528 kB | 0 bytes | 32 GB siri_vm_5 | 0 bytes | 0 bytes | 0 bytes | 0 bytes | 0 bytes siri_vm_5_2017_41 | 2423 MB | 632 kB | 0 bytes | 0 bytes | 2424 MB siri_vm_5_2017_42 | 4194 MB | 1072 kB | 0 bytes | 0 bytes | 4195 MB siri_vm_5_2017_43 | 4103 MB | 1056 kB | 0 bytes | 0 bytes | 4104 MB siri_vm_5_2017_44 | 4143 MB | 1064 kB | 0 bytes | 0 bytes | 4144 MB siri_vm_5_2017_45 | 4101 MB | 1056 kB | 0 bytes | 0 bytes | 4102 MB siri_vm_5_2017_46 | 4121 MB | 1056 kB | 0 bytes | 0 bytes | 4122 MB siri_vm_5_2017_47 | 3834 MB | 984 kB | 0 bytes | 0 bytes | 3835 MB siri_vm_5_2017_48 | 4280 MB | 1096 kB | 0 bytes | 0 bytes | 4281 MB siri_vm_5_2017_49 | 2362 MB | 616 kB | 0 bytes | 0 bytes | 2363 MB siri_vm_5_2017_50 | 0 bytes | 0 bytes | 0 bytes | 0 bytes | 0 bytes siri_vm_5_2017_51 | 0 bytes | 0 bytes | 0 bytes | 0 bytes | 0 bytes siri_vm_5_2017_52 | 0 bytes | 0 bytes | 0 bytes | 0 bytes | 0 bytes siri_vm_5_2018_01 | 0 bytes | 0 bytes | 0 bytes | 0 bytes | 0 bytes siri_vm_5_2018_02 | 0 bytes | 0 bytes | 0 bytes | 0 bytes | 0 bytes siri_vm_5_2018_03 | 0 bytes | 0 bytes | 0 bytes | 0 bytes | 0 bytes siri_vm_5_2018_04 | 0 bytes | 0 bytes | 0 bytes | 0 bytes | 0 bytes siri_vm_5_2018_05 | 0 bytes | 0 bytes | 0 bytes | 0 bytes | 0 bytes (22 rows) tablename | indexname | size -------------------+--------------------------------------+------------ siri_vm | siri_vm_acp_id | 1056 MB siri_vm | siri_vm_info | 8081 MB siri_vm | siri_vm_location4d | 2548 MB siri_vm | siri_vm_location4d_geom | 1731 MB siri_vm | siri_vm_pkey | 816 MB siri_vm | siri_vm_ts | 775 MB siri_vm2 | siri_vm2_acp_id | 1379 MB siri_vm2 | siri_vm2_acp_ts | 763 MB siri_vm2 | siri_vm2_line_ref | 1071 MB siri_vm2 | siri_vm2_location4d | 2020 MB siri_vm2 | siri_vm2_origin_departure_ts | 763 MB siri_vm2 | siri_vm2_origin_ref | 1379 MB siri_vm2 | siri_vm2_pkey | 763 MB siri_vm_3 | siri_vm_3_departure_ts | 797 MB siri_vm_3 | siri_vm_3_info | 4269 MB siri_vm_3 | siri_vm_3_location | 1972 MB siri_vm_3 | siri_vm_3_recorded_date | 797 MB siri_vm_3 | siri_vm_3_recorded_ts | 797 MB siri_vm_4 | siri_vm_4_acp_id | 1471 MB siri_vm_4 | siri_vm_4_acp_lat | 814 MB siri_vm_4 | siri_vm_4_acp_lng | 814 MB siri_vm_4 | siri_vm_4_acp_ts | 814 MB siri_vm_4 | siri_vm_4_info | 4356 MB siri_vm_4 | siri_vm_4_location2d | 2848 MB siri_vm_4 | siri_vm_4_location2d_geom | 2018 MB siri_vm_4 | siri_vm_4_location4d | 2841 MB siri_vm_4 | siri_vm_4_location4d_geom_nd | 3482 MB siri_vm_5_2017_41 | siri_vm_5_2017_41_acp_id | 108 MB siri_vm_5_2017_41 | siri_vm_5_2017_41_acp_lat | 60 MB siri_vm_5_2017_41 | siri_vm_5_2017_41_acp_lng | 60 MB siri_vm_5_2017_41 | siri_vm_5_2017_41_acp_ts | 60 MB siri_vm_5_2017_41 | siri_vm_5_2017_41_info | 458 MB siri_vm_5_2017_41 | siri_vm_5_2017_41_location2d | 209 MB siri_vm_5_2017_41 | siri_vm_5_2017_41_location2d_geom | 155 MB siri_vm_5_2017_41 | siri_vm_5_2017_41_location4d | 209 MB siri_vm_5_2017_41 | siri_vm_5_2017_41_location4d_geom_nd | 258 MB siri_vm_5_2017_42 | siri_vm_5_2017_42_acp_id | 187 MB siri_vm_5_2017_42 | siri_vm_5_2017_42_acp_lat | 103 MB siri_vm_5_2017_42 | siri_vm_5_2017_42_acp_lng | 103 MB siri_vm_5_2017_42 | siri_vm_5_2017_42_acp_ts | 103 MB siri_vm_5_2017_42 | siri_vm_5_2017_42_info | 717 MB siri_vm_5_2017_42 | siri_vm_5_2017_42_location2d | 361 MB siri_vm_5_2017_42 | siri_vm_5_2017_42_location2d_geom | 269 MB siri_vm_5_2017_42 | siri_vm_5_2017_42_location4d | 360 MB siri_vm_5_2017_42 | siri_vm_5_2017_42_location4d_geom_nd | 443 MB siri_vm_5_2017_43 | siri_vm_5_2017_43_acp_id | 183 MB siri_vm_5_2017_43 | siri_vm_5_2017_43_acp_lat | 101 MB siri_vm_5_2017_43 | siri_vm_5_2017_43_acp_lng | 101 MB siri_vm_5_2017_43 | siri_vm_5_2017_43_acp_ts | 101 MB siri_vm_5_2017_43 | siri_vm_5_2017_43_info | 703 MB siri_vm_5_2017_43 | siri_vm_5_2017_43_location2d | 355 MB siri_vm_5_2017_43 | siri_vm_5_2017_43_location2d_geom | 265 MB siri_vm_5_2017_43 | siri_vm_5_2017_43_location4d | 355 MB siri_vm_5_2017_43 | siri_vm_5_2017_43_location4d_geom_nd | 423 MB siri_vm_5_2017_44 | siri_vm_5_2017_44_acp_id | 185 MB siri_vm_5_2017_44 | siri_vm_5_2017_44_acp_lat | 102 MB siri_vm_5_2017_44 | siri_vm_5_2017_44_acp_lng | 102 MB siri_vm_5_2017_44 | siri_vm_5_2017_44_acp_ts | 102 MB siri_vm_5_2017_44 | siri_vm_5_2017_44_info | 712 MB siri_vm_5_2017_44 | siri_vm_5_2017_44_location2d | 357 MB siri_vm_5_2017_44 | siri_vm_5_2017_44_location2d_geom | 264 MB siri_vm_5_2017_44 | siri_vm_5_2017_44_location4d | 357 MB siri_vm_5_2017_44 | siri_vm_5_2017_44_location4d_geom_nd | 426 MB siri_vm_5_2017_45 | siri_vm_5_2017_45_acp_id | 183 MB siri_vm_5_2017_45 | siri_vm_5_2017_45_acp_lat | 101 MB siri_vm_5_2017_45 | siri_vm_5_2017_45_acp_lng | 101 MB siri_vm_5_2017_45 | siri_vm_5_2017_45_acp_ts | 101 MB siri_vm_5_2017_45 | siri_vm_5_2017_45_info | 706 MB siri_vm_5_2017_45 | siri_vm_5_2017_45_location2d | 355 MB siri_vm_5_2017_45 | siri_vm_5_2017_45_location2d_geom | 263 MB siri_vm_5_2017_45 | siri_vm_5_2017_45_location4d | 354 MB siri_vm_5_2017_45 | siri_vm_5_2017_45_location4d_geom_nd | 435 MB siri_vm_5_2017_46 | siri_vm_5_2017_46_acp_id | 184 MB siri_vm_5_2017_46 | siri_vm_5_2017_46_acp_lat | 102 MB siri_vm_5_2017_46 | siri_vm_5_2017_46_acp_lng | 102 MB siri_vm_5_2017_46 | siri_vm_5_2017_46_acp_ts | 102 MB siri_vm_5_2017_46 | siri_vm_5_2017_46_info | 708 MB siri_vm_5_2017_46 | siri_vm_5_2017_46_location2d | 357 MB siri_vm_5_2017_46 | siri_vm_5_2017_46_location2d_geom | 265 MB siri_vm_5_2017_46 | siri_vm_5_2017_46_location4d | 355 MB siri_vm_5_2017_46 | siri_vm_5_2017_46_location4d_geom_nd | 439 MB siri_vm_5_2017_47 | siri_vm_5_2017_47_acp_id | 171 MB siri_vm_5_2017_47 | siri_vm_5_2017_47_acp_lat | 95 MB siri_vm_5_2017_47 | siri_vm_5_2017_47_acp_lng | 95 MB siri_vm_5_2017_47 | siri_vm_5_2017_47_acp_ts | 95 MB siri_vm_5_2017_47 | siri_vm_5_2017_47_info | 672 MB siri_vm_5_2017_47 | siri_vm_5_2017_47_location2d | 332 MB siri_vm_5_2017_47 | siri_vm_5_2017_47_location2d_geom | 248 MB siri_vm_5_2017_47 | siri_vm_5_2017_47_location4d | 332 MB siri_vm_5_2017_47 | siri_vm_5_2017_47_location4d_geom_nd | 416 MB siri_vm_5_2017_48 | siri_vm_5_2017_48_acp_id | 184 MB siri_vm_5_2017_48 | siri_vm_5_2017_48_acp_lat | 102 MB siri_vm_5_2017_48 | siri_vm_5_2017_48_acp_lng | 102 MB siri_vm_5_2017_48 | siri_vm_5_2017_48_acp_ts | 102 MB siri_vm_5_2017_48 | siri_vm_5_2017_48_info | 713 MB siri_vm_5_2017_48 | siri_vm_5_2017_48_location2d | 356 MB siri_vm_5_2017_48 | siri_vm_5_2017_48_location2d_geom | 263 MB siri_vm_5_2017_48 | siri_vm_5_2017_48_location4d | 356 MB siri_vm_5_2017_48 | siri_vm_5_2017_48_location4d_geom_nd | 437 MB siri_vm_5_2017_49 | siri_vm_5_2017_49_acp_id | 105 MB siri_vm_5_2017_49 | siri_vm_5_2017_49_acp_lat | 58 MB siri_vm_5_2017_49 | siri_vm_5_2017_49_acp_lng | 58 MB siri_vm_5_2017_49 | siri_vm_5_2017_49_acp_ts | 58 MB siri_vm_5_2017_49 | siri_vm_5_2017_49_info | 443 MB siri_vm_5_2017_49 | siri_vm_5_2017_49_location2d | 206 MB siri_vm_5_2017_49 | siri_vm_5_2017_49_location2d_geom | 154 MB siri_vm_5_2017_49 | siri_vm_5_2017_49_location4d | 206 MB siri_vm_5_2017_49 | siri_vm_5_2017_49_location4d_geom_nd | 253 MB siri_vm_5_2017_50 | siri_vm_5_2017_50_acp_id | 8192 bytes siri_vm_5_2017_50 | siri_vm_5_2017_50_acp_lat | 8192 bytes siri_vm_5_2017_50 | siri_vm_5_2017_50_acp_lng | 8192 bytes siri_vm_5_2017_50 | siri_vm_5_2017_50_acp_ts | 8192 bytes siri_vm_5_2017_50 | siri_vm_5_2017_50_info | 16 kB siri_vm_5_2017_50 | siri_vm_5_2017_50_location2d | 8192 bytes siri_vm_5_2017_50 | siri_vm_5_2017_50_location2d_geom | 8192 bytes siri_vm_5_2017_50 | siri_vm_5_2017_50_location4d | 8192 bytes siri_vm_5_2017_50 | siri_vm_5_2017_50_location4d_geom_nd | 8192 bytes siri_vm_5_2017_51 | siri_vm_5_2017_51_acp_id | 8192 bytes siri_vm_5_2017_51 | siri_vm_5_2017_51_acp_lat | 8192 bytes siri_vm_5_2017_51 | siri_vm_5_2017_51_acp_lng | 8192 bytes siri_vm_5_2017_51 | siri_vm_5_2017_51_acp_ts | 8192 bytes siri_vm_5_2017_51 | siri_vm_5_2017_51_info | 16 kB siri_vm_5_2017_51 | siri_vm_5_2017_51_location2d | 8192 bytes siri_vm_5_2017_51 | siri_vm_5_2017_51_location2d_geom | 8192 bytes siri_vm_5_2017_51 | siri_vm_5_2017_51_location4d | 8192 bytes siri_vm_5_2017_51 | siri_vm_5_2017_51_location4d_geom_nd | 8192 bytes siri_vm_5_2017_52 | siri_vm_5_2017_52_acp_id | 8192 bytes siri_vm_5_2017_52 | siri_vm_5_2017_52_acp_lat | 8192 bytes siri_vm_5_2017_52 | siri_vm_5_2017_52_acp_lng | 8192 bytes siri_vm_5_2017_52 | siri_vm_5_2017_52_acp_ts | 8192 bytes siri_vm_5_2017_52 | siri_vm_5_2017_52_info | 16 kB siri_vm_5_2017_52 | siri_vm_5_2017_52_location2d | 8192 bytes siri_vm_5_2017_52 | siri_vm_5_2017_52_location2d_geom | 8192 bytes siri_vm_5_2017_52 | siri_vm_5_2017_52_location4d | 8192 bytes siri_vm_5_2017_52 | siri_vm_5_2017_52_location4d_geom_nd | 8192 bytes siri_vm_5_2018_01 | siri_vm_5_2018_01_acp_id | 8192 bytes siri_vm_5_2018_01 | siri_vm_5_2018_01_acp_lat | 8192 bytes siri_vm_5_2018_01 | siri_vm_5_2018_01_acp_lng | 8192 bytes siri_vm_5_2018_01 | siri_vm_5_2018_01_acp_ts | 8192 bytes siri_vm_5_2018_01 | siri_vm_5_2018_01_info | 16 kB siri_vm_5_2018_01 | siri_vm_5_2018_01_location2d | 8192 bytes siri_vm_5_2018_01 | siri_vm_5_2018_01_location2d_geom | 8192 bytes siri_vm_5_2018_01 | siri_vm_5_2018_01_location4d | 8192 bytes siri_vm_5_2018_01 | siri_vm_5_2018_01_location4d_geom_nd | 8192 bytes siri_vm_5_2018_02 | siri_vm_5_2018_02_acp_id | 8192 bytes siri_vm_5_2018_02 | siri_vm_5_2018_02_acp_lat | 8192 bytes siri_vm_5_2018_02 | siri_vm_5_2018_02_acp_lng | 8192 bytes siri_vm_5_2018_02 | siri_vm_5_2018_02_acp_ts | 8192 bytes siri_vm_5_2018_02 | siri_vm_5_2018_02_info | 16 kB siri_vm_5_2018_02 | siri_vm_5_2018_02_location2d | 8192 bytes siri_vm_5_2018_02 | siri_vm_5_2018_02_location2d_geom | 8192 bytes siri_vm_5_2018_02 | siri_vm_5_2018_02_location4d | 8192 bytes siri_vm_5_2018_02 | siri_vm_5_2018_02_location4d_geom_nd | 8192 bytes siri_vm_5_2018_03 | siri_vm_5_2018_03_acp_id | 8192 bytes siri_vm_5_2018_03 | siri_vm_5_2018_03_acp_lat | 8192 bytes siri_vm_5_2018_03 | siri_vm_5_2018_03_acp_lng | 8192 bytes siri_vm_5_2018_03 | siri_vm_5_2018_03_acp_ts | 8192 bytes siri_vm_5_2018_03 | siri_vm_5_2018_03_info | 16 kB siri_vm_5_2018_03 | siri_vm_5_2018_03_location2d | 8192 bytes siri_vm_5_2018_03 | siri_vm_5_2018_03_location2d_geom | 8192 bytes siri_vm_5_2018_03 | siri_vm_5_2018_03_location4d | 8192 bytes siri_vm_5_2018_03 | siri_vm_5_2018_03_location4d_geom_nd | 8192 bytes siri_vm_5_2018_04 | siri_vm_5_2018_04_acp_id | 8192 bytes siri_vm_5_2018_04 | siri_vm_5_2018_04_acp_lat | 8192 bytes siri_vm_5_2018_04 | siri_vm_5_2018_04_acp_lng | 8192 bytes siri_vm_5_2018_04 | siri_vm_5_2018_04_acp_ts | 8192 bytes siri_vm_5_2018_04 | siri_vm_5_2018_04_info | 16 kB siri_vm_5_2018_04 | siri_vm_5_2018_04_location2d | 8192 bytes siri_vm_5_2018_04 | siri_vm_5_2018_04_location2d_geom | 8192 bytes siri_vm_5_2018_04 | siri_vm_5_2018_04_location4d | 8192 bytes siri_vm_5_2018_04 | siri_vm_5_2018_04_location4d_geom_nd | 8192 bytes siri_vm_5_2018_05 | siri_vm_5_2018_05_acp_id | 8192 bytes siri_vm_5_2018_05 | siri_vm_5_2018_05_acp_lat | 8192 bytes siri_vm_5_2018_05 | siri_vm_5_2018_05_acp_lng | 8192 bytes siri_vm_5_2018_05 | siri_vm_5_2018_05_acp_ts | 8192 bytes siri_vm_5_2018_05 | siri_vm_5_2018_05_info | 16 kB siri_vm_5_2018_05 | siri_vm_5_2018_05_location2d | 8192 bytes siri_vm_5_2018_05 | siri_vm_5_2018_05_location2d_geom | 8192 bytes siri_vm_5_2018_05 | siri_vm_5_2018_05_location4d | 8192 bytes siri_vm_5_2018_05 | siri_vm_5_2018_05_location4d_geom_nd | 8192 bytes (180 rows)