tablename indexname num_rows table index u scans read fetch tblspc
marker_elem idx_marker_elem_data_type_id 3.86061e+07 7594 MB 6432 MB Y 17880 0 0 ssd
marker_elem idx_marker_elem_username 3.86061e+07 7594 MB 5183 MB Y 183980 139012953 35348510 ssd
marker_elem marker_elem_pkey 3.86061e+07 7594 MB 4903 MB Y 650038465 865790606 865093864 ssd
dynpoi_stats dynpoi_stats_pkey 8.8653e+07 6392 MB 7266 MB Y 499634 358962316 358763417 ssd
dynpoi_stats dynpoi_stats_timestamp 8.8653e+07 6392 MB 2917 MB Y 19 19 19 ssd
marker marker_geom 2.94351e+07 6337 MB 6938 MB Y 529260 8647401152 223731486 ssd
marker idx_marker_source_class_subclass_lat_lon_elems 2.94351e+07 6337 MB 4915 MB Y 28275967 59535544168 54790188680 ssd
marker idx_marker_source_class 2.94351e+07 6337 MB 2825 MB Y 19843206 5315874393 1516836225 ssd
marker idx_marker_item 2.94351e+07 6337 MB 2796 MB Y 1711333 32201973360 16038087 ssd
marker marker_pkey 2.94351e+07 6337 MB 2202 MB Y 1059223999 1059233466 1059221149 ssd
dynpoi_update dynpoi_update_pkey 1.34971e+07 2384 MB 471 MB Y 0 0 0  
dynpoi_update dynpoi_update_source_timestamp 1.34971e+07 2384 MB 471 MB Y 0 0 0  
dynpoi_update idx_dynpoi_update_source_timestamp 1.34971e+07 2384 MB 471 MB Y 0 0 0  
dynpoi_update idx_dynpoi_update_source 1.34971e+07 2384 MB 314 MB Y 1805 948334 948321 ssd
dynpoi_update idx_dynpoi_update_timestamp 1.34971e+07 2384 MB 311 MB Y 82233 13908044 13907953 ssd
marker_fix marker_fix_pkey 7.84281e+06 1504 MB 2718 MB Y 958074939 169959034 128242262 ssd
dynpoi_class idx_dynpoi_class_level 301227 1174 MB 86 MB Y 6438 237709386 0 ssd
dynpoi_class idx_dynpoi_class_class 301227 1174 MB 70 MB Y 2570395 23092257 2568793  
dynpoi_class idx_dynpoi_class_item 301227 1174 MB 70 MB Y 37008 42942370 19319  
dynpoi_class idx_dynpoi_class_source 301227 1174 MB 26 MB Y 4743179 10314871 6985657  
dynpoi_class dynpoi_class_pkey 301227 1174 MB 17 MB Y 1618237124 1665537373 1622042424 ssd
dynpoi_status dynpoi_status_pkey 171224 67 MB 48 MB Y 3381897 12212761 2499000  
dynpoi_status dynpoi_status_id 171224 67 MB 36 MB Y 654 661 650  
dynpoi_update_last dynpoi_update_last_pkey 29103 4176 kB 1376 kB Y 150313529 150568920 150567902 ssd
source_password source_password_pkey 42115 3184 kB 3224 kB Y 1669884 1928454 1375239  
source source_country_analyser 28333 2320 kB 2760 kB Y 440782 503585 472108  
source source_pkey 28333 2320 kB 1184 kB Y 702501491 702896469 702896469 ssd
dynpoi_item dynpoi_item_marker 161 2152 kB 40 kB Y 0 0 0  
dynpoi_item dynpoi_item_pkey 161 2152 kB 40 kB Y 72403534 87346237 1825511  
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_stats_last   9155 472 kB   N        
dynpoi_categ dynpoi_categ_pkey 8 152 kB 16 kB Y 172990 174344 171865  
backend backend_pkey 24 8192 bytes 16 kB Y 788 788 788  
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  

(37 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_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_geom CREATE INDEX marker_geom ON marker USING gist (point(lat::double precision, lon::double precision))
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)
   
   

(37 rows)