Skip to content

Instantly share code, notes, and snippets.

@xrg
Created November 11, 2012 22:07
Show Gist options
  • Select an option

  • Save xrg/4056432 to your computer and use it in GitHub Desktop.

Select an option

Save xrg/4056432 to your computer and use it in GitHub Desktop.
SQL stats from F3 (or pg84-next) server, w. BQI
BQI> server get sqlstats -t
execute: 'get_sql_stats' ()
execute select update insert Total
---------------------------------------------------------------------
software_dev_mirrors_com : - 5.97s - - 5.97s
pg_user : - 0.354s - - 0.354s
res_request : - 0.318s - - 0.318s
ir_translation : - 0.208s - - 0.208s
res_users : - 38.6ms 0.105s - 0.143s
ir_ui_view : - 0.129s - - 0.129s
ir_attachment : - 0.110s - - 0.110s
ir_actions : - 0.106s - - 0.106s
ir_trans_get_mids : 97.7ms - - - 97.7ms
nan_koo_view_settings : - 32.6ms - 57.9ms 90.5ms
hr_department : - 88.8ms - - 88.8ms
ir_trans_get_src1 : 58.1ms - - - 58.1ms
ir_ui_menu : - 56.6ms - - 56.6ms
ir_values : - 45.3ms - - 45.3ms
hr_employee : - 38.0ms - - 38.0ms
software_dev_commit : - 35.1ms - - 35.1ms
ir_trans_get_msrc : 30.4ms - - - 30.4ms
ir_ui_view_sc : - 28.5ms - - 28.5ms
ir_model : - 25.8ms - - 25.8ms
ima_check_groups2 : 25.5ms - - - 25.5ms
software_dev_vcs_user : - 17.7ms - - 17.7ms
hr_job : - 17.5ms - - 17.5ms
software_dev_mirrors_bra : - 16.6ms - - 16.6ms
ir_act_window_view : - 16.4ms - - 16.4ms
ir_act_window_group_rel : - 15.6ms - - 15.6ms
ir_act_window : - 14.8ms - - 14.8ms
ir_cron : - 9.59ms 4.20ms - 13.8ms
res_company : - 12.7ms - - 12.7ms
nan_koo_cache_exception : - 12.6ms - - 12.6ms
resource_resource : - 9.41ms - - 9.41ms
ir_filters : - 5.43ms - - 5.43ms
res_partner_address : - 5.24ms - - 5.24ms
res_groups_users_rel : - 4.00ms - - 4.00ms
software_dev_branch : - 2.19ms - - 2.19ms
--------------------------------------------------------------------
Total : 0.212s 7.74s 0.109s 57.9ms 8.12s
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment