tablename indexname num_rows table index u scans read fetch tblspc
marker_elem idx_marker_elem_data_type_id 3.77185e+07 7594 MB 6432 MB Y 17880 0 0 ssd
marker_elem idx_marker_elem_username 3.77185e+07 7594 MB 5183 MB Y 295799 203370304 48325971 ssd
marker_elem marker_elem_pkey 3.77185e+07 7594 MB 4903 MB Y 1030571829 1370227100 1369066295 ssd
dynpoi_stats dynpoi_stats_pkey 1.12899e+08 6643 MB 7516 MB Y 1527992 1100628750 1100429851 ssd
dynpoi_stats dynpoi_stats_timestamp 1.12899e+08 6643 MB 3036 MB Y 22 22 22 ssd
marker marker_geom 2.81456e+07 6486 MB 7461 MB Y 891705 16011292978 404200418 ssd
marker idx_marker_source_class_subclass_lat_lon_elems 2.81456e+07 6486 MB 5281 MB Y 66273344 101439514511 93611146657 ssd
marker idx_marker_source_class 2.81456e+07 6486 MB 2825 MB Y 33859628 9043721325 2954223529 ssd
marker idx_marker_item 2.81456e+07 6486 MB 2796 MB Y 2669214 66227009662 17886813 ssd
marker marker_pkey 2.81456e+07 6486 MB 2202 MB Y 1670605184 1670632296 1670601550 ssd
dynpoi_update dynpoi_update_pkey 1.34971e+07 2458 MB 535 MB Y 0 0 0  
dynpoi_update dynpoi_update_source_timestamp 1.34971e+07 2458 MB 535 MB Y 0 0 0  
dynpoi_update idx_dynpoi_update_source_timestamp 1.34971e+07 2458 MB 535 MB Y 0 0 0  
dynpoi_update idx_dynpoi_update_source 1.34971e+07 2458 MB 340 MB Y 1877 986735 986722 ssd
dynpoi_update idx_dynpoi_update_timestamp 1.34971e+07 2458 MB 323 MB Y 121129 20006516 20006371 ssd
marker_fix marker_fix_pkey 9.22184e+06 1504 MB 2718 MB Y 1543558750 293697753 218862653 ssd
dynpoi_class idx_dynpoi_class_level 278979 1174 MB 86 MB Y 11605 417523661 0 ssd
dynpoi_class idx_dynpoi_class_class 278979 1174 MB 70 MB Y 4002465 25727808 4001807  
dynpoi_class idx_dynpoi_class_item 278979 1174 MB 70 MB Y 55023 63559376 23501  
dynpoi_class idx_dynpoi_class_source 278979 1174 MB 26 MB Y 7581059 16380435 11126031  
dynpoi_class dynpoi_class_pkey 278979 1174 MB 17 MB Y 2433033526 2504251188 2440395616 ssd
dynpoi_status dynpoi_status_pkey 181231 67 MB 48 MB Y 5183191 18275760 3214032  
dynpoi_status dynpoi_status_id 181231 67 MB 37 MB Y 660 665 654  
dynpoi_update_last dynpoi_update_last_pkey 29270 4176 kB 1376 kB Y 236265312 236672480 236671417 ssd
source_password source_password_pkey 42115 3200 kB 3256 kB Y 2749002 3197848 2239029  
source source_country_analyser 28333 2320 kB 2760 kB Y 765160 925052 846668  
source source_pkey 28333 2320 kB 1184 kB Y 1108432563 1109034466 1109034466 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 118096437 142597426 2897481  
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 287870 289224 286745  
backend backend_pkey 24 8192 bytes 16 kB Y 984 984 984  
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)