tablename indexname num_rows table index u scans read fetch tblspc
marker_elem idx_marker_elem_data_type_id 4.60332e+07 8557 MB 6432 MB Y 0 0 0 ssd
marker_elem idx_marker_elem_username 4.60332e+07 8557 MB 5183 MB Y 380165 329803405 30257743 ssd
marker_elem marker_elem_pkey 4.60332e+07 8557 MB 4903 MB Y 776742115 1016232226 1005286924 ssd
marker idx_marker_source_class_subclass_lat_lon_elems 3.5145e+07 8014 MB 6316 MB Y 429771723 112165117234 105383999423 ssd
marker idx_marker_source_class 3.5145e+07 8014 MB 2825 MB Y 22437432 5514291947 1723965843 ssd
marker idx_marker_item 3.5145e+07 8014 MB 2796 MB Y 12082525 9539319373 286809240 ssd
marker idx_marker_lat_lon 3.5145e+07 8014 MB 2461 MB Y 11555334 6472553503 2747818254  
marker marker_pkey 3.5145e+07 8014 MB 2202 MB Y 1406664153 1406674675 1406655249 ssd
dynpoi_stats dynpoi_stats_pkey 1.12899e+08 7685 MB 8805 MB Y 849960 735524859 735182436 ssd
dynpoi_stats dynpoi_stats_timestamp 1.12899e+08 7685 MB 3528 MB Y 16 16 16 ssd
dynpoi_update dynpoi_update_pkey 1.34971e+07 2766 MB 629 MB Y 0 0 0  
dynpoi_update idx_dynpoi_update_source_timestamp 1.34971e+07 2766 MB 629 MB Y 0 0 0  
dynpoi_update dynpoi_update_source_timestamp 1.34971e+07 2766 MB 629 MB Y 0 0 0  
dynpoi_update idx_dynpoi_update_source 1.34971e+07 2766 MB 427 MB Y 116 104747 104741 ssd
dynpoi_update idx_dynpoi_update_timestamp 1.34971e+07 2766 MB 372 MB Y 10512 25227922 25227434 ssd
marker_fix marker_fix_pkey 9.40402e+06 1504 MB 2718 MB Y 828385064 212698527 199277531 ssd
dynpoi_class idx_dynpoi_class_level 436211 1174 MB 86 MB Y 3005 102515492 0 ssd
dynpoi_class idx_dynpoi_class_class 436211 1174 MB 70 MB Y 13306967 17814007 13311396  
dynpoi_class idx_dynpoi_class_item 436211 1174 MB 70 MB Y 31962 34833189 12127  
dynpoi_class idx_dynpoi_class_source 436211 1174 MB 26 MB Y 24101543 32873727 28597115  
dynpoi_class dynpoi_class_pkey 436211 1174 MB 18 MB Y 1582087505 1615945089 1596683914 ssd
dynpoi_status dynpoi_status_pkey 190506 67 MB 48 MB Y 3456277 15065005 2494538  
dynpoi_status dynpoi_status_id 190506 67 MB 40 MB Y 303 301 301  
dynpoi_update_last dynpoi_update_last_pkey 29098 4176 kB 1376 kB Y 261798039 262169552 262169074 ssd
source_password source_password_pkey 42115 3200 kB 3256 kB Y 1238647 1360859 1102832  
source source_country_analyser 28333 2320 kB 2760 kB Y 216069 683844 437141  
source source_pkey 28333 2320 kB 1184 kB Y 822145335 822708998 822708998 ssd
dynpoi_item dynpoi_item_marker 164 2152 kB 48 kB Y 0 0 0  
dynpoi_item dynpoi_item_pkey 164 2152 kB 40 kB Y 65213905 197130466 12488141  
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 1 1 1  
source_bak   14764 1088 kB   N        
dynpoi_categ dynpoi_categ_pkey 8 184 kB 16 kB Y 836906 838729 835758  
backend backend_pkey 24 8192 bytes 16 kB Y 52 52 52  
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)