tablename indexname num_rows table index u scans read fetch tblspc
marker_elem idx_marker_elem_data_type_id 3.70876e+07 7594 MB 6432 MB Y 0 0 0 ssd
marker_elem idx_marker_elem_username 3.70876e+07 7594 MB 5183 MB Y 257413 269048903 26052249 ssd
marker_elem marker_elem_pkey 3.70876e+07 7594 MB 4903 MB Y 616516672 804131975 799129078 ssd
dynpoi_stats dynpoi_stats_pkey 1.12899e+08 7168 MB 8035 MB Y 1115682 901289804 901289804 ssd
dynpoi_stats dynpoi_stats_timestamp 1.12899e+08 7168 MB 3284 MB Y 8 14179859 14179859 ssd
marker idx_marker_source_class_subclass_lat_lon_elems 2.78226e+07 6855 MB 5281 MB Y 221828621 56568947266 51779606234 ssd
marker idx_marker_source_class 2.78226e+07 6855 MB 2825 MB Y 17204527 4357303446 1371237798 ssd
marker idx_marker_item 2.78226e+07 6855 MB 2796 MB Y 7412011 7388068234 171231018 ssd
marker idx_marker_lat_lon 2.78226e+07 6855 MB 2224 MB Y 7277194 3112042572 1524729274  
marker marker_pkey 2.78226e+07 6855 MB 2202 MB Y 1094282610 1094287740 1094277739 ssd
dynpoi_update dynpoi_update_source_timestamp 1.34971e+07 2608 MB 593 MB Y 0 0 0  
dynpoi_update dynpoi_update_pkey 1.34971e+07 2608 MB 593 MB Y 0 0 0  
dynpoi_update idx_dynpoi_update_source_timestamp 1.34971e+07 2608 MB 593 MB Y 0 0 0  
dynpoi_update idx_dynpoi_update_source 1.34971e+07 2608 MB 392 MB Y 110 49614 49614 ssd
dynpoi_update idx_dynpoi_update_timestamp 1.34971e+07 2608 MB 347 MB Y 9756 23450833 23450059 ssd
marker_fix marker_fix_pkey 9.01433e+06 1504 MB 2718 MB Y 637497041 164069613 158182617 ssd
dynpoi_class idx_dynpoi_class_level 396998 1174 MB 86 MB Y 1695 58413768 0 ssd
dynpoi_class idx_dynpoi_class_class 396998 1174 MB 70 MB Y 8960886 10196316 9094309  
dynpoi_class idx_dynpoi_class_item 396998 1174 MB 70 MB Y 27358 31607291 11826  
dynpoi_class idx_dynpoi_class_source 396998 1174 MB 26 MB Y 15696754 21236064 17963170  
dynpoi_class dynpoi_class_pkey 396998 1174 MB 17 MB Y 1150872451 1174172218 1161372193 ssd
dynpoi_status dynpoi_status_pkey 179330 67 MB 48 MB Y 2636525 9344209 1384552  
dynpoi_status dynpoi_status_id 179330 67 MB 37 MB Y 115 114 113  
dynpoi_update_last dynpoi_update_last_pkey 29091 4176 kB 1376 kB Y 168920334 169213766 169213043 ssd
source_password source_password_pkey 42115 3200 kB 3256 kB Y 868088 937812 790368  
source source_country_analyser 28333 2320 kB 2760 kB Y 123015 392248 330017  
source source_pkey 28333 2320 kB 1184 kB Y 634919648 635246604 635246604 ssd
dynpoi_item dynpoi_item_marker 164 2152 kB 48 kB Y 2 44 0  
dynpoi_item dynpoi_item_pkey 164 2152 kB 40 kB Y 50138313 106910834 7593279  
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 8 152 kB 16 kB Y 269104 270758 267792  
backend backend_pkey 24 8192 bytes 16 kB Y 114 114 114  
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)