• 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)778910.025s33m29s1725440
    select * from getvdsbyvdsid($1. $2. $3)791710s1m9s791710
    select * from getvmbyvmguid($1. $2. $3)19980.010s21.141s19980
    select * from getvmnetworkinterfaceviewbyvmid($1. $2. $3)360070s15.847s360070
    select * from getinterface_viewbyvds_id($1. $2. $3)161360s14.700s1129520
    SELECT DISTINCT vds.* FROM vds WHERE vds_id = v_vds_id791710s14.329s00
    select * from getallnetworkbyclusterid($1. $2. $3)159230s8.715s159230
    SELECT DISTINCT vms.* FROM vms WHERE run_on_vds = v_vds_id778910s7.906s00
    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 result1100190s5.134s1100190
    select * from getvdsgroupbyvdsgroupid($1. $2. $3)163600s5.105s163600
    select * from getqosbyqosid($1)1150120s4.997s00
    select * from getstoragedomainidsbystoragepoolidandstatus($1. $2)786270s4.235s00
    select * from getstorage_poolbyid($1. $2. $3)158700s4.007s158700
    select ?13418280s2.706s13418270
    select * from getallvmjobids()778900s2.204s00
    select * from getallassignednumanodeinfomation()345090s2.057s00
    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))360070s2.052s00
    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 result160030s2.036s160030
    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 result345090s1.855s345090
    select * from getnumanodecpubyvdsid($1)345090s1.805s00
    select * from getnumanodecpubyvmid($1)345090s1.760s00
    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_id1100190s1.713s1100190
    select * from getvdsdynamicbyvdsid($1)164040s1.654s164040
    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))161360s1.416s00
    select * from getvmjobsbyvmid($1)345090s1.265s00
    select * from getnumanodebyvdsid($1)345090s1.226s00
    select * from getnumanodebyvmid($1)345090s1.186s00
    select * from getstorage_domains_by_storagepoolid($1. $2. $3)1240.009s1.163s1240
    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 result345090s1.144s345090
    select * from getvm_poolsbyvm_pool_id($1. $2. $3)4990.002s1.124s4990
    select * from insertvmguestagentinterface($1. $2. $3. $4. $5) as result345090s1.111s345090
    select * from getvdswithoutmigratingvmsbyvdsgroupid($1)760.014s1.071s38000
    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 result345090s1.033s345090
    select * from getvdsbystoragepoolidwithstatus($1. $2)1170.008s1.027s233990
    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 result345090s0.954s345090
    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_id160030s0.952s160030
    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.043s0.870s166220
    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.042s0.855s166220
    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.782s00
    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)345090s0.699s345090
    select * from getstorage_domains_by_id_and_by_storage_pool_id($1. $2)2340.002s0.693s1170
    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))1240.005s0.637s00
    select * from getvmdevicebyvmidtypeanddevice($1. $2. $3. $4. $5)15000s0.635s5000
    select * from deletevmguestagentinterfacesbyvmid($1) as result345090s0.630s345090
    select * from gettemplatewithlatestversioninchain($1)4990.001s0.620s4990
    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 != ?786270s0.588s00
    SELECT * FROM storage_domains WHERE id = v_id and storage_pool_id = v_storage_pool_id2340.002s0.578s00
    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_guid345090s0.501s345090
    SELECT * FROM qos WHERE id = v_id1150120s0.481s00
    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.name159230s0.446s00
    SELECT array_to_string(array_agg(vds_id). ?) FROM vm_host_pinning_map WHERE vm_id = v_vm_id1770930s0.413s1770930
    SELECT numa_node_cpus_view.* FROM numa_node_cpus_view WHERE vds_id = v_vds_id345090s0.395s00
    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.394s00
    select * from getallfromvdsgroups($1. $2)5270s0.384s21080
    select * from getvmsbyids($1)760.004s0.377s00
    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))163600s0.376s00
    SELECT numa_node_cpus_view.* FROM numa_node_cpus_view WHERE vm_id = v_vm_id345090s0.370s00
    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_guid345090s0.335s345090
    select * from getallfromvds($1. $2)80.037s0.301s16160
    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_id345090s0.294s345090
    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 = ?1170.002s0.283s00
    SELECT vds_dynamic.* FROM vds_dynamic WHERE vds_id = v_vds_id164040s0.254s00
    select * from getsnapshotbyvmidandtype($1. $2. $3. $4)5000s0.253s00
    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 )2470.001s0.249s2470
    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 )2470.001s0.247s2470
    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.011s0.234s00
    select * from getusersbyvmguid($1)19960s0.225s00
    COPY (SELECT date_trunc(?. now()). current_database(). * FROM pg_stat_user_functions WHERE schemaname <> ? ORDER BY schemaname. funcname) TO STDOUT CSV DELIMITER ';';200.011s0.224s00
    select * from getallfromhostdevices()5000s0.196s955000
    select * from getupandprioritizedvds($1)110.017s0.196s22000
    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.193s00
    DELETE FROM vm_guest_agent_interfaces WHERE vm_id = v_vm_id345090s0.184s345090
    SELECT numa_node.* FROM numa_node WHERE vds_id = v_vds_id345090s0.180s00
    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.178s14420
    SELECT numa_node.* FROM numa_node WHERE vm_id = v_vm_id345090s0.160s00
    select * from checkifsnapshotexistsbyvmidandtype($1. $2)14980s0.146s14980
    SELECT vm_jobs.* FROM vm_jobs WHERE vm_jobs.vm_id = v_vm_id345090s0.145s00
    "SELECT ? FROM ONLY ""public"".""vm_static"" x WHERE ""vm_guid"" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x"345090s0.144s345090
    select * from getvmsbyvmpoolid($1)60.023s0.141s15300
    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.138s19800
    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.132s12800
    select * from public.clear_network_from_nics(CAST ($1 AS uuid)) as result14420s0.130s14420
    select * from getnetworkattachmentsbyhostid($1)2060s0.113s2060
    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))158700s0.113s00
    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.098s12800
    SELECT vm_jobs.vm_job_id FROM vm_jobs778900s0.095s00
    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.095s19800
    select * from getstorage_domain_by_type_storagepoolid_and_status($1. $2. $3)60.015s0.094s60
    select * from get_entity_snapshot_by_command_id($1)7010s0.086s00
    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.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)345090s0.082s00
    select * from getsupportedclusterfeaturesbyclusterid($1)2000s0.081s00
    select * from getvmsdynamicrunningonvds($1)2060s0.078s5000
    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.078s47000
    select * from getsnapshotidsbyvmidandtype($1. $2)4990s0.077s00
    SELECT vms.* FROM vms WHERE vm_pool_id = v_vm_pool_id60.012s0.077s00
    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()110.006s0.075s00
    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
    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.073s47000
    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.067s57600
    select * from getmanagementnetworkbycluster($1)2060s0.065s2060
    select * from getallfromvms($1. $2)10.063s0.064s522143
    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.063s33480
    select * from getvdsstaticbyvdsid($1)2340s0.061s2340
    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.061s00
    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.058s57600
    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.056s33480
    select * from delete_entity_snapshot_by_command_id($1) as result5050s0.053s5050
    select * from existsvmdevicebyvmidandtype($1. $2)5000s0.051s5000
    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.050s3200
    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.050s14420
    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
    SELECT numa_node_assignment_view.* FROM numa_node_assignment_view345090s0.048s00
    select * from getnetworkattachmentbynicidandnetworkid($1. $2)2060s0.048s2060
    COPY (SELECT date_trunc(?. now()). current_database(). * FROM pg_statio_user_indexes WHERE schemaname <> ? ORDER BY schemaname. relname) TO STDOUT CSV DELIMITER ';';200.002s0.047s57600
    COPY (SELECT date_trunc(?. now()). current_database(). * FROM pg_stat_user_indexes WHERE schemaname <> ? ORDER BY schemaname. relname) TO STDOUT CSV DELIMITER ';';200.002s0.045s57600
    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.045s3200
    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))80.005s0.042s00
    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.041s33480
    COPY (SELECT date_trunc(?. now()). * FROM pg_stat_xact_user_tables WHERE schemaname <> ? ORDER BY 3. 4) TO STDOUT CSV DELIMITER ';';200.002s0.040s33480
    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 result1980s0.040s1980
    select * from getvmsmigratingtovds($1)10.037s0.037s00
    UPDATE vds_interface SET network_name = ? WHERE id = v_id14420s0.037s14420
    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.035s00
    select * from getsupportedhostfeaturesbyhostid($1)2060s0.035s00
    select * from getallaffinitygroupsbyclusterid($1)760s0.035s00
    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 result260.001s0.034s260
    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.025s3400
    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.024s00
    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.023s00
    select * from getstorageconnectionsbystoragetypeandstatus($1. $2. $3)60.003s0.021s00
    select * from getallfromvm_pools()30.006s0.020s60
    SELECT DISTINCT vms.* FROM vms ORDER BY vm_guid10.019s0.020s072
    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 1960s0.019s1960
    BEGIN335770s0.018s00
    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.018s00
    select * from getvdsgroupswithoutmigratingvms()190s0.017s760
    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 1960s0.017s1960
    SELECT * FROM host_device5000s0.017s00
    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))5270s0.016s00
    COPY (SELECT date_trunc(?. now()). current_database(). * FROM pg_statio_user_sequences WHERE schemaname <> ? ORDER BY schemaname. relname) TO STDOUT CSV DELIMITER ';';200s0.014s3400
    select * from clear_osinfo() as result10.012s0.013s10
    COMMIT335770s0.013s00
    TRUNCATE dwh_osinfo10.012s0.013s00
    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_id1980s0.013s1980
    COPY (SELECT date_trunc(?. now()). * FROM pg_stat_xact_user_functions WHERE schemaname <> ? ORDER BY 3. 4) TO STDOUT CSV DELIMITER ';';200s0.012s00
    SELECT vds_static.* FROM vds_static WHERE vds_id = v_vds_id2340s0.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
    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.011s600
    SELECT EXISTS( SELECT * FROM snapshots WHERE vm_id = v_vm_id AND snapshot_type = v_snapshot_type)14980s0.010s00
    select * from getfailingvdss()40.002s0.010s00
    select * from getvmiconbyvmicondataurl($1)800s0.009s800
    select * from getaction_version_mapbyaction_type($1)220s0.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.008s410
    SELECT snapshot_id FROM snapshots WHERE vm_id = v_vm_id AND snapshot_type = v_snapshot_type ORDER BY creation_date ASC4990s0.007s00
    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 business_entity_snapshot.* FROM business_entity_snapshot WHERE command_id = v_command_id order by insertion_order desc7010s0.007s00
    select * from updatedwhhistorytimekeeping($1. $2. $3) as result400s0.007s400
    select * from getvmstaticwithfailbackbyvdsid($1)60.001s0.007s00
    SELECT a.attname.a.atttypid FROM pg_catalog.pg_attribute a WHERE a.attrelid = ? AND a.attnum > ? ORDER BY a.attnum 1280s0.007s49870
    select * from getfailedautostartvms()10.007s0.007s00
    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)190s0.007s190
    SELECT vm.* FROM vms vm WHERE vm.vm_guid IN (SELECT * from fnSplitterUuid(v_vms_ids))760s0.006s00
    SELECT EXISTS( SELECT ? FROM vm_device WHERE vm_id = v_vm_id AND type = v_type)5000s0.005s5000
    select * from insertvmicondefault($1. $2. $3. $4) as result400s0.005s400
    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.005s00
    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.005s410
    select * from getstorage_pool_iso_mapsbybystorage_pool_id($1. $2)120s0.004s120
    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 320s0.004s320
    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.004s200
    select * from getallmacsbymacpoolid($1)20.001s0.004s5280
    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
    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.003s400
    select * from removefinishedkdumpstatusforvds($1) as result60s0.003s60
    select * from getfailingstorage_domains()40s0.003s00
    SELECT * FROM vm_icons WHERE data_url = v_data_url800s0.003s00
    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_id30s0.003s30
    CREATE TEMPORARY TABLE tt_VM_POOL_GROUP ( vm_pool_id UUID. assigned_vm_count INTEGER ) WITH OIDS30s0.003s00
    select * from getvmtemplateswithouticon()10.002s0.003s00
    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
    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.003s410
    SELECT vm_dynamic.* FROM vm_dynamic WHERE RUN_ON_VDS = v_vds_id2060s0.003s00
    select * from updatecpuflags($1. $2) as result60s0.002s60
    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.002s410
    SELECT na.* FROM network_attachments na WHERE na.network_id = v_network_id and na.nic_id = v_nic_id2060s0.002s00
    select * from deleterunningjobsoftasklesscommands() as result10.002s0.002s10
    delete from business_entity_snapshot where command_id = v_command_id5050s0.002s00
    SELECT * FROM supported_cluster_features_view WHERE cluster_id = v_cluster_id2000s0.002s00
    select * from updatevdsdynamicpowermanagementpolicyflag($1. $2) as result60s0.002s60
    select * from updatestorage_pool($1. $2. $3. $4. $5. $6. $7. $8. $9. $10. $11. $12) as result60s0.002s60
    select * from updatestorage_pool_status($1. $2) as result60s0.002s60
    select * from getrepo_files_in_all_storage_pools($1. $2. $3. $4)10.001s0.002s00
    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 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 getvds_spm_id_mapbystorage_pool_idandbyvds_spm_id($1. $2)50s0.001s00
    select * from public.insert_osinfo(CAST ($1 AS int4).CAST ($2 AS varchar)) as result400s0.001s400
    select * from getjobbyjobid($1)30s0.001s30
    SELECT typinput=?::regproc. typtype FROM pg_catalog.pg_type WHERE typname = $11160s0.001s1070
    select * from getallfromstorage_pool($1. $2)20s0.001s20
    select * from getvmstaticwithouticon()10.001s0.001s00
    select * from deletecompletedjobsolderthandate($1. $2) as result10.001s0.001s10
    CREATE TEMPORARY TABLE tt_VM_POOL_RUNNING ( vm_pool_id UUID. vm_running_count INTEGER ) WITH OIDS30s0.001s00
    select audit_log_id from audit_log where vds_name = v_vds_name and log_type = v_log_type70s0.001s70
    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 * from updatejoblastupdatetime($1. $2) as result30s0.001s30
    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
    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 insertstep($1. $2. $3. $4. $5. $6. $7. $8. $9. $10. $11. $12. $13) as result20s0.001s20
    CREATE TEMPORARY TABLE tt_VM_POOL_PRERESULT ( vm_pool_id UUID. assigned_vm_count INTEGER. vm_running_count INTEGER ) WITH OIDS30s0.001s00
    select * from getglustervolumebricksbyserverguid($1)10s0.001s00
    SET extra_float_digits = 31020s0.001s00
    UPDATE dwh_history_timekeeping SET var_value = v_var_value. var_datetime = v_var_datetime WHERE var_name = v_var_name400s0.001s400
    select * from getallmacpoolrangesbymacpoolid($1)20s0.001s20
    SELECT typname FROM pg_catalog.pg_type WHERE oid = $11070s0.001s1070
    SELECT e.typdelim FROM pg_catalog.pg_type t. pg_catalog.pg_type e WHERE t.oid = $1 and t.typelem = e.oid830s0.001s830
    select * from get_all_commands()10s0.001s00
    select * from deleteallunusedvmicons() 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 getallfromvdcoption()10s0.001s8220
    select * from getallfromclusterpolicys()10s0.001s50
    select * from updatejobstepscompleted($1. $2. $3) as result10s0.001s10
    SELECT * FROM supported_host_features WHERE host_id = v_host_id2060s0.001s00
    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 (?. ?. ?))))10s0.001s10
    select * from checkifjobhastasks($1)10s0.001s10
    UPDATE vds_dynamic SET cpu_flags = v_cpu_flags WHERE vds_id = v_vds_id60s0.001s60
    select * from updatestartedexecutionentitiestounknown($1) as result10s0.001s10
    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_id60s0.001s60
    select * from cleandownvms() as result10s0.001s10
    "SELECT ? FROM ONLY ""public"".""vm_icons"" x WHERE ""id"" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x"800s0.001s800
    select * from checkdbconnection() as result10s0.001s10
    select * from updatejob($1. $2. $3. $4. $5. $6. $7. $8. $9. $10. $11. $12) as result10s0.001s10
    UPDATE storage_pool SET status = v_status. _update_date = LOCALTIMESTAMP WHERE id = v_id60s0.001s60
    select * from gettrustedvdsgroups()10s0.000s00
    select * from insertjobsubjectentity($1. $2. $3) as result10s0.000s10
    select * from getidsofhostswithstatus($1)10s0.000s1940
    select * from insertjob($1. $2. $3. $4. $5. $6. $7. $8. $9. $10. $11. $12) as result10s0.000s10
    select * from getalljobidsbyentityid($1)10s0.000s30
    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.000s20
    UPDATE vds_dynamic SET controlled_by_pm_policy = v_controlled_by_pm_policy WHERE vds_id = v_vds_id60s0.000s60
    select * from getallfrompolicyunits()30s0.000s630
    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 DESC450s0.000s00
    SELECT vm_static.* FROM vm_static WHERE entity_type = ? AND (small_icon_id IS NULL OR large_icon_id IS NULL)10s0.000s00
    SELECT * FROM affinity_groups_view WHERE cluster_id = v_cluster_id760s0.000s00
    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
    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 != ?120s0.000s00
    select * from getallfromcommandentities()10s0.000s00
    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
    select * from getallfromclusterpolicyunits()10s0.000s640
    select * from updatestep($1. $2. $3. $4. $5. $6. $7. $8. $9. $10. $11. $12) as result10s0.000s10
    select * from getquotacount()20s0.000s20
    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 getallfromglusterservices()10s0.000s70
    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_id50s0.000s00
    INSERT into dwh_osinfo (os_id. os_name) VALUES (v_os_id. v_os_name)400s0.000s400
    select * from gettagsbyparent_id($1)10s0.000s00
    select * from deleteallfromvmicondefaults() as result10s0.000s10
    SELECT vds_id FROM vds_dynamic WHERE status = v_status10s0.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
    UPDATE dwh_history_timekeeping SET var_datetime = now() where var_name = ?400s0.000s400
    SELECT DISTINCT vms.* FROM vms WHERE migrating_to_vds = v_vds_id10s0.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 getallfrommacpools()10s0.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
    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
    update job SET last_update_time = v_last_update_time WHERE job_id = v_job_id30s0.000s30
    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 * from getallfromasync_tasks()10s0.000s00
    SELECT nspname FROM pg_namespace WHERE nspname !~ ? AND nspname <> ? ORDER BY 110s0.000s20
    SELECT vms.* FROM vms WHERE auto_startup = ? and status = ? and exit_status = ?10s0.000s00
    select * from deleteallfromenginesessions() as result10s0.000s10
    SELECT * FROM action_version_map WHERE action_type = v_action_type220s0.000s00
    SET application_name TO pgcluu;200s0.000s00
    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 COUNT(TRIGGER_NAME) FROM QRTZ_TRIGGERS WHERE SCHED_NAME = ? AND NOT (MISFIRE_INSTR = ?) AND NEXT_FIRE_TIME < $1 AND TRIGGER_STATE = $2200s0.000s200
    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 count(tgname) FROM pg_trigger WHERE NOT tgisinternal;10s0.000s10
    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
    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
    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 vds WHERE recoverable AND status = ?40s0.000s00
    SELECT job.* FROM JOB WHERE job_id = v_job_id30s0.000s00
    SELECT job_subject_entity.job_id FROM job_subject_entity WHERE entity_id = v_entity_id10s0.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
    "DELETE FROM ONLY ""public"".""step"" WHERE $1 OPERATOR(pg_catalog.=) ""job_id"""10s0.000s20
    DELETE FROM vm_icon_defaults10s0.000s400
    SELECT * FROM storage_domains WHERE recoverable AND status = ?40s0.000s00
    "SELECT ? FROM ONLY ""public"".""job"" x WHERE ""job_id"" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x"30s0.000s30
    SELECT * FROM QRTZ_LOCKS WHERE SCHED_NAME = ? AND LOCK_NAME = $1 FOR UPDATE10s0.000s10
    SELECT * FROM cluster_policy_units10s0.000s00
    "DELETE FROM ONLY ""public"".""job_subject_entity"" WHERE $1 OPERATOR(pg_catalog.=) ""job_id"""10s0.000s10
    SELECT * FROM cluster_policies10s0.000s00
    SELECT * FROM policy_units30s0.000s00
    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 EXISTS( SELECT * FROM step WHERE job_id = v_job_id AND external_id is not null AND external_system_type in (?.?))10s0.000s00
    DELETE FROM vds_kdump_status WHERE vds_id = v_vds_id AND status = ?60s0.000s00
    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 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
    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))20s0.000s00
    SELECT * from command_entities10s0.000s00
    SELECT extname||?||extversion FROM pg_extension;10s0.000s10
    select * from tt_VM_POOL_RESULT30s0.000s00
    DELETE FROM engine_sessions10s0.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
    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 async_tasks10s0.000s00
    SELECT vds_groups_view.* FROM vds_groups_view WHERE trusted_service10s0.000s00
    SELECT distinct business_entity_snapshot.command_id. business_entity_snapshot.command_type FROM business_entity_snapshot10s0.000s00
    SELECT * FROM gluster_services10s0.000s00
    SELECT * FROM mac_pools10s0.000s00
    UPDATE QRTZ_TRIGGERS SET TRIGGER_STATE = $1 WHERE SCHED_NAME = ? AND (TRIGGER_STATE = $2 OR TRIGGER_STATE = $3)20s0.000s00
    SELECT TRIGGER_NAME. TRIGGER_GROUP FROM QRTZ_TRIGGERS WHERE SCHED_NAME = ? AND TRIGGER_STATE = $110s0.000s00
    SELECT * FROM QRTZ_FIRED_TRIGGERS WHERE SCHED_NAME = ? AND INSTANCE_NAME = $1 AND REQUESTS_RECOVERY = $210s0.000s00
    DELETE FROM QRTZ_FIRED_TRIGGERS WHERE SCHED_NAME = ?10s0.000s00
    SELECT tags.* FROM tags WHERE parent_id = v_parent_id10s0.000s00

© Gilles Darold 2012-2015

Report generated by pgCluu 2.4.