-
Statements statistics on engine database
Top N statistics about slowest or most used queries.
Query Calls Avg time Total time Rows Temp blocks written select * from getvmsrunningonvds($1) 77871 0.026s 33m49s 172543 0 select * from getvdsbyvdsid($1. $2. $3) 79173 0s 1m1s 79173 0 select * from getvmbyvmguid($1. $2. $3) 1998 0.010s 21.795s 1998 0 select * from getvmnetworkinterfaceviewbyvmid($1. $2. $3) 36006 0s 15.649s 36006 0 SELECT DISTINCT vds.* FROM vds WHERE vds_id = v_vds_id 79173 0s 15.124s 0 0 select * from getallfromvms($1. $2) 228 0.050s 11.440s 119016 32.60 K select * from getinterface_viewbyvds_id($1. $2. $3) 16141 0s 9.659s 112987 0 select * from getallnetworkbyclusterid($1. $2. $3) 15921 0s 9.186s 15921 0 SELECT DISTINCT vms.* FROM vms WHERE run_on_vds = v_vds_id 77871 0s 8.157s 0 0 select * from getvdsgroupbyvdsgroupid($1. $2. $3) 16355 0s 5.558s 16355 0 select * from getqosbyqosid($1) 115047 0s 5.313s 0 0 select * from public.updatevds_interface_statistics(CAST ($1 AS uuid).CAST ($2 AS numeric).CAST ($3 AS numeric).CAST ($4 AS int8).CAST ($5 AS int8).CAST ($6 AS numeric).CAST ($7 AS numeric).CAST ($8 AS int8).CAST ($9 AS int8).CAST ($10 AS int4).CAST ($11 AS float8).CAST ($12 AS uuid)) as result 110005 0s 5.203s 110005 0 SELECT DISTINCT vms.* FROM vms ORDER BY vm_guid 228 0.021s 4.990s 0 16.42 K select * from getallfromvds($1. $2) 235 0.018s 4.457s 47470 0 select * from getstoragedomainidsbystoragepoolidandstatus($1. $2) 78617 0s 4.398s 0 0 select * from getstorage_poolbyid($1. $2. $3) 15860 0s 4.174s 15860 0 select ? 1343451 0s 2.786s 1343450 0 select * from getalluserpermissions($1) 908 0.002s 2.438s 0 0 select * from getallvmjobids() 77870 0s 2.270s 0 0 select * from getallassignednumanodeinfomation() 34508 0s 2.114s 0 0 SELECT * FROM vm_interface_view WHERE vm_guid = v_vm_id AND (NOT v_is_filtered OR EXISTS (SELECT ? FROM user_vm_permissions_view WHERE user_id = v_user_id AND entity_id = v_vm_id)) 36006 0s 2.105s 0 0 select * from updatevdsstatistics($1. $2. $3. $4. $5. $6. $7. $8. $9. $10. $11. $12. $13. $14. $15. $16. $17. $18. $19. $20. $21. $22. $23. $24) as result 16001 0s 1.982s 16001 0 select * from public.updatevmdynamic(CAST ($1 AS text).CAST ($2 AS varchar).CAST ($3 AS varchar).CAST ($4 AS uuid).CAST ($5 AS varchar).CAST ($6 AS uuid).CAST ($7 AS uuid).CAST ($8 AS int4).CAST ($9 AS uuid).CAST ($10 AS varchar).CAST ($11 AS varchar).CAST ($12 AS varchar).CAST ($13 AS timestamptz).CAST ($14 AS timestamptz).CAST ($15 AS int4).CAST ($16 AS bool).CAST ($17 AS int4).CAST ($18 AS bool).CAST ($19 AS int4).CAST ($20 AS int4).CAST ($21 AS uuid).CAST ($22 AS varchar).CAST ($23 AS int4).CAST ($24 AS int4).CAST ($25 AS int4).CAST ($26 AS varchar).CAST ($27 AS varchar).CAST ($28 AS int4).CAST ($29 AS numeric).CAST ($30 AS varchar).CAST ($31 AS bool).CAST ($32 AS varchar).CAST ($33 AS varchar).CAST ($34 AS varchar).CAST ($35 AS varchar).CAST ($36 AS int4).CAST ($37 AS int4).CAST ($38 AS int4).CAST ($39 AS int4).CAST ($40 AS varchar).CAST ($41 AS int4).CAST ($42 AS varchar).CAST ($43 AS int4).CAST ($44 AS int8).CAST ($45 AS int8).CAST ($46 AS int8).CAST ($47 AS int4).CAST ($48 AS varchar).CAST ($49 AS int4).CAST ($50 AS varchar).CAST ($51 AS varchar).CAST ($52 AS varchar).CAST ($53 AS varchar).CAST ($54 AS varchar)) as result 34508 0s 1.885s 34508 0 select * from getnumanodecpubyvdsid($1) 34508 0s 1.845s 0 0 select * from getnumanodecpubyvmid($1) 34508 0s 1.796s 0 0 UPDATE vds_interface_statistics SET rx_drop = v_rx_drop.rx_rate = v_rx_rate.rx_total = v_rx_total.rx_offset = v_rx_offset. tx_drop = v_tx_drop.tx_rate = v_tx_rate.tx_total = v_tx_total.tx_offset = v_tx_offset. vds_id = v_vds_id.iface_status = v_iface_status.sample_time = v_sample_time. _update_date = LOCALTIMESTAMP WHERE id = v_id 110005 0s 1.762s 110005 0 select * from getvdsdynamicbyvdsid($1) 16402 0s 1.751s 16402 0 SELECT * FROM vds_interface_view WHERE vds_id = v_vds_id AND (NOT v_is_filtered OR EXISTS (SELECT ? FROM user_vds_permissions_view WHERE user_id = v_user_id AND entity_id = v_vds_id)) 16141 0s 1.494s 0 0 select * from getstorage_domains_by_storagepoolid($1. $2. $3) 125 0.010s 1.355s 125 0 select * from getvmjobsbyvmid($1) 34508 0s 1.289s 0 0 select * from getnumanodebyvdsid($1) 34508 0s 1.254s 0 0 select * from getnumanodebyvmid($1) 34508 0s 1.214s 0 0 select * from getvm_poolsbyvm_pool_id($1. $2. $3) 499 0.002s 1.190s 499 0 select * from public.updatedisk_image_dynamic_by_disk_id_and_vm_id(CAST ($1 AS uuid).CAST ($2 AS uuid).CAST ($3 AS int4).CAST ($4 AS int4).CAST ($5 AS int8).CAST ($6 AS numeric).CAST ($7 AS numeric).CAST ($8 AS numeric)) as result 34508 0s 1.162s 34508 0 select * from insertvmguestagentinterface($1. $2. $3. $4. $5) as result 34508 0s 1.138s 34508 0 select * from getvdswithoutmigratingvmsbyvdsgroupid($1) 76 0.014s 1.125s 3800 0 select * from public.updatevmstatistics(CAST ($1 AS numeric).CAST ($2 AS numeric).CAST ($3 AS numeric).CAST ($4 AS int4).CAST ($5 AS int4).CAST ($6 AS int4).CAST ($7 AS int4).CAST ($8 AS text).CAST ($9 AS text).CAST ($10 AS text).CAST ($11 AS text).CAST ($12 AS uuid)) as result 34508 0s 1.048s 34508 0 select * from getvdsbystoragepoolidwithstatus($1. $2) 118 0.008s 1.028s 23600 0 select * from public.updatevm_interface_statistics(CAST ($1 AS uuid).CAST ($2 AS numeric).CAST ($3 AS numeric).CAST ($4 AS int8).CAST ($5 AS int8).CAST ($6 AS numeric).CAST ($7 AS numeric).CAST ($8 AS int8).CAST ($9 AS int8).CAST ($10 AS int4).CAST ($11 AS float8).CAST ($12 AS uuid)) as result 34508 0s 0.980s 34508 0 UPDATE vds_statistics SET cpu_idle = v_cpu_idle.cpu_load = v_cpu_load.cpu_sys = v_cpu_sys. cpu_user = v_cpu_user.usage_cpu_percent = v_usage_cpu_percent.usage_mem_percent = v_usage_mem_percent. usage_network_percent = v_usage_network_percent. mem_available = v_mem_available. mem_free = v_mem_free. mem_shared = v_mem_shared. swap_free = v_swap_free.swap_total = v_swap_total.ksm_cpu_percent = v_ksm_cpu_percent. ksm_pages = v_ksm_pages.ksm_state = v_ksm_state. anonymous_hugepages = v_anonymous_hugepages. boot_time = v_boot_time. ha_score = v_ha_score. ha_configured = v_ha_configured. ha_active = v_ha_active. ha_global_maintenance = v_ha_global_maintenance. ha_local_maintenance = v_ha_local_maintenance. _update_date = LOCALTIMESTAMP. cpu_over_commit_time_stamp = v_cpu_over_commit_time_stamp WHERE vds_id = v_vds_id 16001 0s 0.965s 16001 0 COPY (SELECT date_trunc('seconds'. now()). current_database(). n.nspname. c.relname. c.relkind. c.reltuples. c.relpages. pg_relation_size(c.oid) FROM pg_class c. pg_namespace n WHERE n.oid=c.relnamespace AND n.nspname <> 'information_schema' AND n.nspname <> 'pg_catalog' ORDER BY n.nspname. c.relname) TO STDOUT CSV DELIMITER ';'; 20 0.046s 0.938s 16622 0 COPY (SELECT date_trunc(?. now()). current_database(). n.nspname. c.relname. c.relkind. c.reltuples. c.relpages. pg_relation_size(c.oid) FROM pg_class c. pg_namespace n WHERE n.oid=c.relnamespace AND n.nspname <> ? AND n.nspname <> ? ORDER BY n.nspname. c.relname) TO STDOUT CSV DELIMITER ';'; 20 0.046s 0.921s 16622 0 SELECT DISTINCT vms.* FROM vms WHERE vm_guid = v_vm_guid AND (NOT v_is_filtered OR EXISTS (SELECT ? FROM user_vm_permissions_view WHERE user_id = v_user_id AND entity_id = v_vm_guid)) 1998 0s 0.824s 0 0 SELECT * FROM storage_domains WHERE storage_pool_id = v_storage_pool_id AND (NOT v_is_filtered OR EXISTS (SELECT ? FROM user_storage_domain_permissions_view WHERE user_id = v_user_id AND entity_id = id)) 125 0.005s 0.732s 0 0 select * from getstorage_domains_by_id_and_by_storage_pool_id($1. $2) 236 0.003s 0.730s 118 0 INSERT INTO vm_guest_agent_interfaces(vm_id. interface_name. mac_address. ipv4_addresses. ipv6_addresses) VALUES(v_vm_id. v_interface_name. v_mac_address. v_ipv4_addresses. v_ipv6_addresses) 34508 0s 0.719s 34508 0 SELECT array_to_string(array_agg(vds_id). ?) FROM vm_host_pinning_map WHERE vm_id = v_vm_id 295586 0s 0.694s 295586 0 select * from getallfromvdsgroups($1. $2) 754 0s 0.669s 3016 0 select * from getvmdevicebyvmidtypeanddevice($1. $2. $3. $4. $5) 1500 0s 0.667s 500 0 select * from gettemplatewithlatestversioninchain($1) 499 0.001s 0.653s 499 0 select * from deletevmguestagentinterfacesbyvmid($1) as result 34508 0s 0.630s 34508 0 SELECT storage_id FROM storage_pool_iso_map INNER JOIN storage_domain_static on storage_pool_iso_map.storage_id = storage_domain_static.id WHERE storage_pool_id = v_storage_pool_id AND status = v_status AND storage_domain_static.storage_type != ? 78617 0s 0.615s 0 0 SELECT * FROM storage_domains WHERE id = v_id and storage_pool_id = v_storage_pool_id 236 0.002s 0.606s 0 0 SELECT DISTINCT vds.* FROM vds WHERE (NOT v_is_filtered OR EXISTS (SELECT ? FROM user_vds_permissions_view WHERE user_id = v_user_id AND entity_id = vds_id)) 235 0.002s 0.604s 0 0 UPDATE vm_dynamic SET app_list = v_app_list.guest_cur_user_name = v_guest_cur_user_name. console_cur_user_name = v_console_cur_user_name. console_user_id = v_console_user_id. guest_os = v_guest_os.migrating_to_vds = v_migrating_to_vds.RUN_ON_VDS = v_run_on_vds. status = v_status.vm_host = v_vm_host.vm_ip = v_vm_ip.vm_fqdn = v_vm_fqdn. last_start_time = v_last_start_time. last_stop_time = v_last_stop_time. vm_pid = v_vm_pid.acpi_enable = v_acpi_enable. session = v_session. kvm_enable = v_kvm_enable.boot_sequence = v_boot_sequence. utc_diff = v_utc_diff.last_vds_run_on = v_last_vds_run_on.client_ip = v_client_ip. guest_requested_memory = v_guest_requested_memory. exit_status = v_exit_status. pause_status = v_pause_status.exit_message = v_exit_message. hash=v_hash. guest_agent_nics_hash = v_guest_agent_nics_hash. last_watchdog_event = v_last_watchdog_event. last_watchdog_action = v_last_watchdog_action. is_run_once = v_is_run_once. cpu_name = v_cpu_name. emulated_machine = v_emulated_machine. current_cd = v_current_cd. reason = v_reason. exit_reason = v_exit_reason. guest_cpu_count = v_guest_cpu_count. spice_port = v_spice_port. spice_tls_port = v_spice_tls_port. spice_ip = v_spice_ip. vnc_port = v_vnc_port. vnc_ip = v_vnc_ip. guest_agent_status = v_guest_agent_status. guest_mem_buffered = v_guest_mem_buffered. guest_mem_free = v_guest_mem_free. guest_mem_cached = v_guest_mem_cached. guest_timezone_offset = v_guest_timezone_offset. guest_timezone_name = v_guest_timezone_name. guestos_arch = v_guestos_arch. guestos_codename = v_guestos_codename. guestos_distribution = v_guestos_distribution. guestos_kernel_version = v_guestos_kernel_version. guestos_type = v_guestos_type. guestos_version = v_guestos_version WHERE vm_guid = v_vm_guid 34508 0s 0.533s 34508 0 SELECT * FROM qos WHERE id = v_id 115047 0s 0.497s 0 0 SELECT DISTINCT network.id. network.name. network.description. network.free_text_comment. network.type. network.addr. network.subnet. network.gateway. network.vlan_id. network.stp. network.storage_pool_id. network.mtu. network.vm_network. network.label. network.provider_network_provider_id. network.provider_network_external_id. network.qos_id. network_cluster.network_id. network_cluster.cluster_id. network_cluster.status. network_cluster.is_display. network_cluster.required. network_cluster.migration. network_cluster.management. network_cluster.is_gluster FROM network INNER JOIN network_cluster ON network.id = network_cluster.network_id WHERE network_cluster.cluster_id = v_id AND (NOT v_is_filtered OR EXISTS (SELECT ? FROM user_network_permissions_view WHERE user_id = v_user_id AND entity_id = network.id)) ORDER BY network.name 15921 0s 0.469s 0 0 select * from getvmsbyids($1) 76 0.005s 0.424s 0 0 SELECT vm_pools_full_view.* FROM vm_pools_full_view WHERE vm_pool_id = v_vm_pool_id AND (NOT v_is_filtered OR EXISTS (SELECT ? FROM user_vm_pool_permissions_view WHERE user_id = v_user_id AND entity_id = v_vm_pool_id)) 499 0s 0.405s 0 0 SELECT vds_groups_view.* FROM vds_groups_view WHERE vds_group_id = v_vds_group_id AND (NOT v_is_filtered OR EXISTS (SELECT ? FROM user_vds_groups_permissions_view WHERE user_id = v_user_id AND entity_id = v_vds_group_id)) 16355 0s 0.400s 0 0 SELECT numa_node_cpus_view.* FROM numa_node_cpus_view WHERE vds_id = v_vds_id 34508 0s 0.391s 0 0 SELECT numa_node_cpus_view.* FROM numa_node_cpus_view WHERE vm_id = v_vm_id 34508 0s 0.369s 0 0 UPDATE vm_statistics SET cpu_sys = v_cpu_sys.cpu_user = v_cpu_user.elapsed_time = v_elapsed_time. usage_cpu_percent = v_usage_cpu_percent.usage_mem_percent = v_usage_mem_percent. migration_progress_percent = v_migration_progress_percent. usage_network_percent = v_usage_network_percent.disks_usage = v_disks_usage. memory_usage_history = v_memory_usage_history. cpu_usage_history = v_cpu_usage_history. network_usage_history = v_network_usage_history. _update_date = LOCALTIMESTAMP WHERE vm_guid = v_vm_guid 34508 0s 0.340s 34508 0 UPDATE vm_interface_statistics SET rx_drop = v_rx_drop.rx_rate = v_rx_rate.rx_total = v_rx_total.rx_offset = v_rx_offset. tx_drop = v_tx_drop.tx_rate = v_tx_rate.tx_total = v_tx_total.tx_offset = v_tx_offset. vm_id = v_vm_id.iface_status = v_iface_status.sample_time = v_sample_time. _update_date = LOCALTIMESTAMP WHERE id = v_id 34508 0s 0.301s 34508 0 SELECT vds.* FROM vds INNER JOIN vds_groups vdsgroup ON vds.vds_group_id = vdsgroup.vds_group_id WHERE (v_status IS NULL OR vds.status = v_status) AND (vds.storage_pool_id = v_storage_pool_id) AND vdsgroup.virt_service = ? 118 0.002s 0.289s 0 0 SELECT ( SELECT COALESCE(SUM( CASE WHEN (images_storage_domain_view.active = ? AND (images_storage_domain_view.entity_type IS NULL OR -- Floating disk images_storage_domain_view.entity_type <> ?)) -- or a VM THEN images_storage_domain_view.size ELSE images_storage_domain_view.actual_size END).?) FROM images_storage_domain_view WHERE images_storage_domain_view.storage_id = v_storage_domain_id ) 249 0.001s 0.265s 249 0 SELECT vds_dynamic.* FROM vds_dynamic WHERE vds_id = v_vds_id 16402 0s 0.263s 0 0 SELECT ( SELECT COALESCE(SUM(images_storage_domain_view.actual_size).?) FROM images_storage_domain_view WHERE images_storage_domain_view.storage_id = v_storage_domain_id ) 249 0.001s 0.258s 249 0 select * from getsnapshotbyvmidandtype($1. $2. $3. $4) 500 0s 0.253s 0 0 select * from getusersbyvmguid($1) 1996 0s 0.250s 0 0 select * from getallfromhostdevices() 500 0s 0.207s 95500 0 SELECT * from vm_templates_view where base_template_id = (select vmt_guid from vm_static where vm_guid = v_template_id) order by template_version_number desc limit ? 499 0s 0.195s 0 0 DELETE FROM vm_guest_agent_interfaces WHERE vm_id = v_vm_id 34508 0s 0.185s 34508 0 SELECT numa_node.* FROM numa_node WHERE vds_id = v_vds_id 34508 0s 0.179s 0 0 select * from public.updatevds_interface(CAST ($1 AS varchar).CAST ($2 AS varchar).CAST ($3 AS int4).CAST ($4 AS varchar).CAST ($5 AS uuid).CAST ($6 AS bool).CAST ($7 AS varchar).CAST ($8 AS varchar).CAST ($9 AS varchar).CAST ($10 AS varchar).CAST ($11 AS int4).CAST ($12 AS varchar).CAST ($13 AS int4).CAST ($14 AS int4).CAST ($15 AS uuid).CAST ($16 AS varchar).CAST ($17 AS int4).CAST ($18 AS int4).CAST ($19 AS bool).CAST ($20 AS text)) as result 1442 0s 0.171s 1442 0 SELECT numa_node.* FROM numa_node WHERE vm_id = v_vm_id 34508 0s 0.160s 0 0 select * from checkifsnapshotexistsbyvmidandtype($1. $2) 1498 0s 0.154s 1498 0 select * from getvmsbyvmpoolid($1) 6 0.025s 0.153s 1530 0 "SELECT ? FROM ONLY ""public"".""vm_static"" x WHERE ""vm_guid"" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x" 34508 0s 0.147s 34508 0 SELECT vm_jobs.* FROM vm_jobs WHERE vm_jobs.vm_id = v_vm_id 34508 0s 0.144s 0 0 COPY (SELECT date_trunc('seconds'. now()). current_database(). relname. 'CREATE INDEX idx_' || relname || '_' || array_to_string(column_name_list. '_') || ' ON ' || conrelid || ' (' || array_to_string(column_name_list. '.') || ')' AS ddl FROM (SELECT DISTINCT conrelid. array_agg(attname) AS column_name_list. array_agg(attnum) AS column_list FROM pg_attribute JOIN (SELECT conrelid::regclass. conname. unnest(conkey) AS column_index FROM (SELECT DISTINCT conrelid. conname. conkey FROM pg_constraint JOIN pg_class ON pg_class.oid = pg_constraint.conrelid JOIN pg_namespace ON pg_namespace.oid = pg_class.relnamespace WHERE nspname !~ '^pg_' AND nspname <> 'information_schema' AND pg_constraint.contype = 'f' ) fkey ) fkey ON fkey.conrelid = pg_attribute.attrelid AND fkey.column_index = pg_attribute.attnum GROUP BY conrelid. conname ) candidate_index JOIN pg_class ON pg_class.oid = candidate_index.conrelid LEFT JOIN pg_index ON pg_index.indrelid = conrelid AND indkey::text = array_to_string(column_list. ' ') WHERE pg_index.indrelid IS NULL ) TO STDOUT CSV DELIMITER ';'; 20 0.006s 0.134s 1980 0 select * from public.clear_network_from_nics(CAST ($1 AS uuid)) as result 1442 0s 0.128s 1442 0 COPY (SELECT date_trunc('seconds'. now()). current_database(). schemaname. relname. indexrelname. pg_get_indexdef(pg_stat_user_indexes.indexrelid) FROM pg_stat_user_indexes INNER JOIN pg_index ON pg_index.indexrelid = pg_stat_user_indexes.indexrelid WHERE NOT indexrelname ILIKE 'fki%' AND NOT indexrelname ILIKE 'pk%' AND indisunique = FALSE AND idx_scan = 0 ORDER BY schemaname. relname. indexrelname) TO STDOUT CSV DELIMITER ';'; 20 0.006s 0.124s 1280 0 SELECT * FROM storage_pool WHERE id = v_id AND (NOT v_is_filtered OR EXISTS (SELECT ? FROM user_storage_pool_permissions_view WHERE user_id = v_user_id AND entity_id = v_id)) 15860 0s 0.119s 0 0 select * from getnetworkattachmentsbyhostid($1) 206 0s 0.107s 206 0 select * from getallfromstorage_pool($1. $2) 229 0s 0.100s 229 0 select * from getstorage_domain_by_type_storagepoolid_and_status($1. $2. $3) 6 0.015s 0.096s 6 0 select * from get_entity_snapshot_by_command_id($1) 701 0s 0.093s 0 0 COPY (SELECT date_trunc(?. now()). current_database(). relname. ? || relname || ? || array_to_string(column_name_list. ?) || ? || conrelid || ? || array_to_string(column_name_list. ?) || ? AS ddl FROM (SELECT DISTINCT conrelid. array_agg(attname) AS column_name_list. array_agg(attnum) AS column_list FROM pg_attribute JOIN (SELECT conrelid::regclass. conname. unnest(conkey) AS column_index FROM (SELECT DISTINCT conrelid. conname. conkey FROM pg_constraint JOIN pg_class ON pg_class.oid = pg_constraint.conrelid JOIN pg_namespace ON pg_namespace.oid = pg_class.relnamespace WHERE nspname !~ ? AND nspname <> ? AND pg_constraint.contype = ? ) fkey ) fkey ON fkey.conrelid = pg_attribute.attrelid AND fkey.column_index = pg_attribute.attnum GROUP BY conrelid. conname ) candidate_index JOIN pg_class ON pg_class.oid = candidate_index.conrelid LEFT JOIN pg_index ON pg_index.indrelid = conrelid AND indkey::text = array_to_string(column_list. ?) WHERE pg_index.indrelid IS NULL ) TO STDOUT CSV DELIMITER ';'; 20 0.004s 0.090s 1980 0 COPY (SELECT date_trunc(?. now()). current_database(). schemaname. relname. indexrelname. pg_get_indexdef(pg_stat_user_indexes.indexrelid) FROM pg_stat_user_indexes INNER JOIN pg_index ON pg_index.indexrelid = pg_stat_user_indexes.indexrelid WHERE NOT indexrelname ILIKE ? AND NOT indexrelname ILIKE ? AND indisunique = ? AND idx_scan = ? ORDER BY schemaname. relname. indexrelname) TO STDOUT CSV DELIMITER ';'; 20 0.004s 0.090s 1280 0 SELECT * FROM storage_domains WHERE storage_pool_id = v_storage_pool_id AND storage_domain_type = v_storage_domain_type AND (v_status IS NULL OR status = v_status) 6 0.014s 0.088s 0 0 SELECT vm_jobs.vm_job_id FROM vm_jobs 77870 0s 0.086s 0 0 SELECT vms.* FROM vms WHERE vm_pool_id = v_vm_pool_id 6 0.014s 0.085s 0 0 UPDATE disk_image_dynamic SET read_rate = v_read_rate.write_rate = v_write_rate.actual_size = v_actual_size.read_latency_seconds = v_read_latency_seconds.write_latency_seconds = v_write_latency_seconds.flush_latency_seconds = v_flush_latency_seconds. _update_date = LOCALTIMESTAMP WHERE image_id in (SELECT distinct image_guid FROM images WHERE image_group_id = v_image_group_id and active = ?) AND EXISTS (SELECT ? FROM vm_device vmd WHERE vmd.vm_id = v_vm_id AND vmd.device_id = v_image_group_id AND vmd.snapshot_id is NULL) 34508 0s 0.083s 0 0 select * from getsnapshotidsbyvmidandtype($1. $2) 499 0s 0.079s 0 0 select * from getvmsdynamicrunningonvds($1) 206 0s 0.079s 500 0 COPY (SELECT date_trunc('seconds'. now()). current_database(). * FROM pg_stat_user_functions WHERE schemaname <> 'information_schema' ORDER BY schemaname. funcname) TO STDOUT CSV DELIMITER ';'; 20 0.003s 0.078s 0 0 select * from getsupportedclusterfeaturesbyclusterid($1) 200 0s 0.077s 0 0 COPY (SELECT date_trunc('seconds'. now()). current_database(). * FROM pg_statio_user_tables WHERE schemaname <> 'information_schema' ORDER BY schemaname. relname) TO STDOUT CSV DELIMITER ';'; 20 0.003s 0.074s 3348 0 select * from getupandprioritizedvds($1) 5 0.014s 0.073s 1000 0 SELECT DISTINCT vds.* FROM vds WHERE vds_group_id = v_vds_group_id and pending_vcpus_count = ? and vds.status = ? and vds_id not in(select distinct RUN_ON_VDS from vm_dynamic where status in(?.?.?.?)) 76 0s 0.072s 0 0 COPY (SELECT date_trunc('seconds'. now()). category. name. setting. unit. context. source. boot_val. reset_val FROM pg_settings ORDER BY category.name) TO STDOUT CSV DELIMITER ';'; 20 0.003s 0.069s 4700 0 COPY (SELECT date_trunc(?. now()). current_database(). * FROM pg_stat_user_functions WHERE schemaname <> ? ORDER BY schemaname. funcname) TO STDOUT CSV DELIMITER ';'; 20 0.003s 0.069s 0 0 COPY (SELECT date_trunc(?. now()). category. name. setting. unit. context. source. boot_val. reset_val FROM pg_settings ORDER BY category.name) TO STDOUT CSV DELIMITER ';'; 20 0.003s 0.064s 4700 0 COPY (SELECT date_trunc('seconds'. now()). current_database(). * FROM pg_statio_user_indexes WHERE schemaname <> 'information_schema' ORDER BY schemaname. relname) TO STDOUT CSV DELIMITER ';'; 20 0.003s 0.063s 5760 0 COPY (SELECT date_trunc('seconds'. now()). current_database(). relid. schemaname. relname. seq_scan. seq_tup_read. idx_scan. idx_tup_fetch. n_tup_ins. n_tup_upd. n_tup_del. n_tup_hot_upd. n_live_tup. n_dead_tup. date_trunc('seconds'. last_vacuum) AS last_vacuum. date_trunc('seconds'. last_autovacuum) AS last_autovacuum. date_trunc('seconds'.last_analyze) AS last_analyze. date_trunc('seconds'.last_autoanalyze) AS last_autoanalyze. vacuum_count. autovacuum_count. analyze_count. autoanalyze_count FROM pg_stat_user_tables WHERE schemaname <> 'information_schema' ORDER BY schemaname. relname) TO STDOUT CSV DELIMITER ';'; 20 0.003s 0.062s 3348 0 select * from getmanagementnetworkbycluster($1) 206 0s 0.056s 206 0 select * from delete_entity_snapshot_by_command_id($1) as result 502 0s 0.055s 502 0 COPY (SELECT date_trunc('seconds'. now()). current_database(). * FROM pg_stat_user_indexes WHERE schemaname <> 'information_schema' ORDER BY schemaname. relname) TO STDOUT CSV DELIMITER ';'; 20 0.002s 0.055s 5760 0 COPY (SELECT date_trunc('seconds'. now()). * FROM pg_stat_xact_user_tables WHERE schemaname <> 'information_schema' ORDER BY 3. 4) TO STDOUT CSV DELIMITER ';'; 20 0.002s 0.055s 3348 0 select * from getvdsstaticbyvdsid($1) 231 0s 0.054s 231 0 select * from existsvmdevicebyvmidandtype($1. $2) 500 0s 0.050s 500 0 SELECT numa_node_assignment_view.* FROM numa_node_assignment_view 34508 0s 0.049s 0 0 COPY (SELECT date_trunc(?. now()). current_database(). * FROM pg_statio_user_tables WHERE schemaname <> ? ORDER BY schemaname. relname) TO STDOUT CSV DELIMITER ';'; 20 0.002s 0.049s 3348 0 UPDATE vds_interface SET addr = v_addr.bond_name = v_bond_name.bond_type = v_bond_type.gateway = v_gateway. is_bond = v_is_bond.bond_opts = v_bond_opts.mac_addr = v_mac_addr. name = v_name.network_name = v_network_name.speed = v_speed. subnet = v_subnet.boot_protocol = v_boot_protocol. type = v_type.VDS_ID = v_vds_id.base_interface = v_base_interface.vlan_id = v_vlan_id._update_date = LOCALTIMESTAMP. mtu = v_mtu. bridged = v_bridged. labels = v_labels WHERE id = v_id 1442 0s 0.048s 1442 0 COPY (SELECT date_trunc('seconds'. now()). current_database(). pg_get_indexdef(indexrelid) AS contained. pg_get_indexdef(index_backward) AS container FROM ( SELECT indexrelid. indrelid. array_to_string(indkey.'+') AS colindex. indisunique AS is_unique. lag(array_to_string(indkey.'+')) OVER search_window AS colindexbackward. lag(indexrelid) OVER search_window AS index_backward. lag(indisunique) OVER search_window AS is_unique_backward FROM pg_index WINDOW search_window AS (PARTITION BY indrelid ORDER BY array_to_string(indkey.'+') DESC) ) AS tmp WHERE (colindexbackward LIKE (colindex || '+%') OR colindexbackward = colindex) AND (is_unique_backward <> is_unique)) TO STDOUT CSV DELIMITER ';'; 20 0.002s 0.047s 320 0 COPY (SELECT date_trunc(?. now()). current_database(). * FROM pg_statio_user_indexes WHERE schemaname <> ? ORDER BY schemaname. relname) TO STDOUT CSV DELIMITER ';'; 20 0.002s 0.044s 5760 0 select * from getnetworkattachmentbynicidandnetworkid($1. $2) 206 0s 0.043s 206 0 COPY (SELECT date_trunc(?. now()). current_database(). * FROM pg_stat_user_indexes WHERE schemaname <> ? ORDER BY schemaname. relname) TO STDOUT CSV DELIMITER ';'; 20 0.002s 0.043s 5760 0 COPY (SELECT date_trunc(?. now()). current_database(). relid. schemaname. relname. seq_scan. seq_tup_read. idx_scan. idx_tup_fetch. n_tup_ins. n_tup_upd. n_tup_del. n_tup_hot_upd. n_live_tup. n_dead_tup. date_trunc(?. last_vacuum) AS last_vacuum. date_trunc(?. last_autovacuum) AS last_autovacuum. date_trunc(?.last_analyze) AS last_analyze. date_trunc(?.last_autoanalyze) AS last_autoanalyze. vacuum_count. autovacuum_count. analyze_count. autoanalyze_count FROM pg_stat_user_tables WHERE schemaname <> ? ORDER BY schemaname. relname) TO STDOUT CSV DELIMITER ';'; 20 0.002s 0.042s 3348 0 COPY (SELECT date_trunc(?. now()). current_database(). pg_get_indexdef(indexrelid) AS contained. pg_get_indexdef(index_backward) AS container FROM ( SELECT indexrelid. indrelid. array_to_string(indkey.?) AS colindex. indisunique AS is_unique. lag(array_to_string(indkey.?)) OVER search_window AS colindexbackward. lag(indexrelid) OVER search_window AS index_backward. lag(indisunique) OVER search_window AS is_unique_backward FROM pg_index WINDOW search_window AS (PARTITION BY indrelid ORDER BY array_to_string(indkey.'+') DESC) ) AS tmp WHERE (colindexbackward LIKE (colindex || ?) OR colindexbackward = colindex) AND (is_unique_backward <> is_unique)) TO STDOUT CSV DELIMITER ';'; 20 0.002s 0.041s 320 0 COPY (SELECT date_trunc(?. now()). * FROM pg_stat_xact_user_tables WHERE schemaname <> ? ORDER BY 3. 4) TO STDOUT CSV DELIMITER ';'; 20 0.001s 0.039s 3348 0 select * from getallaffinitygroupsbyclusterid($1) 76 0s 0.038s 0 0 UPDATE vds_interface SET network_name = ? WHERE id = v_id 1442 0s 0.036s 1442 0 SELECT * FROM vm_device_view WHERE vm_id = v_vm_id and type = v_type and device = v_device AND (NOT v_is_filtered OR EXISTS (SELECT ? FROM user_vm_permissions_view WHERE user_id = v_user_id AND entity_id = v_vm_id)) ORDER BY NULLIF(alias.?) NULLS LAST 1500 0s 0.036s 0 0 SELECT vds.* FROM vds vds. vds_groups vdsgroup WHERE (vds.status = ?) AND (vds.storage_pool_id = v_storage_pool_id) AND (vds_spm_priority IS NULL OR vds_spm_priority > ?) AND vds.vds_group_id = vdsgroup.vds_group_id AND vdsgroup.virt_service = ? ORDER BY vds_spm_priority DESC. RANDOM() 5 0.006s 0.033s 0 0 select * from getvmsmigratingtovds($1) 1 0.032s 0.032s 0 0 select * from getsupportedhostfeaturesbyhostid($1) 206 0s 0.031s 0 0 select * from insertauditlog($1. $2. $3. $4. $5. $6. $7. $8. $9. $10. $11. $12. $13. $14. $15. $16. $17. $18. $19. $20. $21. $22. $23. $24. $25. $26. $27. $28. $29. $30) as result 23 0.001s 0.030s 23 0 COPY (SELECT date_trunc('seconds'. now()). current_database(). * FROM pg_statio_user_sequences WHERE schemaname <> 'information_schema' ORDER BY schemaname. relname) TO STDOUT CSV DELIMITER ';'; 20 0.001s 0.028s 340 0 SELECT users.* FROM users inner join permissions on users.user_id = permissions.ad_element_id WHERE permissions.object_type_id = ? and permissions.object_id = v_vm_guid 1996 0s 0.025s 0 0 SELECT vds_groups_view.* FROM vds_groups_view WHERE (NOT v_is_filtered OR EXISTS (SELECT ? FROM user_vds_groups_permissions_view WHERE user_id = v_user_id and entity_id = vds_group_id)) 754 0s 0.024s 0 0 select * from getstorageconnectionsbystoragetypeandstatus($1. $2. $3) 6 0.003s 0.023s 0 0 SELECT * FROM network_attachments WHERE EXISTS (SELECT ? FROM vds_interface WHERE network_attachments.nic_id = vds_interface.id AND vds_interface.vds_id = v_host_id) 206 0s 0.021s 0 0 select * from getallfromvm_pools() 3 0.006s 0.019s 6 0 COPY (SELECT date_trunc('seconds'. now()). * FROM pg_stat_xact_user_functions WHERE schemaname <> 'information_schema' ORDER BY 3. 4) TO STDOUT CSV DELIMITER ';'; 20 0s 0.019s 0 0 select * from clear_osinfo() as result 1 0.018s 0.019s 1 0 TRUNCATE dwh_osinfo 1 0.018s 0.019s 0 0 BEGIN 33564 0s 0.019s 0 0 select * from getvdsgroupswithoutmigratingvms() 19 0s 0.018s 76 0 SELECT * FROM host_device 500 0s 0.018s 0 0 SELECT ? AS PROCEDURE_CAT. n.nspname AS PROCEDURE_SCHEM. p.proname AS PROCEDURE_NAME. ?. ?. ?. d.description AS REMARKS. ? AS PROCEDURE_TYPE . p.proname || ? || p.oid AS SPECIFIC_NAME FROM pg_catalog.pg_namespace n. pg_catalog.pg_proc p LEFT JOIN pg_catalog.pg_description d ON (p.oid=d.objoid) LEFT JOIN pg_catalog.pg_class c ON (d.classoid=c.oid AND c.relname=?) LEFT JOIN pg_catalog.pg_namespace pn ON (c.relnamespace=pn.oid AND pn.nspname=?) WHERE p.pronamespace=n.oid AND n.nspname LIKE ? AND p.proname LIKE ? ORDER BY PROCEDURE_SCHEM. PROCEDURE_NAME. p.oid::text 187 0s 0.017s 187 0 COPY (SELECT date_trunc(?. now()). current_database(). * FROM pg_statio_user_sequences WHERE schemaname <> ? ORDER BY schemaname. relname) TO STDOUT CSV DELIMITER ';'; 20 0s 0.016s 340 0 SELECT n.nspname.p.proname.p.prorettype.p.proargtypes. t.typtype.t.typrelid . p.proargnames. p.proargmodes. p.proallargtypes . p.oid FROM pg_catalog.pg_proc p. pg_catalog.pg_namespace n. pg_catalog.pg_type t WHERE p.pronamespace=n.oid AND p.prorettype=t.oid AND n.nspname LIKE ? AND p.proname LIKE ? ORDER BY n.nspname. p.proname. p.oid::text 187 0s 0.015s 187 0 COMMIT 33564 0s 0.014s 0 0 select * from updatevdsdynamic($1. $2. $3. $4. $5. $6. $7. $8. $9. $10. $11. $12. $13. $14. $15. $16. $17. $18. $19. $20. $21. $22. $23. $24. $25. $26. $27. $28. $29. $30. $31. $32. $33. $34. $35. $36. $37. $38. $39. $40. $41. $42. $43. $44. $45. $46. $47. $48. $49. $50. $51. $52. $53. $54. $55. $56. $57. $58. $59. $60. $61) as result 24 0s 0.013s 24 0 COPY (SELECT date_trunc('seconds'. now()). b.datname. c.rolname. a.setconfig FROM pg_db_role_setting a LEFT JOIN pg_database b ON (a.setdatabase=b.oid) LEFT JOIN pg_roles c ON (a.setrole=c.oid) ORDER BY 2.3) TO STDOUT CSV DELIMITER ';'; 20 0s 0.013s 60 0 select * from getfailingvdss() 4 0.003s 0.012s 0 0 COPY (SELECT date_trunc(?. now()). * FROM pg_stat_xact_user_functions WHERE schemaname <> ? ORDER BY 3. 4) TO STDOUT CSV DELIMITER ';'; 20 0s 0.012s 0 0 COPY (SELECT date_trunc('seconds'. now()). current_database(). 'lock_granted'::text as label. granted. count(granted) as count FROM pg_locks GROUP BY granted) TO STDOUT CSV DELIMITER ';'; 20 0s 0.011s 20 0 SELECT EXISTS( SELECT * FROM snapshots WHERE vm_id = v_vm_id AND snapshot_type = v_snapshot_type) 1498 0s 0.011s 0 0 SELECT vds_static.* FROM vds_static WHERE vds_id = v_vds_id 231 0s 0.011s 0 0 select * from deletecompletedjobsolderthandate($1. $2) as result 1 0.009s 0.010s 1 0 DELETE FROM job WHERE (is_auto_cleared AND ((end_time < v_succeeded_end_time AND status = ?) OR (end_time < v_failed_end_time AND status IN (?. ?. ?)))) 1 0.009s 0.009s 290 0 select * from getaction_version_mapbyaction_type($1) 31 0s 0.009s 0 0 SELECT business_entity_snapshot.* FROM business_entity_snapshot WHERE command_id = v_command_id order by insertion_order desc 701 0s 0.008s 0 0 COPY (SELECT date_trunc('seconds'. now()). current_database(). 'lock_mode'::text as label. mode. count(mode) as count FROM pg_locks GROUP BY mode) TO STDOUT CSV DELIMITER ';'; 20 0s 0.008s 48 0 select * from updatedwhhistorytimekeeping($1. $2. $3) as result 40 0s 0.008s 40 0 select * from getvmiconbyvmicondataurl($1) 80 0s 0.008s 80 0 SELECT * FROM snapshots WHERE vm_id = v_vm_id AND snapshot_type = v_snapshot_type AND (NOT v_is_filtered OR EXISTS (SELECT ? FROM user_vm_permissions_view WHERE user_id = v_user_id AND entity_id = v_vm_id)) ORDER BY creation_date ASC LIMIT ? 500 0s 0.007s 0 0 SELECT snapshot_id FROM snapshots WHERE vm_id = v_vm_id AND snapshot_type = v_snapshot_type ORDER BY creation_date ASC 499 0s 0.007s 0 0 SELECT vm.* FROM vms vm WHERE vm.vm_guid IN (SELECT * from fnSplitterUuid(v_vms_ids)) 76 0s 0.007s 0 0 select * from getfailedautostartvms() 1 0.006s 0.007s 0 0 SELECT EXISTS( SELECT ? FROM vm_device WHERE vm_id = v_vm_id AND type = v_type) 500 0s 0.006s 500 0 SELECT a.attname.a.atttypid FROM pg_catalog.pg_attribute a WHERE a.attrelid = ? AND a.attnum > ? ORDER BY a.attnum 133 0s 0.006s 4096 0 select * from getvmstaticwithfailbackbyvdsid($1) 6 0s 0.006s 0 0 INSERT INTO audit_log(LOG_TIME. log_type. log_type_name. severity.message. user_id. USER_NAME. vds_id. VDS_NAME. vm_id. VM_NAME.vm_template_id.VM_TEMPLATE_NAME.storage_pool_id.STORAGE_POOL_NAME.storage_domain_id.STORAGE_DOMAIN_NAME.vds_group_id.vds_group_name. correlation_id. job_id. quota_id. quota_name. gluster_volume_id. gluster_volume_name. call_stack. brick_id. brick_path) VALUES(v_log_time. v_log_type. v_log_type_name. v_severity. v_message. v_user_id. v_user_name. v_vds_id. v_vds_name. v_vm_id. v_vm_name.v_vm_template_id.v_vm_template_name.v_storage_pool_id.v_storage_pool_name.v_storage_domain_id.v_storage_domain_name.v_vds_group_id.v_vds_group_name. v_correlation_id. v_job_id. v_quota_id. v_quota_name. v_gluster_volume_id. v_gluster_volume_name. v_call_stack. v_brick_id. v_brick_path) 16 0s 0.005s 16 0 select * from insertvmicondefault($1. $2. $3. $4) as result 40 0s 0.005s 40 0 COPY (SELECT date_trunc('seconds'. now()). current_database(). 'lock_type'::text as label. locktype. count(locktype) as count FROM pg_locks GROUP BY locktype) TO STDOUT CSV DELIMITER ';'; 20 0s 0.005s 40 0 INSERT INTO vm_icon_defaults ( id. os_id. small_icon_id. large_icon_id) VALUES ( v_id. v_os_id. v_small_icon_id. v_large_icon_id) 40 0s 0.004s 40 0 select * from getfailingstorage_domains() 4 0s 0.004s 0 0 insert INTO tt_VM_POOL_RUNNING(vm_pool_id. vm_running_count) select vm_pools_view.vm_pool_id. count(vm_pools_view.vm_pool_id) from vm_pools_view left join vm_pool_map on vm_pools_view.vm_pool_id = vm_pool_map.vm_pool_id left join vm_dynamic on vm_pool_map.vm_guid = vm_dynamic.vm_guid where vm_dynamic.status > ? group by vm_pools_view.vm_pool_id 3 0.001s 0.004s 3 0 SELECT vds_groups_view.* FROM vds_groups_view WHERE vds_group_id not in ( SELECT s.vds_group_id FROM vm_static s JOIN vm_dynamic d ON s.vm_guid = d.vm_guid WHERE d.status IN(?.?)) 19 0s 0.003s 0 0 select * from getstorage_pool_iso_mapsbybystorage_pool_id($1. $2) 9 0s 0.003s 9 0 CREATE TEMPORARY TABLE tt_VM_POOL_RESULT ( vm_pool_id UUID. assigned_vm_count INTEGER. vm_running_count INTEGER. vm_pool_description VARCHAR(4000). vm_pool_comment text. vm_pool_name VARCHAR(255). vm_pool_type INTEGER. parameters VARCHAR(200). prestarted_vms INTEGER. vds_group_id UUID. vds_group_name VARCHAR(40). max_assigned_vms_per_user SMALLINT. spice_proxy VARCHAR(255). is_being_destroyed BOOLEAN ) WITH OIDS 3 0.001s 0.003s 0 0 select * from getallmacsbymacpoolid($1) 2 0.001s 0.003s 528 0 COPY (SELECT date_trunc(?. now()). current_database(). ?::text as label. granted. count(granted) as count FROM pg_locks GROUP BY granted) TO STDOUT CSV DELIMITER ';'; 20 0s 0.003s 20 0 CREATE TEMPORARY TABLE tt_VM_POOL_GROUP ( vm_pool_id UUID. assigned_vm_count INTEGER ) WITH OIDS 3 0s 0.003s 0 0 COPY (SELECT date_trunc(?. now()). current_database(). ?::text as label. mode. count(mode) as count FROM pg_locks GROUP BY mode) TO STDOUT CSV DELIMITER ';'; 20 0s 0.003s 48 0 SELECT network.* FROM network WHERE id = (SELECT network_id FROM network_cluster WHERE network_cluster.cluster_id = v_cluster_id AND network_cluster.management) 206 0s 0.003s 0 0 UPDATE vds_dynamic SET cpu_cores = v_cpu_cores.cpu_threads = v_cpu_threads. cpu_model = v_cpu_model.cpu_speed_mh = v_cpu_speed_mh. if_total_speed = v_if_total_speed.kvm_enabled = v_kvm_enabled. mem_commited = v_mem_commited.physical_mem_mb = v_physical_mem_mb. status = v_status.vm_active = v_vm_active.vm_count = v_vm_count. vm_migrating = v_vm_migrating. incoming_migrations = v_incoming_migrations. outgoing_migrations = v_outgoing_migrations. reserved_mem = v_reserved_mem. guest_overhead = v_guest_overhead.rpm_version = v_rpm_version. software_version = v_software_version. version_name = v_version_name.build_name = v_build_name.previous_status = v_previous_status. cpu_flags = v_cpu_flags. vms_cores_count = v_vms_cores_count.pending_vcpus_count = v_pending_vcpus_count. pending_vmem_size = v_pending_vmem_size. cpu_sockets = v_cpu_sockets.net_config_dirty = v_net_config_dirty. supported_cluster_levels = v_supported_cluster_levels. supported_engines = v_supported_engines.host_os = v_host_os. kvm_version = v_kvm_version.libvirt_version = v_libvirt_version.spice_version = v_spice_version. gluster_version = v_gluster_version. librbd1_version = v_librbd1_version. glusterfs_cli_version = v_glusterfs_cli_version. kernel_version = v_kernel_version.iscsi_initiator_name = v_iscsi_initiator_name. transparent_hugepages_state = v_transparent_hugepages_state. hooks = v_hooks. _update_date = LOCALTIMESTAMP.non_operational_reason = v_non_operational_reason. hw_manufacturer = v_hw_manufacturer. hw_product_name = v_hw_product_name. hw_version = v_hw_version. hw_serial_number = v_hw_serial_number. hw_uuid = v_hw_uuid. hw_family = v_hw_family. hbas = v_hbas. supported_emulated_machines = v_supported_emulated_machines. kdump_status = v_kdump_status. selinux_enforce_mode = v_selinux_enforce_mode. auto_numa_balancing = v_auto_numa_balancing. is_numa_supported = v_is_numa_supported. supported_rng_sources = v_supported_rng_sources. is_live_snapshot_supported = v_is_live_snapshot_supported. is_live_merge_supported = v_is_live_merge_supported. online_cpus = v_online_cpus. maintenance_reason = v_maintenance_reason. is_update_available = v_is_update_available. is_hostdev_enabled = v_is_hostdev_enabled WHERE vds_id = v_vds_id 24 0s 0.003s 24 0 select * from removefinishedkdumpstatusforvds($1) as result 6 0s 0.003s 6 0 COPY (SELECT date_trunc(?. now()). current_database(). ?::text as label. locktype. count(locktype) as count FROM pg_locks GROUP BY locktype) TO STDOUT CSV DELIMITER ';'; 20 0s 0.003s 40 0 SELECT vm_dynamic.* FROM vm_dynamic WHERE RUN_ON_VDS = v_vds_id 206 0s 0.003s 0 0 delete from business_entity_snapshot where command_id = v_command_id 502 0s 0.002s 0 0 SELECT * FROM vm_icons WHERE data_url = v_data_url 80 0s 0.002s 0 0 select * from updatevdsdynamicpowermanagementpolicyflag($1. $2) as result 6 0s 0.002s 6 0 SELECT * FROM supported_cluster_features_view WHERE cluster_id = v_cluster_id 200 0s 0.002s 0 0 SELECT * FROM user_vm_permissions_view 227 0s 0.002s 0 0 select * from updatecpuflags($1. $2) as result 6 0s 0.002s 6 0 SELECT na.* FROM network_attachments na WHERE na.network_id = v_network_id and na.nic_id = v_nic_id 206 0s 0.002s 0 0 select * from getvmtemplateswithouticon() 1 0.001s 0.002s 0 0 "DELETE FROM ONLY ""public"".""step"" WHERE $1 OPERATOR(pg_catalog.=) ""job_id""" 290 0s 0.002s 529 0 SELECT n.nspname.p.proname.p.prorettype.p.proargtypes. t.typtype.t.typrelid . p.proargnames. p.proargmodes. p.proallargtypes . p.oid FROM pg_catalog.pg_proc p. pg_catalog.pg_namespace n. pg_catalog.pg_type t WHERE p.pronamespace=n.oid AND p.prorettype=t.oid AND p.proname LIKE ? ORDER BY n.nspname. p.proname. p.oid::text 14 0s 0.002s 14 0 select * from getrepo_files_in_all_storage_pools($1. $2. $3. $4) 1 0.001s 0.002s 0 0 select * from deleterunningjobsoftasklesscommands() as result 1 0.001s 0.002s 1 0 SELECT * FROM user_vds_permissions_view 227 0s 0.002s 0 0 SELECT * FROM user_storage_pool_permissions_view 227 0s 0.001s 0 0 SELECT * FROM user_vds_groups_permissions_view 227 0s 0.001s 0 0 CREATE TEMPORARY TABLE tt_VM_POOL_PRERESULT ( vm_pool_id UUID. assigned_vm_count INTEGER. vm_running_count INTEGER ) WITH OIDS 3 0s 0.001s 0 0 select * from public.insert_osinfo(CAST ($1 AS int4).CAST ($2 AS varchar)) as result 40 0s 0.001s 40 0 SELECT (v_repeatable OR not exists(select audit_log_id from audit_log where vds_name = v_vds_name and log_type = v_log_type and not deleted)) 7 0s 0.001s 7 0 select * from updatejoblastupdatetime($1. $2) as result 3 0s 0.001s 3 0 select * from insertstep($1. $2. $3. $4. $5. $6. $7. $8. $9. $10. $11. $12. $13) as result 2 0s 0.001s 2 0 SELECT vm_static.* FROM vm_static WHERE dedicated_vm_for_vds LIKE ?||v_vds_id::text||? and fail_back = ? AND entity_type = ? 6 0s 0.001s 0 0 SELECT * FROM storage_pool WHERE (NOT v_is_filtered OR EXISTS (SELECT ? FROM user_storage_pool_permissions_view WHERE user_id = v_user_id AND entity_id = id)) 229 0s 0.001s 0 0 select * from getjobbyjobid($1) 3 0s 0.001s 3 0 select * from updatestorage_pool($1. $2. $3. $4. $5. $6. $7. $8. $9. $10. $11. $12) as result 3 0s 0.001s 3 0 SELECT typinput=?::regproc. typtype FROM pg_catalog.pg_type WHERE typname = $1 115 0s 0.001s 106 0 "DELETE FROM ONLY ""public"".""job_subject_entity"" WHERE $1 OPERATOR(pg_catalog.=) ""job_id""" 290 0s 0.001s 290 0 CREATE TEMPORARY TABLE tt_VM_POOL_RUNNING ( vm_pool_id UUID. vm_running_count INTEGER ) WITH OIDS 3 0s 0.001s 0 0 SELECT n.nspname||?||p.proname FROM pg_proc p. pg_namespace n WHERE p.pronamespace=n.oid AND n.nspname NOT IN (?. ?); 1 0.001s 0.001s 1162 0 select audit_log_id from audit_log where vds_name = v_vds_name and log_type = v_log_type 7 0s 0.001s 7 0 select * from updatestorage_pool_status($1. $2) as result 3 0s 0.001s 3 0 select * from getallmacpoolrangesbymacpoolid($1) 2 0s 0.001s 2 0 select * from getglustervolumebricksbyserverguid($1) 1 0s 0.001s 0 0 insert INTO tt_VM_POOL_GROUP(vm_pool_id. assigned_vm_count) select vm_pools_view.vm_pool_id. count(vm_pool_map.vm_pool_id) from vm_pools_view left join vm_pool_map on vm_pools_view.vm_pool_id = vm_pool_map.vm_pool_id group by vm_pools_view.vm_pool_id.vm_pool_map.vm_pool_id 3 0s 0.001s 6 0 UPDATE dwh_history_timekeeping SET var_value = v_var_value. var_datetime = v_var_datetime WHERE var_name = v_var_name 40 0s 0.001s 40 0 select * from gettrustedvdsgroups() 1 0s 0.001s 0 0 SET extra_float_digits = 3 102 0s 0.001s 0 0 SELECT typname FROM pg_catalog.pg_type WHERE oid = $1 106 0s 0.001s 106 0 select * from getvmstaticwithouticon() 1 0s 0.001s 0 0 UPDATE vds_dynamic SET controlled_by_pm_policy = v_controlled_by_pm_policy WHERE vds_id = v_vds_id 6 0s 0.001s 6 0 select * from checkdbconnection() as result 1 0s 0.001s 1 0 COPY (SELECT date_trunc(?. now()). b.datname. c.rolname. a.setconfig FROM pg_db_role_setting a LEFT JOIN pg_database b ON (a.setdatabase=b.oid) LEFT JOIN pg_roles c ON (a.setrole=c.oid) ORDER BY 2.3) TO STDOUT CSV DELIMITER ';'; 20 0s 0.001s 60 0 select * from updatestartedexecutionentitiestounknown($1) as result 1 0s 0.001s 1 0 select * from getallfromvdcoption() 1 0s 0.001s 822 0 select * from cleandownvms() as result 1 0s 0.001s 1 0 SELECT mac_addr FROM vm_interface WHERE EXISTS(SELECT ? FROM vm_static JOIN vds_groups ON vm_static.vds_group_id = vds_groups.vds_group_id WHERE vds_groups.storage_pool_id IN (SELECT sp.id FROM storage_pool sp WHERE sp.mac_pool_id = v_id) AND vm_static.vm_guid = vm_interface.vm_guid) 2 0s 0.001s 0 0 SELECT * FROM supported_host_features WHERE host_id = v_host_id 206 0s 0.001s 0 0 INSERT INTO step( step_id. parent_step_id. job_id. step_type. description. step_number. status. start_time. end_time. correlation_id. external_id. external_system_type. is_external) VALUES ( v_step_id. v_parent_step_id. v_job_id. v_step_type. v_description. v_step_number. v_status. v_start_time. v_end_time. v_correlation_id. v_external_id. v_external_system_type. v_is_external) 2 0s 0.001s 2 0 SELECT e.typdelim FROM pg_catalog.pg_type t. pg_catalog.pg_type e WHERE t.oid = $1 and t.typelem = e.oid 76 0s 0.001s 76 0 "SELECT ? FROM ONLY ""public"".""vm_icons"" x WHERE ""id"" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x" 80 0s 0.001s 80 0 select * from getvds_spm_id_mapbystorage_pool_idandbyvds_spm_id($1. $2) 2 0s 0.001s 0 0 select * from insertjobsubjectentity($1. $2. $3) as result 1 0s 0.000s 1 0 select * from updatestep($1. $2. $3. $4. $5. $6. $7. $8. $9. $10. $11. $12) as result 1 0s 0.000s 1 0 select * from insertjob($1. $2. $3. $4. $5. $6. $7. $8. $9. $10. $11. $12) as result 1 0s 0.000s 1 0 select * from deleteallunusedvmicons() as result 1 0s 0.000s 1 0 SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED 102 0s 0.000s 0 0 SELECT TRIGGER_NAME. TRIGGER_GROUP. NEXT_FIRE_TIME. PRIORITY FROM QRTZ_TRIGGERS WHERE SCHED_NAME = ? AND TRIGGER_STATE = $1 AND NEXT_FIRE_TIME <= $2 AND (NEXT_FIRE_TIME >= $3) ORDER BY NEXT_FIRE_TIME ASC. PRIORITY DESC 46 0s 0.000s 0 0 select * from get_all_commands() 1 0s 0.000s 0 0 SELECT * FROM affinity_groups_view WHERE cluster_id = v_cluster_id 76 0s 0.000s 0 0 select * from checkifjobhastasks($1) 1 0s 0.000s 1 0 select * from getalljobidsbyentityid($1) 1 0s 0.000s 3 0 select * from getallfrompolicyunits() 3 0s 0.000s 63 0 select * from updatejobstepscompleted($1. $2. $3) as result 1 0s 0.000s 1 0 UPDATE vds_dynamic SET cpu_flags = v_cpu_flags WHERE vds_id = v_vds_id 6 0s 0.000s 6 0 select * from getallfromclusterpolicyunits() 1 0s 0.000s 64 0 select * from getidsofhostswithstatus($1) 1 0s 0.000s 194 0 UPDATE storage_pool SET status = v_status. _update_date = LOCALTIMESTAMP WHERE id = v_id 3 0s 0.000s 3 0 UPDATE storage_pool SET description = v_description. free_text_comment = v_free_text_comment. name = v_name. is_local = v_is_local. status = v_status. storage_pool_format_type = v_storage_pool_format_type. master_domain_version = v_master_domain_version. spm_vds_id = v_spm_vds_id. compatibility_version = v_compatibility_version. _update_date = LOCALTIMESTAMP. quota_enforcement_type=v_quota_enforcement_type. mac_pool_id = v_mac_pool_id WHERE id = v_id 3 0s 0.000s 3 0 select * from updatejob($1. $2. $3. $4. $5. $6. $7. $8. $9. $10. $11. $12) as result 1 0s 0.000s 1 0 INSERT INTO job_subject_entity( job_id. entity_id. entity_type) VALUES ( v_job_id. v_entity_id. v_entity_type) 1 0s 0.000s 1 0 select * from deleteallfromvmicondefaults() as result 1 0s 0.000s 1 0 select * from getallfromcommandentities() 1 0s 0.000s 0 0 SELECT * FROM storage_server_connections WHERE (v_storage_type is NULL or storage_server_connections.storage_type = v_storage_type) AND (id in (select storage from storage_domains where storage_domains.storage_pool_id = v_storage_pool_id and storage_domains.status = any(statuses)) OR (id in (select lun_storage_server_connection_map.storage_server_connection FROM lun_storage_server_connection_map INNER JOIN luns ON lun_storage_server_connection_map.lun_id = luns.lun_id INNER JOIN storage_domains ON luns.volume_group_id = storage_domains.storage WHERE (storage_domains.storage_pool_id = v_storage_pool_id and storage_domains.status = any(statuses))))) 6 0s 0.000s 0 0 select * from getquotacount() 2 0s 0.000s 2 0 SELECT storage_pool_iso_map.* FROM storage_pool_iso_map INNER JOIN storage_domain_static on storage_pool_iso_map.storage_id = storage_domain_static.id WHERE storage_pool_id = v_storage_pool_id AND storage_domain_static.storage_type != ? 9 0s 0.000s 0 0 SELECT vm_static.* FROM vm_static WHERE entity_type = ? AND (small_icon_id IS NULL OR large_icon_id IS NULL) 1 0s 0.000s 0 0 INSERT into dwh_osinfo (os_id. os_name) VALUES (v_os_id. v_os_name) 40 0s 0.000s 40 0 select * from getallfromclusterpolicys() 1 0s 0.000s 5 0 select * from getallfromglusterservices() 1 0s 0.000s 7 0 SELECT vm_template.* FROM vm_templates_view AS vm_template WHERE entity_type = ? AND (small_icon_id IS NULL OR large_icon_id IS NULL) 1 0s 0.000s 0 0 UPDATE host_device SET vm_id = ? FROM vm_dynamic WHERE host_device.vm_id = vm_dynamic.vm_guid AND vm_dynamic.status = ? 1 0s 0.000s 0 0 select * from getallfrommacpools() 1 0s 0.000s 2 0 SELECT DISTINCT vms.* FROM vms WHERE migrating_to_vds = v_vds_id 1 0s 0.000s 0 0 select * from gettagsbyparent_id($1) 1 0s 0.000s 0 0 select * from deleteallfromenginesessions() as result 1 0s 0.000s 1 0 UPDATE dwh_history_timekeeping SET var_datetime = now() where var_name = ? 40 0s 0.000s 40 0 update job SET last_update_time = v_last_update_time WHERE job_id = v_job_id 3 0s 0.000s 3 0 DELETE FROM vm_icons WHERE NOT EXISTS (SELECT ? FROM vm_icon_defaults WHERE vm_icon_defaults.small_icon_id = vm_icons.id OR vm_icon_defaults.large_icon_id = vm_icons.id) AND NOT EXISTS (SELECT ? FROM vm_static WHERE vm_static.small_icon_id = vm_icons.id OR vm_static.large_icon_id = vm_icons.id) 1 0s 0.000s 0 0 insert INTO tt_VM_POOL_RESULT(vm_pool_id. assigned_vm_count. vm_running_count. vm_pool_description. vm_pool_comment. vm_pool_name. vm_pool_type. parameters. prestarted_vms. vds_group_id. vds_group_name. max_assigned_vms_per_user. spice_proxy. is_being_destroyed) select ppr.vm_pool_id. ppr.assigned_vm_count. ppr.vm_running_count. p.vm_pool_description. p.vm_pool_comment. p.vm_pool_name. p.vm_pool_type. p.parameters. p.prestarted_vms. p.vds_group_id. p.vds_group_name. p.max_assigned_vms_per_user. p.spice_proxy. p.is_being_destroyed from tt_VM_POOL_PRERESULT ppr inner join vm_pools_view p on ppr.vm_pool_id = p.vm_pool_id 3 0s 0.000s 6 0 insert INTO tt_VM_POOL_PRERESULT(vm_pool_id. assigned_vm_count. vm_running_count) select pg.vm_pool_id. pg.assigned_vm_count. pr.vm_running_count from tt_VM_POOL_GROUP pg left join tt_VM_POOL_RUNNING pr on pg.vm_pool_id = pr.vm_pool_id 3 0s 0.000s 6 0 SELECT nspname FROM pg_namespace WHERE nspname !~ ? AND nspname <> ? ORDER BY 1 1 0s 0.000s 2 0 INSERT INTO job( job_id. action_type. description. status. owner_id. visible. start_time. end_time. last_update_time. correlation_id. is_external. is_auto_cleared) VALUES ( v_job_id. v_action_type. v_description. v_status. v_owner_id. v_visible. v_start_time. v_end_time. v_last_update_time. v_correlation_id. v_is_external. v_is_auto_cleared) 1 0s 0.000s 1 0 SELECT vms.* FROM vms WHERE auto_startup = ? and status = ? and exit_status = ? 1 0s 0.000s 0 0 select * from getallfromasync_tasks() 1 0s 0.000s 0 0 SELECT vds_id FROM vds_dynamic WHERE status = v_status 1 0s 0.000s 0 0 SELECT * FROM action_version_map WHERE action_type = v_action_type 31 0s 0.000s 0 0 SET application_name TO pgcluu; 20 0s 0.000s 0 0 SELECT vds_spm_id_map.* FROM vds_spm_id_map WHERE storage_pool_id = v_storage_pool_id AND vds_spm_id = v_vds_spm_id 2 0s 0.000s 0 0 SELECT COUNT(TRIGGER_NAME) FROM QRTZ_TRIGGERS WHERE SCHED_NAME = ? AND NOT (MISFIRE_INSTR = ?) AND NEXT_FIRE_TIME < $1 AND TRIGGER_STATE = $2 20 0s 0.000s 20 0 update step set status = ?. end_time = v_end_time where status = ? and job_id not in (select step.job_id from step step where step.external_id is not null) 1 0s 0.000s 0 0 DELETE FROM job WHERE job_id IN (SELECT job_id from step WHERE (status = ? AND step_type=?)) 1 0s 0.000s 0 0 SELECT vdc_options.* FROM vdc_options 1 0s 0.000s 0 0 SELECT job.* FROM JOB WHERE job_id = v_job_id 3 0s 0.000s 0 0 SELECT count(tgname) FROM pg_trigger WHERE NOT tgisinternal; 1 0s 0.000s 1 0 DELETE FROM job WHERE (status = ? AND action_type IN (?. ?. ?. ?)) AND job_id not in (select job_id from step where step_id in (select step_id from async_tasks)) 1 0s 0.000s 0 0 SELECT * FROM vds WHERE recoverable AND status = ? 4 0s 0.000s 0 0 update job set status = ?. end_time = v_end_time. last_update_time = v_end_time where job.status = ? and job_id not in (select job_id from step where external_id is not null) 1 0s 0.000s 0 0 SELECT * FROM storage_domains WHERE recoverable AND status = ? 4 0s 0.000s 0 0 DELETE FROM vm_icon_defaults 1 0s 0.000s 40 0 SELECT job_subject_entity.job_id FROM job_subject_entity WHERE entity_id = v_entity_id 1 0s 0.000s 0 0 update job SET action_type = v_action_type. description = v_description. status = v_status. owner_id = v_owner_id. visible = v_visible. start_time = v_start_time. end_time = v_end_time. last_update_time = v_last_update_time. correlation_id = v_correlation_id. is_external = v_is_external. is_auto_cleared = v_is_auto_cleared WHERE job_id = v_job_id 1 0s 0.000s 1 0 SELECT * FROM QRTZ_LOCKS WHERE SCHED_NAME = ? AND LOCK_NAME = $1 FOR UPDATE 1 0s 0.000s 1 0 UPDATE step SET parent_step_id = v_parent_step_id. job_id = v_job_id. step_type = v_step_type. description = v_description. step_number = v_step_number. status = v_status. start_time = v_start_time. end_time = v_end_time. correlation_id = v_correlation_id. external_id = v_external_id. external_system_type = v_external_system_type WHERE step_id = v_step_id 1 0s 0.000s 1 0 SELECT * FROM cluster_policy_units 1 0s 0.000s 0 0 UPDATE step SET status = v_status. end_time = v_end_time WHERE job_id = v_job_id AND status = ? AND STATUS != v_status 1 0s 0.000s 1 0 SELECT * FROM policy_units 3 0s 0.000s 0 0 "SELECT ? FROM ONLY ""public"".""job"" x WHERE ""job_id"" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x" 3 0s 0.000s 3 0 SELECT * FROM mac_pool_ranges WHERE mac_pool_id = v_id 2 0s 0.000s 0 0 update tt_VM_POOL_PRERESULT set vm_running_count = ? where vm_running_count is NULL 3 0s 0.000s 3 0 SELECT EXISTS( SELECT * FROM step WHERE job_id = v_job_id AND external_id is not null AND external_system_type in (?.?)) 1 0s 0.000s 0 0 SELECT TRIGGER_NAME. TRIGGER_GROUP FROM QRTZ_TRIGGERS WHERE SCHED_NAME = ? AND NOT (MISFIRE_INSTR = ?) AND NEXT_FIRE_TIME < $1 AND TRIGGER_STATE = $2 ORDER BY NEXT_FIRE_TIME ASC. PRIORITY DESC 1 0s 0.000s 0 0 DELETE FROM vds_kdump_status WHERE vds_id = v_vds_id AND status = ? 6 0s 0.000s 0 0 DELETE FROM engine_sessions 1 0s 0.000s 0 0 SELECT * from command_entities 1 0s 0.000s 0 0 SELECT extname||?||extversion FROM pg_extension; 1 0s 0.000s 1 0 SELECT vds_groups_view.* FROM vds_groups_view WHERE trusted_service 1 0s 0.000s 0 0 SELECT * FROM cluster_policies 1 0s 0.000s 0 0 SELECT distinct b.storage_domain_id.c.last_refreshed.b.file_type FROM storage_domain_file_repos b LEFT OUTER JOIN (SELECT storage_domain_id.file_type.min(last_refreshed) as last_refreshed FROM storage_domain_file_repos a Group by storage_domain_id.file_type) as c ON b.storage_domain_id = c.storage_domain_id AND b.file_type = c.file_type WHERE b.storage_domain_type = v_storage_domain_type and b.storage_pool_status = v_storage_pool_status and b.storage_domain_status = v_storage_domain_status and b.vds_status = v_vds_status 1 0s 0.000s 0 0 UPDATE QRTZ_TRIGGERS SET TRIGGER_STATE = $1 WHERE SCHED_NAME = ? AND (TRIGGER_STATE = $2 OR TRIGGER_STATE = $3) 2 0s 0.000s 0 0 select * from tt_VM_POOL_RESULT 3 0s 0.000s 0 0 SELECT count(*) as num_quota FROM quota 2 0s 0.000s 0 0 SELECT * FROM gluster_volume_bricks_view WHERE server_id = v_server_id ORDER BY brick_order 1 0s 0.000s 0 0 SELECT * FROM gluster_services 1 0s 0.000s 0 0 SELECT * FROM async_tasks 1 0s 0.000s 0 0 SELECT * FROM QRTZ_FIRED_TRIGGERS WHERE SCHED_NAME = ? AND INSTANCE_NAME = $1 AND REQUESTS_RECOVERY = $2 1 0s 0.000s 0 0 SELECT * FROM mac_pools 1 0s 0.000s 0 0 SELECT TRIGGER_NAME. TRIGGER_GROUP FROM QRTZ_TRIGGERS WHERE SCHED_NAME = ? AND TRIGGER_STATE = $1 1 0s 0.000s 0 0 SELECT tags.* FROM tags WHERE parent_id = v_parent_id 1 0s 0.000s 0 0 SELECT distinct business_entity_snapshot.command_id. business_entity_snapshot.command_type FROM business_entity_snapshot 1 0s 0.000s 0 0 DELETE FROM QRTZ_FIRED_TRIGGERS WHERE SCHED_NAME = ? 1 0s 0.000s 0 0