• Home
  • SysInfo
  • Cluster
    • Databases sizes
    • Tablespaces sizes
    • Connections
      • Connections
      • Connections by type
    • Deadlocks
    • Cache utilization
    • Shared buffers statistics
      • Shared buffers utilization
      • Database in shared buffers
      • Usagecount in shared buffers
      • Usagecount in dirty buffers
    • Background writer
      • Background writer buffers
      • Background writer counters
    • Temporary files
      • Temporary files
      • Temporary files size
    • Wal / Checkpoint
      • Wal files
      • Wal bytes written
      • Checkpoints counter
      • Checkpoints write time
      • Archiver stats
    • Queries Reads / Writes
      • Read tuples
      • Write ratio
      • Read vs Write queries
      • Commits vs Rollbacks
    • Replication statistics
      • Replication lag
      • Canceled queries
      • Conflicts
    • Configurations
      • PostgreSQL configuration
      • PostgreSQL settings
      • Database/Roles settings
      • PostgreSQL ALTER SYSTEM configuration
      • PostgreSQL recovery configuration
      • PostgreSQL authorization
      • User Name Maps
      • Pgbouncer settings
  • Databases
    • engine
      • Database info
      • Tables statistics
        • Size and tuples
      • Indexes statistics
        • Size and tuples
        • Unused Indexes
        • Redundant indexes
        • Missing indexes
      • Buffercache Statistics
      • Statements statistics
      • Database size
      • Connections
        • Connections
        • Connections by type
      • Cache utilization
      • Locks
        • Deadlocks
        • Locks per types
        • Locks per modes
        • Locks granted or not
      • Temporary files
        • Temporary files
        • Temporary files size
      • Queries Reads / Writes
        • Read tuples
        • Write ratio
        • Read vs Write queries
        • Commits vs Rollbacks
      • Canceled queries
      • Conflicts
    • engine2
      • Database info
      • Tables statistics
      • Indexes statistics
      • Buffercache Statistics
      • Statements statistics
      • Database size
      • Connections
        • Connections
        • Connections by type
      • Cache utilization
      • Locks
        • Deadlocks
        • Locks per types
        • Locks per modes
        • Locks granted or not
      • Temporary files
        • Temporary files
        • Temporary files size
      • Queries Reads / Writes
        • Read tuples
        • Write ratio
        • Read vs Write queries
        • Commits vs Rollbacks
      • Canceled queries
      • Conflicts
    • engine_dao_tests
      • Database info
      • Tables statistics
      • Indexes statistics
      • Buffercache Statistics
      • Statements statistics
      • Database size
      • Connections
        • Connections
        • Connections by type
      • Cache utilization
      • Locks
        • Deadlocks
        • Locks per types
        • Locks per modes
        • Locks granted or not
      • Temporary files
        • Temporary files
        • Temporary files size
      • Queries Reads / Writes
        • Read tuples
        • Write ratio
        • Read vs Write queries
        • Commits vs Rollbacks
      • Canceled queries
      • Conflicts
    • postgres
      • Database info
      • Tables statistics
      • Indexes statistics
      • Buffercache Statistics
      • Statements statistics
      • Database size
      • Connections
        • Connections
        • Connections by type
      • Cache utilization
      • Locks
        • Deadlocks
        • Locks per types
        • Locks per modes
        • Locks granted or not
      • Temporary files
        • Temporary files
        • Temporary files size
      • Queries Reads / Writes
        • Read tuples
        • Write ratio
        • Read vs Write queries
        • Commits vs Rollbacks
      • Canceled queries
      • Conflicts
  • System
    • Cpu
    • Memory
    • Swap
    • Load
    • Task list
    • Run queue
    • Context switches
    • Tasks created per second
    • Blocks
    • Transfers per second
    • Pages
    • Devices
      • sda
        • Cpu utilization
        • Read/write bytes per second
        • Transfert per second
        • Average service time
      • luks-9a431792-a6b7-43f9-9f68-b77a9e4784ba
        • Cpu utilization
        • Read/write bytes per second
        • Transfert per second
        • Average service time
      • fedora_dhcp131--31-root
        • Cpu utilization
        • Read/write bytes per second
        • Transfert per second
        • Average service time
      • fedora_dhcp131--31-swap
        • Cpu utilization
        • Read/write bytes per second
        • Transfert per second
        • Average service time
      • fedora_dhcp131--31-home
        • Cpu utilization
        • Read/write bytes per second
        • Transfert per second
        • Average service time
      • loop0
        • Cpu utilization
        • Read/write bytes per second
        • Transfert per second
        • Average service time
      • loop1
        • Cpu utilization
        • Read/write bytes per second
        • Transfert per second
        • Average service time
      • docker-253:1-632-pool
        • Cpu utilization
        • Read/write bytes per second
        • Transfert per second
        • Average service time
    • Network
      • wlp4s0
        • Network utilization
        • Network errors
      • virbr0-nic
        • Network utilization
        • Network errors
      • docker0
        • Network utilization
        • Network errors
      • bond0
        • Network utilization
        • Network errors
      • virbr0
        • Network utilization
        • Network errors
      • lo
        • Network utilization
        • Network errors
      • em1
        • Network utilization
        • Network errors
  • About




  • 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)778710.026s33m49s1725430
    select * from getvdsbyvdsid($1. $2. $3)791730s1m1s791730
    select * from getvmbyvmguid($1. $2. $3)19980.010s21.795s19980
    select * from getvmnetworkinterfaceviewbyvmid($1. $2. $3)360060s15.649s360060
    SELECT DISTINCT vds.* FROM vds WHERE vds_id = v_vds_id791730s15.124s00
    select * from getallfromvms($1. $2)2280.050s11.440s11901632.60 K
    select * from getinterface_viewbyvds_id($1. $2. $3)161410s9.659s1129870
    select * from getallnetworkbyclusterid($1. $2. $3)159210s9.186s159210
    SELECT DISTINCT vms.* FROM vms WHERE run_on_vds = v_vds_id778710s8.157s00
    select * from getvdsgroupbyvdsgroupid($1. $2. $3)163550s5.558s163550
    select * from getqosbyqosid($1)1150470s5.313s00
    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 result1100050s5.203s1100050
    SELECT DISTINCT vms.* FROM vms ORDER BY vm_guid2280.021s4.990s016.42 K
    select * from getallfromvds($1. $2)2350.018s4.457s474700
    select * from getstoragedomainidsbystoragepoolidandstatus($1. $2)786170s4.398s00
    select * from getstorage_poolbyid($1. $2. $3)158600s4.174s158600
    select ?13434510s2.786s13434500
    select * from getalluserpermissions($1)9080.002s2.438s00
    select * from getallvmjobids()778700s2.270s00
    select * from getallassignednumanodeinfomation()345080s2.114s00
    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))360060s2.105s00
    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 result160010s1.982s160010
    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 result345080s1.885s345080
    select * from getnumanodecpubyvdsid($1)345080s1.845s00
    select * from getnumanodecpubyvmid($1)345080s1.796s00
    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_id1100050s1.762s1100050
    select * from getvdsdynamicbyvdsid($1)164020s1.751s164020
    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))161410s1.494s00
    select * from getstorage_domains_by_storagepoolid($1. $2. $3)1250.010s1.355s1250
    select * from getvmjobsbyvmid($1)345080s1.289s00
    select * from getnumanodebyvdsid($1)345080s1.254s00
    select * from getnumanodebyvmid($1)345080s1.214s00
    select * from getvm_poolsbyvm_pool_id($1. $2. $3)4990.002s1.190s4990
    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 result345080s1.162s345080
    select * from insertvmguestagentinterface($1. $2. $3. $4. $5) as result345080s1.138s345080
    select * from getvdswithoutmigratingvmsbyvdsgroupid($1)760.014s1.125s38000
    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 result345080s1.048s345080
    select * from getvdsbystoragepoolidwithstatus($1. $2)1180.008s1.028s236000
    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 result345080s0.980s345080
    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_id160010s0.965s160010
    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 ';';200.046s0.938s166220
    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 ';';200.046s0.921s166220
    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))19980s0.824s00
    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))1250.005s0.732s00
    select * from getstorage_domains_by_id_and_by_storage_pool_id($1. $2)2360.003s0.730s1180
    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)345080s0.719s345080
    SELECT array_to_string(array_agg(vds_id). ?) FROM vm_host_pinning_map WHERE vm_id = v_vm_id2955860s0.694s2955860
    select * from getallfromvdsgroups($1. $2)7540s0.669s30160
    select * from getvmdevicebyvmidtypeanddevice($1. $2. $3. $4. $5)15000s0.667s5000
    select * from gettemplatewithlatestversioninchain($1)4990.001s0.653s4990
    select * from deletevmguestagentinterfacesbyvmid($1) as result345080s0.630s345080
    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 != ?786170s0.615s00
    SELECT * FROM storage_domains WHERE id = v_id and storage_pool_id = v_storage_pool_id2360.002s0.606s00
    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))2350.002s0.604s00
    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_guid345080s0.533s345080
    SELECT * FROM qos WHERE id = v_id1150470s0.497s00
    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.name159210s0.469s00
    select * from getvmsbyids($1)760.005s0.424s00
    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))4990s0.405s00
    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))163550s0.400s00
    SELECT numa_node_cpus_view.* FROM numa_node_cpus_view WHERE vds_id = v_vds_id345080s0.391s00
    SELECT numa_node_cpus_view.* FROM numa_node_cpus_view WHERE vm_id = v_vm_id345080s0.369s00
    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_guid345080s0.340s345080
    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_id345080s0.301s345080
    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 = ?1180.002s0.289s00
    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 )2490.001s0.265s2490
    SELECT vds_dynamic.* FROM vds_dynamic WHERE vds_id = v_vds_id164020s0.263s00
    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 )2490.001s0.258s2490
    select * from getsnapshotbyvmidandtype($1. $2. $3. $4)5000s0.253s00
    select * from getusersbyvmguid($1)19960s0.250s00
    select * from getallfromhostdevices()5000s0.207s955000
    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 ?4990s0.195s00
    DELETE FROM vm_guest_agent_interfaces WHERE vm_id = v_vm_id345080s0.185s345080
    SELECT numa_node.* FROM numa_node WHERE vds_id = v_vds_id345080s0.179s00
    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 result14420s0.171s14420
    SELECT numa_node.* FROM numa_node WHERE vm_id = v_vm_id345080s0.160s00
    select * from checkifsnapshotexistsbyvmidandtype($1. $2)14980s0.154s14980
    select * from getvmsbyvmpoolid($1)60.025s0.153s15300
    "SELECT ? FROM ONLY ""public"".""vm_static"" x WHERE ""vm_guid"" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x"345080s0.147s345080
    SELECT vm_jobs.* FROM vm_jobs WHERE vm_jobs.vm_id = v_vm_id345080s0.144s00
    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 ';';200.006s0.134s19800
    select * from public.clear_network_from_nics(CAST ($1 AS uuid)) as result14420s0.128s14420
    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 ';';200.006s0.124s12800
    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))158600s0.119s00
    select * from getnetworkattachmentsbyhostid($1)2060s0.107s2060
    select * from getallfromstorage_pool($1. $2)2290s0.100s2290
    select * from getstorage_domain_by_type_storagepoolid_and_status($1. $2. $3)60.015s0.096s60
    select * from get_entity_snapshot_by_command_id($1)7010s0.093s00
    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 ';';200.004s0.090s19800
    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 ';';200.004s0.090s12800
    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)60.014s0.088s00
    SELECT vm_jobs.vm_job_id FROM vm_jobs778700s0.086s00
    SELECT vms.* FROM vms WHERE vm_pool_id = v_vm_pool_id60.014s0.085s00
    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)345080s0.083s00
    select * from getsnapshotidsbyvmidandtype($1. $2)4990s0.079s00
    select * from getvmsdynamicrunningonvds($1)2060s0.079s5000
    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 ';';200.003s0.078s00
    select * from getsupportedclusterfeaturesbyclusterid($1)2000s0.077s00
    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 ';';200.003s0.074s33480
    select * from getupandprioritizedvds($1)50.014s0.073s10000
    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(?.?.?.?))760s0.072s00
    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 ';';200.003s0.069s47000
    COPY (SELECT date_trunc(?. now()). current_database(). * FROM pg_stat_user_functions WHERE schemaname <> ? ORDER BY schemaname. funcname) TO STDOUT CSV DELIMITER ';';200.003s0.069s00
    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 ';';200.003s0.064s47000
    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 ';';200.003s0.063s57600
    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 ';';200.003s0.062s33480
    select * from getmanagementnetworkbycluster($1)2060s0.056s2060
    select * from delete_entity_snapshot_by_command_id($1) as result5020s0.055s5020
    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 ';';200.002s0.055s57600
    COPY (SELECT date_trunc('seconds'. now()). * FROM pg_stat_xact_user_tables WHERE schemaname <> 'information_schema' ORDER BY 3. 4) TO STDOUT CSV DELIMITER ';';200.002s0.055s33480
    select * from getvdsstaticbyvdsid($1)2310s0.054s2310
    select * from existsvmdevicebyvmidandtype($1. $2)5000s0.050s5000
    SELECT numa_node_assignment_view.* FROM numa_node_assignment_view345080s0.049s00
    COPY (SELECT date_trunc(?. now()). current_database(). * FROM pg_statio_user_tables WHERE schemaname <> ? ORDER BY schemaname. relname) TO STDOUT CSV DELIMITER ';';200.002s0.049s33480
    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_id14420s0.048s14420
    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 ';';200.002s0.047s3200
    COPY (SELECT date_trunc(?. now()). current_database(). * FROM pg_statio_user_indexes WHERE schemaname <> ? ORDER BY schemaname. relname) TO STDOUT CSV DELIMITER ';';200.002s0.044s57600
    select * from getnetworkattachmentbynicidandnetworkid($1. $2)2060s0.043s2060
    COPY (SELECT date_trunc(?. now()). current_database(). * FROM pg_stat_user_indexes WHERE schemaname <> ? ORDER BY schemaname. relname) TO STDOUT CSV DELIMITER ';';200.002s0.043s57600
    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 ';';200.002s0.042s33480
    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 ';';200.002s0.041s3200
    COPY (SELECT date_trunc(?. now()). * FROM pg_stat_xact_user_tables WHERE schemaname <> ? ORDER BY 3. 4) TO STDOUT CSV DELIMITER ';';200.001s0.039s33480
    select * from getallaffinitygroupsbyclusterid($1)760s0.038s00
    UPDATE vds_interface SET network_name = ? WHERE id = v_id14420s0.036s14420
    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 LAST15000s0.036s00
    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()50.006s0.033s00
    select * from getvmsmigratingtovds($1)10.032s0.032s00
    select * from getsupportedhostfeaturesbyhostid($1)2060s0.031s00
    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 result230.001s0.030s230
    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 ';';200.001s0.028s3400
    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_guid19960s0.025s00
    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))7540s0.024s00
    select * from getstorageconnectionsbystoragetypeandstatus($1. $2. $3)60.003s0.023s00
    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)2060s0.021s00
    select * from getallfromvm_pools()30.006s0.019s60
    COPY (SELECT date_trunc('seconds'. now()). * FROM pg_stat_xact_user_functions WHERE schemaname <> 'information_schema' ORDER BY 3. 4) TO STDOUT CSV DELIMITER ';';200s0.019s00
    select * from clear_osinfo() as result10.018s0.019s10
    TRUNCATE dwh_osinfo10.018s0.019s00
    BEGIN335640s0.019s00
    select * from getvdsgroupswithoutmigratingvms()190s0.018s760
    SELECT * FROM host_device5000s0.018s00
    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 1870s0.017s1870
    COPY (SELECT date_trunc(?. now()). current_database(). * FROM pg_statio_user_sequences WHERE schemaname <> ? ORDER BY schemaname. relname) TO STDOUT CSV DELIMITER ';';200s0.016s3400
    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 1870s0.015s1870
    COMMIT335640s0.014s00
    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 result240s0.013s240
    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 ';';200s0.013s600
    select * from getfailingvdss()40.003s0.012s00
    COPY (SELECT date_trunc(?. now()). * FROM pg_stat_xact_user_functions WHERE schemaname <> ? ORDER BY 3. 4) TO STDOUT CSV DELIMITER ';';200s0.012s00
    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 ';';200s0.011s200
    SELECT EXISTS( SELECT * FROM snapshots WHERE vm_id = v_vm_id AND snapshot_type = v_snapshot_type)14980s0.011s00
    SELECT vds_static.* FROM vds_static WHERE vds_id = v_vds_id2310s0.011s00
    select * from deletecompletedjobsolderthandate($1. $2) as result10.009s0.010s10
    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 (?. ?. ?))))10.009s0.009s2900
    select * from getaction_version_mapbyaction_type($1)310s0.009s00
    SELECT business_entity_snapshot.* FROM business_entity_snapshot WHERE command_id = v_command_id order by insertion_order desc7010s0.008s00
    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 ';';200s0.008s480
    select * from updatedwhhistorytimekeeping($1. $2. $3) as result400s0.008s400
    select * from getvmiconbyvmicondataurl($1)800s0.008s800
    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 ?5000s0.007s00
    SELECT snapshot_id FROM snapshots WHERE vm_id = v_vm_id AND snapshot_type = v_snapshot_type ORDER BY creation_date ASC4990s0.007s00
    SELECT vm.* FROM vms vm WHERE vm.vm_guid IN (SELECT * from fnSplitterUuid(v_vms_ids))760s0.007s00
    select * from getfailedautostartvms()10.006s0.007s00
    SELECT EXISTS( SELECT ? FROM vm_device WHERE vm_id = v_vm_id AND type = v_type)5000s0.006s5000
    SELECT a.attname.a.atttypid FROM pg_catalog.pg_attribute a WHERE a.attrelid = ? AND a.attnum > ? ORDER BY a.attnum 1330s0.006s40960
    select * from getvmstaticwithfailbackbyvdsid($1)60s0.006s00
    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)160s0.005s160
    select * from insertvmicondefault($1. $2. $3. $4) as result400s0.005s400
    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 ';';200s0.005s400
    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)400s0.004s400
    select * from getfailingstorage_domains()40s0.004s00
    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_id30.001s0.004s30
    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(?.?))190s0.003s00
    select * from getstorage_pool_iso_mapsbybystorage_pool_id($1. $2)90s0.003s90
    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 OIDS30.001s0.003s00
    select * from getallmacsbymacpoolid($1)20.001s0.003s5280
    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 ';';200s0.003s200
    CREATE TEMPORARY TABLE tt_VM_POOL_GROUP ( vm_pool_id UUID. assigned_vm_count INTEGER ) WITH OIDS30s0.003s00
    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 ';';200s0.003s480
    SELECT network.* FROM network WHERE id = (SELECT network_id FROM network_cluster WHERE network_cluster.cluster_id = v_cluster_id AND network_cluster.management)2060s0.003s00
    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_id240s0.003s240
    select * from removefinishedkdumpstatusforvds($1) as result60s0.003s60
    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 ';';200s0.003s400
    SELECT vm_dynamic.* FROM vm_dynamic WHERE RUN_ON_VDS = v_vds_id2060s0.003s00
    delete from business_entity_snapshot where command_id = v_command_id5020s0.002s00
    SELECT * FROM vm_icons WHERE data_url = v_data_url800s0.002s00
    select * from updatevdsdynamicpowermanagementpolicyflag($1. $2) as result60s0.002s60
    SELECT * FROM supported_cluster_features_view WHERE cluster_id = v_cluster_id2000s0.002s00
    SELECT * FROM user_vm_permissions_view2270s0.002s00
    select * from updatecpuflags($1. $2) as result60s0.002s60
    SELECT na.* FROM network_attachments na WHERE na.network_id = v_network_id and na.nic_id = v_nic_id2060s0.002s00
    select * from getvmtemplateswithouticon()10.001s0.002s00
    "DELETE FROM ONLY ""public"".""step"" WHERE $1 OPERATOR(pg_catalog.=) ""job_id"""2900s0.002s5290
    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 140s0.002s140
    select * from getrepo_files_in_all_storage_pools($1. $2. $3. $4)10.001s0.002s00
    select * from deleterunningjobsoftasklesscommands() as result10.001s0.002s10
    SELECT * FROM user_vds_permissions_view2270s0.002s00
    SELECT * FROM user_storage_pool_permissions_view2270s0.001s00
    SELECT * FROM user_vds_groups_permissions_view2270s0.001s00
    CREATE TEMPORARY TABLE tt_VM_POOL_PRERESULT ( vm_pool_id UUID. assigned_vm_count INTEGER. vm_running_count INTEGER ) WITH OIDS30s0.001s00
    select * from public.insert_osinfo(CAST ($1 AS int4).CAST ($2 AS varchar)) as result400s0.001s400
    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))70s0.001s70
    select * from updatejoblastupdatetime($1. $2) as result30s0.001s30
    select * from insertstep($1. $2. $3. $4. $5. $6. $7. $8. $9. $10. $11. $12. $13) as result20s0.001s20
    SELECT vm_static.* FROM vm_static WHERE dedicated_vm_for_vds LIKE ?||v_vds_id::text||? and fail_back = ? AND entity_type = ?60s0.001s00
    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))2290s0.001s00
    select * from getjobbyjobid($1)30s0.001s30
    select * from updatestorage_pool($1. $2. $3. $4. $5. $6. $7. $8. $9. $10. $11. $12) as result30s0.001s30
    SELECT typinput=?::regproc. typtype FROM pg_catalog.pg_type WHERE typname = $11150s0.001s1060
    "DELETE FROM ONLY ""public"".""job_subject_entity"" WHERE $1 OPERATOR(pg_catalog.=) ""job_id"""2900s0.001s2900
    CREATE TEMPORARY TABLE tt_VM_POOL_RUNNING ( vm_pool_id UUID. vm_running_count INTEGER ) WITH OIDS30s0.001s00
    SELECT n.nspname||?||p.proname FROM pg_proc p. pg_namespace n WHERE p.pronamespace=n.oid AND n.nspname NOT IN (?. ?);10.001s0.001s11620
    select audit_log_id from audit_log where vds_name = v_vds_name and log_type = v_log_type70s0.001s70
    select * from updatestorage_pool_status($1. $2) as result30s0.001s30
    select * from getallmacpoolrangesbymacpoolid($1)20s0.001s20
    select * from getglustervolumebricksbyserverguid($1)10s0.001s00
    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_id30s0.001s60
    UPDATE dwh_history_timekeeping SET var_value = v_var_value. var_datetime = v_var_datetime WHERE var_name = v_var_name400s0.001s400
    select * from gettrustedvdsgroups()10s0.001s00
    SET extra_float_digits = 31020s0.001s00
    SELECT typname FROM pg_catalog.pg_type WHERE oid = $11060s0.001s1060
    select * from getvmstaticwithouticon()10s0.001s00
    UPDATE vds_dynamic SET controlled_by_pm_policy = v_controlled_by_pm_policy WHERE vds_id = v_vds_id60s0.001s60
    select * from checkdbconnection() as result10s0.001s10
    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 ';';200s0.001s600
    select * from updatestartedexecutionentitiestounknown($1) as result10s0.001s10
    select * from getallfromvdcoption()10s0.001s8220
    select * from cleandownvms() as result10s0.001s10
    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)20s0.001s00
    SELECT * FROM supported_host_features WHERE host_id = v_host_id2060s0.001s00
    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)20s0.001s20
    SELECT e.typdelim FROM pg_catalog.pg_type t. pg_catalog.pg_type e WHERE t.oid = $1 and t.typelem = e.oid760s0.001s760
    "SELECT ? FROM ONLY ""public"".""vm_icons"" x WHERE ""id"" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x"800s0.001s800
    select * from getvds_spm_id_mapbystorage_pool_idandbyvds_spm_id($1. $2)20s0.001s00
    select * from insertjobsubjectentity($1. $2. $3) as result10s0.000s10
    select * from updatestep($1. $2. $3. $4. $5. $6. $7. $8. $9. $10. $11. $12) as result10s0.000s10
    select * from insertjob($1. $2. $3. $4. $5. $6. $7. $8. $9. $10. $11. $12) as result10s0.000s10
    select * from deleteallunusedvmicons() as result10s0.000s10
    SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED1020s0.000s00
    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 DESC460s0.000s00
    select * from get_all_commands()10s0.000s00
    SELECT * FROM affinity_groups_view WHERE cluster_id = v_cluster_id760s0.000s00
    select * from checkifjobhastasks($1)10s0.000s10
    select * from getalljobidsbyentityid($1)10s0.000s30
    select * from getallfrompolicyunits()30s0.000s630
    select * from updatejobstepscompleted($1. $2. $3) as result10s0.000s10
    UPDATE vds_dynamic SET cpu_flags = v_cpu_flags WHERE vds_id = v_vds_id60s0.000s60
    select * from getallfromclusterpolicyunits()10s0.000s640
    select * from getidsofhostswithstatus($1)10s0.000s1940
    UPDATE storage_pool SET status = v_status. _update_date = LOCALTIMESTAMP WHERE id = v_id30s0.000s30
    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_id30s0.000s30
    select * from updatejob($1. $2. $3. $4. $5. $6. $7. $8. $9. $10. $11. $12) as result10s0.000s10
    INSERT INTO job_subject_entity( job_id. entity_id. entity_type) VALUES ( v_job_id. v_entity_id. v_entity_type)10s0.000s10
    select * from deleteallfromvmicondefaults() as result10s0.000s10
    select * from getallfromcommandentities()10s0.000s00
    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)))))60s0.000s00
    select * from getquotacount()20s0.000s20
    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 != ?90s0.000s00
    SELECT vm_static.* FROM vm_static WHERE entity_type = ? AND (small_icon_id IS NULL OR large_icon_id IS NULL)10s0.000s00
    INSERT into dwh_osinfo (os_id. os_name) VALUES (v_os_id. v_os_name)400s0.000s400
    select * from getallfromclusterpolicys()10s0.000s50
    select * from getallfromglusterservices()10s0.000s70
    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)10s0.000s00
    UPDATE host_device SET vm_id = ? FROM vm_dynamic WHERE host_device.vm_id = vm_dynamic.vm_guid AND vm_dynamic.status = ?10s0.000s00
    select * from getallfrommacpools()10s0.000s20
    SELECT DISTINCT vms.* FROM vms WHERE migrating_to_vds = v_vds_id10s0.000s00
    select * from gettagsbyparent_id($1)10s0.000s00
    select * from deleteallfromenginesessions() as result10s0.000s10
    UPDATE dwh_history_timekeeping SET var_datetime = now() where var_name = ?400s0.000s400
    update job SET last_update_time = v_last_update_time WHERE job_id = v_job_id30s0.000s30
    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)10s0.000s00
    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_id30s0.000s60
    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_id30s0.000s60
    SELECT nspname FROM pg_namespace WHERE nspname !~ ? AND nspname <> ? ORDER BY 110s0.000s20
    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)10s0.000s10
    SELECT vms.* FROM vms WHERE auto_startup = ? and status = ? and exit_status = ?10s0.000s00
    select * from getallfromasync_tasks()10s0.000s00
    SELECT vds_id FROM vds_dynamic WHERE status = v_status10s0.000s00
    SELECT * FROM action_version_map WHERE action_type = v_action_type310s0.000s00
    SET application_name TO pgcluu;200s0.000s00
    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_id20s0.000s00
    SELECT COUNT(TRIGGER_NAME) FROM QRTZ_TRIGGERS WHERE SCHED_NAME = ? AND NOT (MISFIRE_INSTR = ?) AND NEXT_FIRE_TIME < $1 AND TRIGGER_STATE = $2200s0.000s200
    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)10s0.000s00
    DELETE FROM job WHERE job_id IN (SELECT job_id from step WHERE (status = ? AND step_type=?))10s0.000s00
    SELECT vdc_options.* FROM vdc_options10s0.000s00
    SELECT job.* FROM JOB WHERE job_id = v_job_id30s0.000s00
    SELECT count(tgname) FROM pg_trigger WHERE NOT tgisinternal;10s0.000s10
    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))10s0.000s00
    SELECT * FROM vds WHERE recoverable AND status = ?40s0.000s00
    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)10s0.000s00
    SELECT * FROM storage_domains WHERE recoverable AND status = ?40s0.000s00
    DELETE FROM vm_icon_defaults10s0.000s400
    SELECT job_subject_entity.job_id FROM job_subject_entity WHERE entity_id = v_entity_id10s0.000s00
    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_id10s0.000s10
    SELECT * FROM QRTZ_LOCKS WHERE SCHED_NAME = ? AND LOCK_NAME = $1 FOR UPDATE10s0.000s10
    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_id10s0.000s10
    SELECT * FROM cluster_policy_units10s0.000s00
    UPDATE step SET status = v_status. end_time = v_end_time WHERE job_id = v_job_id AND status = ? AND STATUS != v_status10s0.000s10
    SELECT * FROM policy_units30s0.000s00
    "SELECT ? FROM ONLY ""public"".""job"" x WHERE ""job_id"" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x"30s0.000s30
    SELECT * FROM mac_pool_ranges WHERE mac_pool_id = v_id20s0.000s00
    update tt_VM_POOL_PRERESULT set vm_running_count = ? where vm_running_count is NULL30s0.000s30
    SELECT EXISTS( SELECT * FROM step WHERE job_id = v_job_id AND external_id is not null AND external_system_type in (?.?))10s0.000s00
    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 DESC10s0.000s00
    DELETE FROM vds_kdump_status WHERE vds_id = v_vds_id AND status = ?60s0.000s00
    DELETE FROM engine_sessions10s0.000s00
    SELECT * from command_entities10s0.000s00
    SELECT extname||?||extversion FROM pg_extension;10s0.000s10
    SELECT vds_groups_view.* FROM vds_groups_view WHERE trusted_service10s0.000s00
    SELECT * FROM cluster_policies10s0.000s00
    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_status10s0.000s00
    UPDATE QRTZ_TRIGGERS SET TRIGGER_STATE = $1 WHERE SCHED_NAME = ? AND (TRIGGER_STATE = $2 OR TRIGGER_STATE = $3)20s0.000s00
    select * from tt_VM_POOL_RESULT30s0.000s00
    SELECT count(*) as num_quota FROM quota20s0.000s00
    SELECT * FROM gluster_volume_bricks_view WHERE server_id = v_server_id ORDER BY brick_order10s0.000s00
    SELECT * FROM gluster_services10s0.000s00
    SELECT * FROM async_tasks10s0.000s00
    SELECT * FROM QRTZ_FIRED_TRIGGERS WHERE SCHED_NAME = ? AND INSTANCE_NAME = $1 AND REQUESTS_RECOVERY = $210s0.000s00
    SELECT * FROM mac_pools10s0.000s00
    SELECT TRIGGER_NAME. TRIGGER_GROUP FROM QRTZ_TRIGGERS WHERE SCHED_NAME = ? AND TRIGGER_STATE = $110s0.000s00
    SELECT tags.* FROM tags WHERE parent_id = v_parent_id10s0.000s00
    SELECT distinct business_entity_snapshot.command_id. business_entity_snapshot.command_type FROM business_entity_snapshot10s0.000s00
    DELETE FROM QRTZ_FIRED_TRIGGERS WHERE SCHED_NAME = ?10s0.000s00

© Gilles Darold 2012-2015

Report generated by pgCluu 2.4.