tablename indexname num_rows table index u scans read fetch tblspc
marker idx_marker_source_class_subclass_lat_lon_elems 6.49206e+07 35 GB 10 GB Y 43027723 4107059124 3797662353 ssd
marker idx_marker_lat_lon 6.49206e+07 35 GB 5086 MB Y 534353 254582483 158910019  
marker idx_marker_source_class 6.49206e+07 35 GB 3325 MB Y 1694194 452350069 155082139 ssd
marker idx_marker_item 6.49206e+07 35 GB 3186 MB Y 365390 852759569 84177977 ssd
marker marker_pkey 6.49206e+07 35 GB 2583 MB Y 139219249 139219204 139218369 ssd
marker_elem idx_marker_elem_data_type_id 7.10773e+07 15 GB 6432 MB Y 0 0 0 ssd
marker_elem idx_marker_elem_username 7.10773e+07 15 GB 5183 MB Y 21839 76514276 5980068 ssd
marker_elem marker_elem_pkey 7.10773e+07 15 GB 4903 MB Y 66202194 77941048 77838929 ssd
dynpoi_stats dynpoi_stats_pkey 1.389e+08 8062 MB 9147 MB Y 52802 41111414 41111414 ssd
dynpoi_stats dynpoi_stats_timestamp 1.389e+08 8062 MB 3708 MB Y 12 12 12 ssd
dynpoi_update dynpoi_update_pkey 1.63846e+07 2837 MB 637 MB Y 0 0 0  
dynpoi_update idx_dynpoi_update_source_timestamp 1.63846e+07 2837 MB 637 MB Y 0 0 0  
dynpoi_update dynpoi_update_source_timestamp 1.63846e+07 2837 MB 637 MB Y 474 475 474  
dynpoi_update idx_dynpoi_update_source 1.63846e+07 2837 MB 441 MB Y 2 405 405 ssd
dynpoi_update idx_dynpoi_update_timestamp 1.63846e+07 2837 MB 387 MB Y 0 0 0 ssd
marker_fix marker_fix_pkey 9.57679e+06 1504 MB 2718 MB Y 72609448 10842486 10290342 ssd
dynpoi_class idx_dynpoi_class_level 582672 1174 MB 86 MB Y 136 8216923 0 ssd
dynpoi_class idx_dynpoi_class_class 582672 1174 MB 70 MB Y 756426 857497 756333  
dynpoi_class idx_dynpoi_class_item 582672 1174 MB 70 MB Y 1477 2127909 329  
dynpoi_class dynpoi_class_pkey 582672 1174 MB 27 MB Y 131366881 135504842 133333492 ssd
dynpoi_class idx_dynpoi_class_source 582672 1174 MB 26 MB Y 1271961 2204981 1564965  
dynpoi_status dynpoi_status_pkey 195651 67 MB 48 MB Y 172935 588273 9626  
dynpoi_status dynpoi_status_id 195651 67 MB 41 MB Y 0 0 0  
dynpoi_update_last dynpoi_update_last_pkey 29098 4176 kB 1376 kB Y 27296719 27431027 27431026 ssd
dynpoi_item dynpoi_item_marker 492 3488 kB 48 kB Y 0 0 0  
dynpoi_item dynpoi_item_pkey 492 3488 kB 40 kB Y 2632822 8523629 929359  
source_password source_password_pkey 47720 3200 kB 3256 kB Y 82942 82942 82942  
source source_country_analyser 30345 2320 kB 2760 kB Y 41 1203 0  
source source_pkey 30345 2320 kB 1184 kB Y 66746376 66746579 66746579 ssd
dynpoi_source dynpoi_source_comment_unique 10549 1536 kB 640 kB Y 0 0 0  
dynpoi_source dynpoi_source_pkey 10549 1536 kB 248 kB Y 0 0 0  
source_bak   14764 1088 kB   N        
dynpoi_categ dynpoi_categ_pkey 9 192 kB 16 kB Y 5901 6179 5734  
backend backend_pkey 24 8192 bytes 16 kB Y 2 2 2  
geometry_columns geometry_columns_pk 1 8192 bytes 16 kB Y 0 0 0  
spatial_ref_sys spatial_ref_sys_pkey 0 0 bytes 8192 bytes Y 0 0 0  

(36 rows)

relname create_index
backend_pkey CREATE UNIQUE INDEX backend_pkey ON backend USING btree (ip)
dynpoi_categ_pkey CREATE UNIQUE INDEX dynpoi_categ_pkey ON dynpoi_categ USING btree (categ)
dynpoi_class_pkey CREATE UNIQUE INDEX dynpoi_class_pkey ON dynpoi_class USING btree (source, class)
dynpoi_item_marker CREATE UNIQUE INDEX dynpoi_item_marker ON dynpoi_item USING btree (marker_color, marker_flag)
dynpoi_item_pkey CREATE UNIQUE INDEX dynpoi_item_pkey ON dynpoi_item USING btree (item)
dynpoi_source_comment_unique CREATE UNIQUE INDEX dynpoi_source_comment_unique ON dynpoi_source USING btree (comment)
dynpoi_source_pkey CREATE UNIQUE INDEX dynpoi_source_pkey ON dynpoi_source USING btree (source)
dynpoi_stats_pkey CREATE UNIQUE INDEX dynpoi_stats_pkey ON dynpoi_stats USING btree (source, class, "timestamp")
dynpoi_stats_timestamp CREATE INDEX dynpoi_stats_timestamp ON dynpoi_stats USING btree ("timestamp")
dynpoi_status_id CREATE UNIQUE INDEX dynpoi_status_id ON dynpoi_status USING btree (id)
dynpoi_status_pkey CREATE UNIQUE INDEX dynpoi_status_pkey ON dynpoi_status USING btree (source, class, subclass, elems, lat, lon)
dynpoi_update_last_pkey CREATE UNIQUE INDEX dynpoi_update_last_pkey ON dynpoi_update_last USING btree (source)
dynpoi_update_pkey CREATE UNIQUE INDEX dynpoi_update_pkey ON dynpoi_update USING btree (source, "timestamp")
dynpoi_update_source_timestamp CREATE INDEX dynpoi_update_source_timestamp ON dynpoi_update USING btree (source, "timestamp")
geometry_columns_pk CREATE UNIQUE INDEX geometry_columns_pk ON geometry_columns USING btree (f_table_catalog, f_table_schema, f_table_name, f_geometry_column)
idx_dynpoi_class_class CREATE INDEX idx_dynpoi_class_class ON dynpoi_class USING btree (class)
idx_dynpoi_class_item CREATE INDEX idx_dynpoi_class_item ON dynpoi_class USING btree (item)
idx_dynpoi_class_level CREATE INDEX idx_dynpoi_class_level ON dynpoi_class USING btree (level)
idx_dynpoi_class_source CREATE INDEX idx_dynpoi_class_source ON dynpoi_class USING btree (source)
idx_dynpoi_update_source CREATE INDEX idx_dynpoi_update_source ON dynpoi_update USING btree (source)
idx_dynpoi_update_source_timestamp CREATE INDEX idx_dynpoi_update_source_timestamp ON dynpoi_update USING btree (source, "timestamp")
idx_dynpoi_update_timestamp CREATE INDEX idx_dynpoi_update_timestamp ON dynpoi_update USING btree ("timestamp")
idx_marker_elem_data_type_id CREATE INDEX idx_marker_elem_data_type_id ON marker_elem USING btree (data_type, id)
idx_marker_elem_username CREATE INDEX idx_marker_elem_username ON marker_elem USING btree (username)
idx_marker_item CREATE INDEX idx_marker_item ON marker USING btree (item)
idx_marker_lat_lon CREATE INDEX idx_marker_lat_lon ON marker USING btree (lat, lon)
idx_marker_source_class CREATE INDEX idx_marker_source_class ON marker USING btree (source, class)
idx_marker_source_class_subclass_lat_lon_elems CREATE INDEX idx_marker_source_class_subclass_lat_lon_elems ON marker USING btree (source, class, subclass, lat, lon, elems)
marker_elem_pkey CREATE UNIQUE INDEX marker_elem_pkey ON marker_elem USING btree (marker_id, elem_index)
marker_fix_pkey CREATE UNIQUE INDEX marker_fix_pkey ON marker_fix USING btree (marker_id, diff_index, elem_data_type, elem_id)
marker_pkey CREATE UNIQUE INDEX marker_pkey ON marker USING btree (id)
source_country_analyser CREATE UNIQUE INDEX source_country_analyser ON source USING btree (country, analyser)
source_password_pkey CREATE UNIQUE INDEX source_password_pkey ON source_password USING btree (source_id, password)
source_pkey CREATE UNIQUE INDEX source_pkey ON source USING btree (id)
spatial_ref_sys_pkey CREATE UNIQUE INDEX spatial_ref_sys_pkey ON spatial_ref_sys USING btree (srid)
   

(36 rows)