Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 16.06.2021 16:28
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. Performance, DETAILS per units
  4. Memory consumption, metadata cache, attachments activity    as table    as chart
  5. Monitoring data: STATEMENTS activity, as chart
  6. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database statistics was not gathered. Change config parameter 'run_db_statistics' to 1.
  3. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  4. New in firebird.log while test was run
  5. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 58e1ddde69c44dad93d327777e5becec
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-05-09 08:45
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4793.92
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17216844 kB
MemAvailable 31369408 kB
Buffers 0 kB
Cached 14427448 kB
SwapCached 2976 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 3.0.8
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-06-16 16:27:41
DTS_END                         2021-06-16 16:27:41.2820
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/47490
TRN_ID                          234120
ATT_ID                          696
EXC_UNIT                        2


Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 50

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 120 minutes: 9212.20 27058 1105464
customer order: creation 168.03 332 20163
customer order: refuse 14.72 354 1766
order to supplier: creation 44.67 1335 5360
order to supplier: removal 3.33 118122 400
invoice (draft): creation 44.87 3215 5384
invoice (draft): removal 53.08 931 6370
invoice accept: apply 40.81 18321 4897
invoice accept: cancel 48.41 870 5809
customer reserve: creation 3754.83 182 450579
customer reserve: removal 4741.87 65 569024
realization accept: apply 81.90 175 9828
realization accept: cancel 91.02 106 10922
payment from customer: creation 56.68 105 6802
payment from customer: removal 5.72 64 686
payment to supplier: creation 47.22 122 5666
payment to supplier: removal 3.51 72 421
service: total inventory turnovers 4.47 1112 536
service: total monetary turnovers 6.38 21 766
service: aggregate perf. data 0.68 25506 81
service: refresh index statistics 0.03 370154 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 16-06-2021 16:28:36 to 16-06-2021 16:28:39.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2927
TEST_TIME 2 4774
TEST_TIME 3 4080
TEST_TIME 4 5424
TEST_TIME 5 5438
TEST_TIME 6 5426
TEST_TIME 7 5435
TEST_TIME 8 5910
TEST_TIME 9 6071
TEST_TIME 10 5975
TEST_TIME 11 6029
TEST_TIME 12 6271
TEST_TIME 13 6452
TEST_TIME 14 6648
TEST_TIME 15 6631
TEST_TIME 16 7355
TEST_TIME 17 7267
TEST_TIME 18 7242
TEST_TIME 19 7739
TEST_TIME 20 7993
TEST_TIME 21 8011
TEST_TIME 22 8306
TEST_TIME 23 8571
TEST_TIME 24 8760
TEST_TIME 25 8859
TEST_TIME 26 9765
TEST_TIME 27 10591
TEST_TIME 28 11342
TEST_TIME 29 11317
TEST_TIME 30 11116
TEST_TIME 31 10942
TEST_TIME 32 10721
TEST_TIME 33 10615
TEST_TIME 34 10455
TEST_TIME 35 10337
TEST_TIME 36 10223
TEST_TIME 37 10052
TEST_TIME 38 9879
TEST_TIME 39 9783
TEST_TIME 40 9759
TEST_TIME 41 9631
TEST_TIME 42 9646
TEST_TIME 43 9636
TEST_TIME 44 9695
TEST_TIME 45 9627
TEST_TIME 46 9593
TEST_TIME 47 9522
TEST_TIME 48 9549
TEST_TIME 49 9610
TEST_TIME 50 9552
TEST_TIME 51 9586
TEST_TIME 52 9602
TEST_TIME 53 9542
TEST_TIME 54 9596
TEST_TIME 55 9692
TEST_TIME 56 9696
TEST_TIME 57 9559
TEST_TIME 58 9488
TEST_TIME 59 9363
TEST_TIME 60 9282
TEST_TIME 61 9301
TEST_TIME 62 9319
TEST_TIME 63 9255
TEST_TIME 64 9201
TEST_TIME 65 9162
TEST_TIME 66 9199
TEST_TIME 67 9141
TEST_TIME 68 9279
TEST_TIME 69 9224
TEST_TIME 70 9253
TEST_TIME 71 9305
TEST_TIME 72 9284
TEST_TIME 73 9319
TEST_TIME 74 9292
TEST_TIME 75 9326
TEST_TIME 76 9277
TEST_TIME 77 9359
TEST_TIME 78 9477
TEST_TIME 79 9520
TEST_TIME 80 9468
TEST_TIME 81 9372
TEST_TIME 82 9410
TEST_TIME 83 9352
TEST_TIME 84 9317
TEST_TIME 85 9289
TEST_TIME 86 9227
TEST_TIME 87 9151
TEST_TIME 88 9078
TEST_TIME 89 9242
TEST_TIME 90 9242
TEST_TIME 91 9252
TEST_TIME 92 9279
TEST_TIME 93 9274
TEST_TIME 94 9351
TEST_TIME 95 9396
TEST_TIME 96 9392
TEST_TIME 97 9349
TEST_TIME 98 9375
TEST_TIME 99 9365
TEST_TIME 100 9389
TEST_TIME 101 9393
TEST_TIME 102 9550
TEST_TIME 103 9524
TEST_TIME 104 9470
TEST_TIME 105 9424
TEST_TIME 106 9378
TEST_TIME 107 9328
TEST_TIME 108 9362
TEST_TIME 109 9338
TEST_TIME 110 9308
TEST_TIME 111 9278
TEST_TIME 112 9246
TEST_TIME 113 9237
TEST_TIME 114 9256
TEST_TIME 115 9257
TEST_TIME 116 9236
TEST_TIME 117 9240
TEST_TIME 118 9254
TEST_TIME 119 9264
TEST_TIME 120 9223

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 16-06-2021 16:28:40 to 16-06-2021 16:28:43.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1523342 1523342 0 0.00 0 22755 6 0 0
doc_list_biud 1523342 1523342 0 0.00 0 61860 31 0 0
sp_add_invoice_to_stock 5008 4897 111 2.21 35 185745 18321 0 111
sp_cancel_adding_invoice 5809 5809 0 0.00 4 80899 870 0 0
sp_cancel_client_order 1766 1766 0 0.00 4 13057 354 0 0
sp_cancel_customer_reserve 569024 569024 0 0.00 1 23163 65 0 0
sp_cancel_pay_from_customer 686 686 0 0.00 2 3490 65 0 0
sp_cancel_pay_to_supplier 421 421 0 0.00 2 4309 72 0 0
sp_cancel_supplier_invoice 6373 6370 3 0.04 2 61867 932 0 3
sp_cancel_supplier_order 400 400 0 0.00 6 1123212 118122 0 0
sp_cancel_write_off 10922 10922 0 0.00 1 8990 106 0 0
sp_client_order 20163 20163 0 0.00 4 21382 333 0 0
sp_customer_reserve 450579 450579 0 0.00 0 42766 183 0 0
sp_fill_shopping_cart 30907 30907 0 0.00 1 12762 39 0 0
sp_fill_shopping_cart_clo_res 450572 450572 0 0.00 0 13904 12 0 0
sp_get_clo_for_invoice 4886 4886 0 0.00 0 24363 275 0 0
sp_kill_cost_storno 17838 17838 0 0.00 0 8698 56 0 0
sp_kill_qstorno_ret_qs2qd 1155740 1155740 0 0.00 0 61856 36 0 0
sp_kill_qty_storno 609005 609005 0 0.00 0 61858 76 0 0
sp_lock_selected_doc 20465 20465 0 0.00 0 6351 3 0 0
sp_make_cost_storno 27182 27182 0 0.00 0 12193 49 0 0
sp_multiply_rows_for_pdistr 27182 27182 0 0.00 0 5501 26 0 0
sp_multiply_rows_for_qdistr 20163 20163 0 0.00 0 10884 145 0 0
sp_pay_from_customer 6802 6802 0 0.00 4 10352 106 0 0
sp_pay_to_supplier 5666 5666 0 0.00 4 24907 123 0 0
sp_payment_common 12468 12468 0 0.00 1 24886 29 0 0
sp_qd_handle_on_cancel_clo 1766 1766 0 0.00 0 9209 323 0 0
sp_qd_handle_on_invoice_upd_sts 10695 10695 0 0.00 0 19365 337 0 0
sp_qd_handle_on_reserve_upd_sts 9828 9828 0 0.00 0 16686 59 0 0
sp_reserve_write_off 9828 9828 0 0.00 6 24021 176 0 0
sp_supplier_invoice 5384 5384 0 0.00 6 85282 3216 0 0
sp_supplier_order 5360 5360 0 0.00 5 33908 1335 0 0
srv_aggregate_perf_data 82 81 1 1.21 2870 350079 25506 0 1
srv_fill_mon_cache_memory 167 167 0 0.00 1223 131253 31079 0 0
srv_find_qd_qs_mism 1059388 1059388 0 0.00 0 22704 6 0 0
srv_make_invnt_saldo 536 536 0 0.00 41 57704 1113 0 0
srv_make_money_saldo 766 766 0 0.00 1 266 22 0 0
srv_recalc_idx_stat 4 4 0 0.00 137026 599243 370154 0 0
t$perf-abend:sp_add_invoice_to_stock 111 111 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 3 3 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4899 4899 0 0.00 0 10862 208 0 0
t$perf-norm:sp_cancel_adding_invoice 435 435 0 0.00 1 7822 97 0 0
t$perf-norm:sp_cancel_client_order 1766 1766 0 0.00 0 6948 16 0 0
t$perf-norm:sp_cancel_customer_reserve 640 640 0 0.00 0 2252 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 686 686 0 0.00 0 675 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 421 421 0 0.00 0 9018 32 0 0
t$perf-norm:sp_cancel_supplier_invoice 422 422 0 0.00 0 5494 36 0 0
t$perf-norm:sp_cancel_supplier_order 400 400 0 0.00 0 22916 1764 0 0
t$perf-norm:sp_cancel_write_off 981 981 0 0.00 0 1188 5 0 0
t$perf-norm:sp_client_order 20163 20163 0 0.00 0 18597 20 0 0
t$perf-norm:sp_customer_reserve 1018 1018 0 0.00 0 4628 13 0 0
t$perf-norm:sp_pay_from_customer 6802 6802 0 0.00 0 5071 12 0 0
t$perf-norm:sp_pay_to_supplier 5666 5666 0 0.00 0 11690 13 0 0
t$perf-norm:sp_reserve_write_off 9828 9828 0 0.00 0 8936 12 0 0
t$perf-norm:sp_supplier_invoice 5384 5384 0 0.00 0 6086 22 0 0
t$perf-norm:sp_supplier_order 5360 5360 0 0.00 0 1821 13 0 0
t$perf-norm:srv_aggregate_perf_data 81 81 0 0.00 0 395 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 167 167 0 0.00 0 409 3 0 0
t$perf-norm:srv_make_invnt_saldo 536 536 0 0.00 0 3083 24 0 0
t$perf-norm:srv_make_money_saldo 766 766 0 0.00 0 1067 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 10 5 0 0
v_add_invoice_to_stock 9994 9772 222 2.22 0 16019 24 0 222
v_all_customers 36428 36428 0 0.00 0 118 1 0 0
v_all_suppliers 29562 29562 0 0.00 0 25 1 0 0
v_all_wares 40326 40326 0 0.00 0 50 1 0 0
v_cancel_adding_invoice 870 870 0 0.00 0 8103 16 0 0
v_cancel_client_order 3532 3532 0 0.00 0 12811 10 0 0
v_cancel_customer_prepayment 1372 1372 0 0.00 0 2316 6 0 0
v_cancel_customer_reserve 1280 1280 0 0.00 0 10806 13 0 0
v_cancel_payment_to_supplier 842 842 0 0.00 0 4280 14 0 0
v_cancel_supplier_invoice 850 844 6 0.70 0 906 16 0 6
v_cancel_supplier_order 800 800 0 0.00 0 524 4 0 0
v_cancel_write_off 1962 1962 0 0.00 0 4160 16 0 0
v_max_id_clo_ord 5360 5360 0 0.00 0 1984 2 0 0
v_max_id_clo_res 1018 1018 0 0.00 0 3286 21 0 0
v_max_id_ord_sup 5384 5384 0 0.00 0 3703 4 0 0
v_max_non_paid_invoice 1629 1629 0 0.00 0 500 3 0 0
v_max_non_paid_realizn 3681 3681 0 0.00 0 1876 3 0 0
v_min_id_clo_ord 5360 5360 0 0.00 0 2656 5 0 0
v_min_id_clo_res 1018 1018 0 0.00 0 6577 30 0 0
v_min_id_ord_sup 5384 5384 0 0.00 0 4474 5 0 0
v_min_non_paid_invoice 5666 5666 0 0.00 0 5477 17 0 0
v_min_non_paid_realizn 6801 6801 0 0.00 0 8132 13 0 0
v_our_firm 10140 10140 0 0.00 0 16 1 0 0
v_reserve_write_off 19656 19656 0 0.00 0 15139 10 0 0
x_lock_depdocs_on_canc_invoice 11757 11757 0 0.00 0 17285 136 0 0
x_lock_depdocs_on_canc_sup_ord 400 400 0 0.00 0 7167 327 0 0
x_make_qstorno_1000_1200 5360 5360 0 0.00 1 33902 1258 0 0
x_make_qstorno_1200_2000 5384 5384 0 0.00 3 80549 3072 0 0
x_make_qstorno_2100_3300 450579 450579 0 0.00 0 42764 168 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 16-06-2021 16:28:44 to 16-06-2021 16:28:48.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
13:57:45 2 8192000000 8798422640 8808923136 5084736 0.062 1 1 2 0 5202784 55488 62560
13:57:51 13862 8192000000 10212077088 10515091456 818967664 9.088 66 54 110 0 840080576 2387072 18725840
13:58:13 18498 8192000000 10320839792 10635743232 1365234432 14.284 100 82 164 0 1396199376 4544928 26420016
13:58:41 17100 8192000000 10371640448 10693173248 1431578032 14.875 100 88 175 1 1465865824 5943904 28343888
13:59:07 21892 8192000000 10397357728 10719797248 1449571056 15.034 100 92 184 0 1486955232 7171872 30212304
13:59:40 23550 8192000000 10419397728 10745602048 1469022064 15.205 100 93 186 0 1506790176 7765344 30002768
14:00:14 18947 8192000000 10427371088 10758410240 1479309344 15.295 100 87 174 0 1515888336 8194672 28384320
14:00:48 25942 8192000000 10441707408 10776215552 1496561344 15.446 100 89 178 1 1533753056 8376912 28814800
14:01:21 17446 8192000000 10461631360 10798448640 1514929552 15.606 100 86 172 0 1551343184 9004688 27408944
14:01:50 16152 8192000000 10472914992 10816589824 1532273200 15.757 100 82 164 2 1566958448 8889632 25795616
14:02:15 13164 8192000000 10496812256 10846138368 1563626736 16.027 100 76 152 0 1596806688 9200096 23979856
14:02:41 16448 8192000000 10526384576 10881605632 1584879856 16.210 100 75 150 0 1616808768 9390208 22538704
14:03:06 13853 8192000000 10552348640 10909200384 1613671200 16.456 100 73 145 0 1645613232 10273760 21668272
14:03:29 10114 8192000000 10582617824 10939142144 1637404704 16.658 100 79 158 1 1671678192 10726944 23546544
14:03:49 17528 8192000000 10616556960 10982326272 1665356672 16.894 100 76 153 0 1698999536 11419280 22223584
14:04:14 7572 8192000000 10627827904 10999320576 1690860688 17.109 100 78 156 1 1725791168 12159584 22770896
14:04:29 12381 8192000000 10643207312 11015954432 1707273600 17.246 100 79 159 2 1742602096 11901520 23426976
14:04:48 5837 8192000000 10660415824 11033358336 1721307280 17.363 100 76 153 1 1756206240 12513344 22385616
14:05:01 7515 8192000000 10668321968 11046256640 1738977008 17.510 100 80 160 1 1775171536 12717056 23477472
14:05:18 6674 8192000000 10696044688 11072479232 1757614016 17.665 100 80 156 2 1792418992 13145584 21659392
14:05:32 4066 8192000000 10705507296 11083112448 1761399088 17.696 100 78 156 1 1796942496 12946736 22596672
14:05:43 5449 8192000000 10709514288 11084599296 1768081888 17.751 100 78 155 3 1803986816 14625568 21279360
14:05:55 3830 8192000000 10710432192 11086348288 1775219472 17.810 100 87 172 0 1813543712 14479280 23844960
14:06:05 4813 8192000000 10720465984 11096760320 1777816256 17.831 100 84 168 1 1814980096 14277376 22886464
14:06:17 3229 8192000000 10723648592 11102642176 1783310704 17.877 100 83 166 0 1820885776 14236896 23338176
14:06:27 3822 8192000000 10721465520 11102187520 1784279504 17.885 100 78 156 1 1819489392 13352416 21857472
14:06:38 7480 8192000000 10726585152 11104534528 1791556480 17.945 100 74 148 2 1824564608 12168832 20839296
14:06:53 5320 8192000000 10734608192 11113639936 1794434272 17.968 100 71 141 0 1825844896 11831376 19579248
14:07:05 2443 8192000000 10750246928 11134046208 1814815456 18.135 100 89 178 1 1856094000 16392336 24886208
14:07:14 2232 8192000000 10760172336 11144892416 1820473520 18.182 100 81 162 3 1855285968 11820320 22992128
14:07:22 3246 8192000000 10763262688 11154563072 1825280496 18.221 100 80 159 1 1861311808 12828112 23203200
14:07:33 2792 8192000000 10781791600 11163029504 1834045488 18.292 100 92 184 0 1874558640 14723808 25789344
14:07:42 2814 8192000000 10781429568 11165716480 1834848176 18.299 100 92 186 0 1875956640 15604112 25504352
14:07:51 2438 8192000000 10786364064 11170799616 1845393072 18.385 100 89 180 0 1884705200 14806032 24506096
14:08:00 1600 8192000000 10785977632 11174735872 1843398656 18.368 100 86 172 0 1882453376 14546384 24508336
14:08:08 2610 8192000000 10791290032 11177111552 1852055952 18.439 100 89 179 0 1890271312 13285680 24929680
14:08:17 1598 8192000000 10799424912 11183878144 1853821520 18.453 100 91 182 0 1891956080 13165008 24969552
14:08:25 2097 8192000000 10805632256 11188998144 1858170512 18.488 100 97 195 3 1899380176 13383904 27825760
14:08:34 1738 8192000000 10805489488 11191263232 1857817856 18.486 100 95 190 2 1899095088 13676672 27600560
14:08:41 6627 8192000000 10776798208 11187404800 1854720672 18.460 100 65 130 1 1885816816 12798400 18297744
14:08:56 18631 8192000000 10789857440 11185885184 1858909680 18.494 100 69 140 1 1888095136 9674880 19510576
14:09:21 4373 8192000000 10777341712 11191205888 1855004496 18.463 100 50 95 5 1877517856 9759984 12753376
14:09:32 3419 8192000000 10782482320 11197239296 1862005408 18.520 100 50 100 1 1886720416 10293216 14421792
14:09:43 4253 8192000000 10788384480 11198832640 1869945808 18.584 100 57 114 0 1896246576 10122752 16178016
14:09:55 4047 8192000000 10794467920 11201077248 1866788384 18.558 100 44 89 1 1887916752 8416400 12711968
14:10:12 6765 8192000000 10791109088 11203215360 1868833504 18.575 100 39 79 1 1887761952 7843504 11084944
14:10:29 5332 8192000000 10781583392 11206168576 1871297088 18.595 100 29 58 1 1886670592 7385376 7988128
14:10:47 4139 8192000000 10784173024 11208658944 1877152416 18.642 100 31 62 2 1892743712 7030448 8560848
14:10:59 5303 8192000000 10785759008 11213312000 1876257008 18.635 100 23 46 0 1889721936 7084848 6380080
14:11:14 5815 8192000000 10781041024 11212595200 1880875520 18.672 100 20 40 2 1892575120 6184128 5515472
14:11:26 14150 8192000000 10783198320 11214114816 1880236064 18.667 100 15 30 0 1890813408 6288368 4288976
14:11:47 12162 8192000000 10789300496 11219922944 1880580224 18.670 100 14 28 0 1889784240 5537072 3666944
14:12:07 15766 8192000000 10787168608 11223539712 1890584480 18.750 100 30 60 1 1909982160 9343024 10054656
14:12:36 50833 8192000000 10818725040 11238014976 1890805456 18.752 100 35 71 2 1905060112 4407840 9846816
14:13:33 10474 8192000000 10805252000 11235323904 1890981840 18.754 100 20 40 1 1902631872 6343456 5306576
14:13:50 4563 8192000000 10814651536 11245707264 1892468160 18.766 100 30 60 1 1912245456 11201968 8575328
14:14:06 5435 8192000000 10818871504 11248541696 1896017680 18.794 100 35 70 0 1917014432 11043424 9953328
14:14:18 7915 8192000000 10813014256 11244560384 1895716192 18.792 100 24 49 3 1909243104 6242704 7284208
14:14:34 6897 8192000000 10818645904 11250659328 1899046576 18.819 100 42 84 2 1922904848 11836096 12022176
14:14:48 10062 8192000000 10820763520 11253907456 1895980608 18.794 100 20 40 2 1911659920 10168784 5510528
14:15:04 12345 8192000000 10814125312 11248771072 1901544144 18.839 100 21 42 1 1913343824 5831552 5968128
14:15:24 9094 8192000000 10822230128 11252867072 1903116320 18.851 100 21 43 0 1915274960 6224512 5934128
14:15:40 10132 8192000000 10823137872 11255840768 1902640128 18.848 100 18 36 3 1913906288 5765184 5500976
14:16:03 6042 8192000000 10828109040 11257499648 1903756256 18.856 100 25 50 2 1916476944 5786768 6933920
14:16:15 3132 8192000000 10823050688 11255382016 1902844752 18.849 100 20 39 2 1913688704 5515360 5328592
14:16:26 10308 8192000000 10799817488 11236933632 1875290128 18.627 99 17 34 1 1886112272 6208640 4613504
14:16:42 11494 8192000000 10794247264 11228692480 1856026704 18.471 98 20 41 0 1866545568 4906768 5612096
14:17:00 64908 8192000000 10797687632 11227463680 1849726976 18.420 98 24 48 0 1866099344 9431472 6940896
14:18:11 12474 8192000000 10807871680 11232735232 1865264272 18.546 99 25 50 0 1878402608 6478832 6659504
14:18:30 6838 8192000000 10771567808 11190407168 1787589248 17.912 95 28 56 1 1802331952 7225136 7517568
14:18:46 3975 8192000000 10763722224 11187466240 1844955488 18.381 100 38 76 2 1862254192 5909376 11389328
14:18:57 5885 8192000000 10757479344 11177406464 1824429872 18.214 99 26 54 0 1837509824 5690656 7389296
14:19:12 4462 8192000000 10752446640 11174612992 1817500944 18.157 99 31 62 1 1832555184 6099072 8955168
14:19:24 8640 8192000000 10747377648 11171377152 1806772944 18.069 98 25 50 0 1820349312 6081200 7495168
14:19:40 6274 8192000000 10767627392 11192819712 1851047104 18.431 100 27 54 1 1865359712 6059552 8253056
14:19:53 7130 8192000000 10743282784 11165696000 1789685712 17.929 97 30 61 2 1804417968 5532304 9199952
14:20:07 6257 8192000000 10701299888 11124776960 1744110320 17.553 96 23 46 0 1757066608 6178480 6777808
14:20:20 4912 8192000000 10712863440 11126558720 1774487568 17.804 99 25 50 2 1788247344 6815408 6944368
14:20:31 10022 8192000000 10710724928 11127615488 1753056736 17.627 97 18 36 0 1764270656 5871648 5342272
14:20:47 13257 8192000000 10694985008 11104276480 1683589280 17.047 93 27 54 0 1696467472 5014048 7864144
14:21:10 11268 8192000000 10697379632 11106951168 1710786912 17.275 96 23 45 1 1722742000 5379488 6575600
14:21:27 72136 8192000000 10718629072 11134083072 1679464416 17.013 93 28 58 0 1692888464 4600368 8823680
14:22:54 11471 8192000000 10726350400 11142156288 1793633056 17.962 99 26 52 2 1807729792 5298080 8798656
14:23:14 4303 8192000000 10741835264 11159613440 1819128832 18.171 100 34 68 0 1836227120 6570608 10527680
14:23:24 8124 8192000000 10728334976 11149299712 1802323008 18.033 99 42 84 1 1820424720 6016528 12085184
14:23:40 7061 8192000000 10751262064 11171258368 1828559936 18.248 100 28 54 2 1841790064 6131488 7098640
14:23:54 14016 8192000000 10752905392 11178188800 1839180688 18.334 100 25 50 1 1852020912 5698816 7141408
14:24:16 7098 8192000000 10756393200 11184078848 1844928016 18.381 100 33 66 0 1860821264 5871504 10021744
14:24:30 9041 8192000000 10763976256 11194245120 1845903696 18.389 100 31 62 1 1865823408 10687280 9232432
14:24:48 9105 8192000000 10755286272 11182379008 1842482320 18.361 100 23 46 1 1854897312 5756928 6658064
14:25:05 7359 8192000000 10764789104 11186987008 1848962864 18.414 100 23 46 1 1860931376 5243008 6725504
14:25:20 11678 8192000000 10778542032 11197095936 1854920496 18.462 100 24 47 2 1867035248 5644880 6469872
14:25:43 7347 8192000000 10755153088 11190833152 1853407008 18.450 100 32 64 6 1869252944 5753104 10092832
14:25:57 11069 8192000000 10778782400 11206275072 1855640208 18.468 100 27 54 2 1874061168 10998192 7422768
14:26:17 68079 8192000000 10819129824 11219763200 1863446032 18.531 100 34 67 3 1880088384 5845504 10796848
14:27:32 13440 8192000000 10804294384 11224682496 1881163824 18.675 100 32 64 4 1897083920 6550784 9369312
14:27:57 25674 8192000000 10815261312 11236790272 1890649728 18.751 100 39 76 0 1908498432 5790896 12057808
14:28:32 27527 8192000000 10838622464 11259232256 1905864816 18.873 100 48 96 1 1929720624 10401424 13454384
14:29:07 14392 8192000000 10856907328 11271528448 1914715824 18.944 100 56 111 1 1942421712 11811664 15894224
14:29:31 9872 8192000000 10864765472 11280293888 1922222096 19.005 100 62 124 0 1953410800 13660144 17528560
14:29:52 4133 8192000000 10858422640 11276132352 1921062592 18.995 100 61 122 2 1952023968 13271808 17689568
14:30:09 12044 8192000000 10875345312 11285913600 1927065376 19.043 100 66 128 1 1959918672 13912512 18940784
14:30:51 15711 8192000000 10877353936 11301380096 1935321008 19.109 100 59 118 1 1970383728 17938672 17124048
14:31:14 1727 8192000000 10890302304 11303243776 1941502304 19.159 100 66 133 0 1976417792 16200944 18714544
14:31:23 4090 8192000000 10893438192 11301494784 1944721840 19.184 100 69 133 5 1980080512 16142720 19215952
14:31:36 2907 8192000000 10901028560 11310743552 1945749088 19.193 100 61 120 1 1980743168 17589488 17404592
14:31:46 13317 8192000000 10892030528 11311996928 1947869232 19.210 100 61 119 0 1982095040 17669232 16556576
14:32:14 15541 8192000000 10895409840 11321655296 1953460976 19.254 100 50 101 2 1989871680 21055520 15355184
14:32:59 17342 8192000000 10877080192 11320938496 1955316208 19.269 100 35 70 3 1982309792 16445984 10547600
14:33:30 5374 8192000000 10909459568 11331125248 1960780704 19.312 100 47 93 1 1993126192 18828560 13516928
14:33:43 6711 8192000000 10908024608 11334131712 1966517360 19.358 100 48 94 1 1996106992 15733216 13856416
14:33:58 7851 8192000000 10914379856 11341213696 1971440272 19.397 100 53 106 0 2004541840 17949392 15152176
14:34:12 1741 8192000000 10939185008 11355062272 1977336240 19.444 100 75 147 3 2021923376 22420368 22166768
14:34:22 5450 8192000000 10924592416 11347095552 1976792656 19.439 100 67 133 1 2019373248 23358544 19222048
14:34:37 8800 8192000000 10929777504 11350896640 1979712944 19.462 100 76 149 3 2020027456 19132720 21181792
14:34:56 11061 8192000000 10934630784 11360542720 1980673440 19.470 100 60 118 2 2018631744 20722320 17235984
14:35:15 2099 8192000000 10939198144 11363500032 1985903808 19.511 100 57 114 0 2023515504 20559152 17052544
14:35:25 11490 8192000000 10933536096 11365683200 1987195104 19.522 100 58 116 2 2026557440 20667552 18694784
14:35:44 13596 8192000000 10944690560 11373207552 1993999392 19.575 100 59 117 1 2030267408 19683696 16584320
14:36:08 13748 8192000000 10945961440 11379445760 1995088752 19.584 100 53 107 1 2033540064 21438320 17012992
14:36:39 10936 8192000000 10953854160 11389747200 1998581712 19.612 100 52 101 2 2038667280 24842640 15242928
14:37:02 5274 8192000000 10961484880 11386224640 2000395120 19.626 100 60 119 1 2043043568 24854048 17794400
14:37:15 11806 8192000000 10963602704 11390521344 2005174224 19.664 100 60 120 2 2050794128 27485680 18134224
14:37:35 14421 8192000000 10962081136 11394437120 2007411712 19.681 100 55 110 1 2053451712 29461776 16578224
14:37:58 2871 8192000000 10965726848 11385970688 1996878160 19.598 99 65 128 2 2047217248 31414176 18924912
14:38:09 6352 8192000000 10977024064 11405979648 2013698336 19.731 100 68 136 3 2067213088 32421680 21093072
14:38:23 5677 8192000000 10981885312 11410726912 2020746304 19.786 100 67 133 0 2073102320 32684320 19671696
14:38:40 3052 8192000000 10985709520 11401736192 2007386720 19.681 100 81 161 2 2065210384 34220736 23602928
14:38:51 5315 8192000000 10990703440 11402473472 2008349888 19.689 100 83 165 1 2071864928 38213456 25301584
14:39:03 1217 8192000000 10994368352 11403341824 2004947472 19.662 100 93 187 1 2071727728 38995264 27784992
14:39:12 7073 8192000000 10981664992 11401564160 1990284672 19.546 99 76 152 1 2051462816 38808640 22369504
14:39:26 2550 8192000000 10985626256 11408306176 2011079456 19.710 100 72 141 4 2071418320 39187904 21150960
14:39:38 1227 8192000000 10998320960 11411853312 2014377648 19.736 100 82 164 1 2078105680 39503136 24224896
14:39:48 2086 8192000000 10988775808 11407593472 2010410560 19.705 100 84 169 0 2076675680 40485648 25779472
14:39:57 2575 8192000000 10996142256 11417260032 2019172256 19.774 100 86 172 1 2087129088 41426160 26530672
14:40:07 5443 8192000000 11008136816 11423907840 2020279328 19.782 100 88 177 1 2090776960 43611072 26886560
14:40:20 5382 8192000000 11001994272 11414495232 1997384080 19.602 99 86 172 2 2067846304 44217264 26244960
14:40:33 8231 8192000000 10988647680 11415990272 2012186032 19.719 100 77 154 2 2081485888 44899984 24399872
14:40:51 3130 8192000000 10976307520 11394338816 1986850016 19.519 99 83 162 1 2057357552 44821424 25686112
14:41:03 6405 8192000000 10974297424 11397173248 1995267200 19.585 100 75 148 2 2063341552 44897872 23176480
14:41:17 4758 8192000000 10995394672 11419328512 2005937696 19.670 100 75 150 1 2079646592 50344128 23364768
14:41:28 1870 8192000000 10991400000 11409260544 1990970992 19.551 99 85 170 0 2062492800 45282512 26239296
14:41:38 4700 8192000000 10993177280 11419369472 2003640688 19.651 100 72 143 0 2072005264 46169984 22194592
14:41:50 4093 8192000000 10990746336 11409813504 2005843024 19.669 100 86 171 2 2079494704 46968576 26683104
14:42:02 4314 8192000000 11002793536 11426594816 2008004032 19.686 100 75 150 2 2081647344 49938464 23704848
14:42:14 1556 8192000000 10999102304 11419934720 2005385280 19.665 100 78 156 0 2080517872 51157200 23975392
14:42:23 2276 8192000000 10994881984 11419918336 2006288560 19.672 100 71 142 2 2081126544 51941456 22896528
14:42:40 15143 8192000000 11003049056 11430985728 2009886608 19.701 100 68 136 3 2083734160 52204096 21643456
14:43:03 6161 8192000000 10983813504 11417481216 2000684000 19.628 100 75 148 0 2077201824 52815296 23702528
14:43:16 9369 8192000000 10971634864 11408449536 1987176720 19.521 100 56 112 1 2060783136 54941600 18664816
14:43:35 6837 8192000000 10976114240 11409866752 1996981424 19.599 100 57 113 2 2062781360 46159088 19640848
14:43:49 4241 8192000000 10983921872 11408596992 1999503376 19.619 100 76 152 2 2068660144 43923072 25233696
14:44:04 2106 8192000000 10981083808 11397992448 1983352736 19.491 99 68 137 0 2051055600 45669792 22033072
14:44:12 8997 8192000000 10979414400 11399847936 1990845008 19.550 100 63 124 2 2055650816 44772288 20033520
14:44:29 4464 8192000000 10961274352 11383595008 1949326976 19.221 98 70 138 0 2016581920 44984624 22270320
14:44:41 3874 8192000000 10968590144 11382132736 1973616464 19.414 100 74 147 2 2044317360 46936048 23764848
14:44:53 2217 8192000000 10973509232 11393183744 1979651424 19.462 100 71 138 0 2048891120 47208832 22030864
14:45:03 4610 8192000000 10979440480 11388637184 1975692320 19.431 100 83 161 2 2051784400 49384256 26707824
14:45:16 2955 8192000000 10976192288 11394129920 1980468992 19.468 100 79 156 1 2056341776 50800992 25071792
14:45:27 4323 8192000000 10964281568 11390652416 1976839680 19.440 100 64 128 0 2050179680 52639600 20700400
14:45:40 3999 8192000000 10972362144 11391242240 1959605728 19.303 99 71 139 1 2034473200 53239424 21628048
14:46:08 2636 8192000000 10988558128 11411369984 1996157680 19.592 100 74 148 1 2071049904 51765808 23126416
14:46:23 2336 8192000000 10976001376 11391623168 1976416496 19.436 100 78 157 0 2054700896 53453760 24830640
14:46:34 9323 8192000000 10903561520 11329777664 1895584240 18.791 97 55 110 0 1961895984 48228592 18083152
14:46:54 10873 8192000000 10911479616 11329265664 1908548192 18.895 98 52 104 0 1976798864 51368448 16882224
14:47:13 5952 8192000000 10933288448 11358101504 1949370544 19.221 100 66 132 0 2020561248 49068192 22122512
14:47:26 1510 8192000000 10937293632 11350024192 1939124080 19.140 99 89 176 1 2014547936 48604960 26818896
14:47:35 1979 8192000000 10949907040 11367620608 1956962416 19.282 100 87 174 3 2035282896 50638784 27681696
14:47:48 14707 8192000000 10933027632 11370254336 1953714784 19.256 100 36 72 2 2013422544 47585344 12122416
14:48:09 8793 8192000000 10944951664 11380379648 1963981600 19.338 100 47 93 0 2026725200 47355664 15387936
14:48:29 9112 8192000000 10952124240 11387789312 1971186480 19.395 100 50 100 1 2039688816 51464512 17037824
14:48:45 11636 8192000000 10960438256 11397316608 1975157712 19.426 100 47 94 0 2041807776 50560992 16089072
14:49:10 5963 8192000000 10996872400 11418394624 1997203104 19.601 100 80 158 2 2075089840 52249200 25637536
14:49:27 12933 8192000000 10975200032 11414630400 1988387904 19.531 100 48 97 0 2060098800 55129440 16581456
14:49:56 8886 8192000000 10969307296 11410706432 1988898560 19.535 100 51 102 0 2058519840 51875216 17746064
14:50:24 3897 8192000000 10965558448 11408105472 1983880800 19.495 100 48 97 4 2048267232 48748864 15637568
14:50:38 8269 8192000000 10974552048 11410395136 1983134800 19.490 100 55 109 0 2055718160 54284448 18298912
14:51:07 30180 8192000000 10951068368 11406295040 1971232256 19.395 100 33 66 0 2041485488 57945296 12307936
14:51:56 14796 8192000000 10942182912 11395309568 1963900000 19.337 100 29 58 2 2033340720 58693440 10747280
14:52:20 12706 8192000000 10940756608 11385704448 1949800976 19.225 100 34 68 1 2023089152 59897920 13390256
14:53:02 28074 8192000000 10929267680 11384725504 1893500320 18.774 97 33 65 3 1973674528 66993472 13180736
14:54:03 38515 8192000000 10886567424 11356172288 1878893392 18.656 98 20 40 1 1939555424 53621840 7040192
14:54:48 72485 8192000000 10859885344 11341209600 1903116896 18.851 99 10 20 0 1930770592 24643344 3010352
14:56:07 68038 8192000000 10851208304 11317084160 1875940544 18.632 97 21 41 1 1896863344 14956304 5966496
14:57:21 40633 8192000000 10859824256 11318280192 1910998176 18.915 99 24 48 1 1935137936 17686080 6453680
14:58:20 16379 8192000000 10858335456 11323846656 1937986304 19.131 100 17 34 4 1949045840 6796288 4263248
14:58:53 41711 8192000000 10879108144 11335147520 1934677648 19.104 99 30 61 1 1950710304 7608400 8424256
14:59:41 29800 8192000000 10850555840 11310370816 1911634096 18.920 98 27 54 3 1926389616 7790736 6964784
15:00:21 38775 8192000000 10856436928 11326750720 1924699344 19.024 99 11 21 1 1935671392 8495104 2476944
15:01:42 23829 8192000000 10840250272 11305922560 1919867744 18.986 100 5 10 0 1927099456 6487856 743856
15:02:13 6389 8192000000 10845752176 11310272512 1926134432 19.036 100 9 18 0 1934902624 6601728 2166464
15:02:25 64348 8192000000 10844195856 11314339840 1913859936 18.938 99 12 24 1 1924179264 7423296 2896032
15:03:36 52145 8192000000 10884029456 11338727424 1937693296 19.128 100 15 29 1 1948501168 7095264 3712608
15:04:35 102376 8192000000 10875663808 11347599360 1938247168 19.133 99 16 32 0 1954908912 12138496 4523248
15:07:10 62885 8192000000 10896854544 11336867840 1911344304 18.917 98 19 38 2 1930296320 13926784 5025232
15:08:20 51761 8192000000 10878787856 11355070464 1957500512 19.286 100 15 30 1 1972772256 11258048 4013696
15:09:22 18064 8192000000 10879369792 11344027648 1954902496 19.266 100 21 42 2 1970536016 9583072 6050448
15:10:04 47418 8192000000 10901981904 11367591936 1949085664 19.219 99 27 54 1 1975681712 18991888 7604160
15:10:58 51800 8192000000 10880550048 11366699008 1956941680 19.282 100 13 26 0 1974770336 14468848 3359808
15:12:03 40718 8192000000 10882108944 11343831040 1922442416 19.006 98 27 54 1 1936859936 7245824 7171696
15:12:52 20048 8192000000 10887957824 11353407488 1959260768 19.300 100 21 42 3 1974634912 9243248 6130896
15:13:27 46090 8192000000 10871444608 11345154048 1925800672 19.033 98 15 30 0 1937830512 7947088 4082752
15:14:19 33064 8192000000 10883953744 11345104896 1936069744 19.115 99 24 46 0 1950067824 6912624 7085456
15:15:05 41559 8192000000 10872012768 11333574656 1932219888 19.085 99 15 30 0 1946418048 9802032 4396128
15:15:53 109799 8192000000 10901022704 11361583104 1901390672 18.837 97 16 32 0 1921394800 14805136 5198992
15:17:50 86230 8192000000 10908458208 11374292992 1963057216 19.330 100 13 26 0 1980223824 13796240 3370368
15:19:31 55370 8192000000 10917659584 11375509504 1977772064 19.447 100 13 26 1 1994233040 12827584 3633392
15:20:38 52073 8192000000 10905009280 11377676288 1927098416 19.044 97 18 36 1 1945272288 13048064 5125808
15:21:47 114632 8192000000 10883396960 11361513472 1900207072 18.828 96 14 28 2 1922426256 17989952 4229232
15:23:48 131252 8192000000 10871657728 11342602240 1909985920 18.907 97 20 40 2 1929441872 13658240 5797712
15:26:26 50852 8192000000 10897076208 11347525632 1953460336 19.254 100 31 62 2 1972698544 10316992 8921216
15:27:24 18757 8192000000 10886960832 11336941568 1927264288 19.045 98 57 112 1 1955831344 11786112 16780944
15:27:51 45935 8192000000 10858320736 11332263936 1936634896 19.120 99 26 52 1 1955461968 12059712 6767360
15:28:44 61514 8192000000 10858511680 11347030016 1939709984 19.144 100 8 15 0 1953519952 11571632 2238336
15:29:54 15102 8192000000 10866067984 11342766080 1930650912 19.072 99 8 17 0 1944202480 10906560 2645008
15:30:46 52581 8192000000 10860125472 11334651904 1930110912 19.068 99 13 26 0 1941047152 7373616 3562624
15:31:54 52687 8192000000 10870911936 11346612224 1927063728 19.043 99 6 12 0 1936816480 8264752 1488000
15:32:53 60223 8192000000 10884438128 11355787264 1946722880 19.200 99 18 36 1 1965883760 14069680 5091200
15:34:00 28693 8192000000 10891325440 11360264192 1918209904 18.972 97 23 44 4 1937578736 13205360 6163472
15:34:35 63884 8192000000 10894012352 11369672704 1905470992 18.870 97 15 30 0 1926885072 17025248 4388832
15:35:45 54972 8192000000 10866861584 11325394944 1856821232 18.478 95 19 38 1 1871379520 9069376 5488912
15:36:48 31892 8192000000 10869504576 11322540032 1896918896 18.802 98 24 48 0 1913220768 9246176 7055696
15:37:29 68344 8192000000 10888449488 11350863872 1923969440 19.019 99 35 70 0 1947713488 12878560 10865488
15:38:44 63227 8192000000 10888638688 11345616896 1912204448 18.924 98 22 44 0 1934557616 15565952 6787216
15:39:59 37530 8192000000 10851802384 11307810816 1825004896 18.219 94 27 52 2 1844858256 12664944 7188416
15:40:42 41610 8192000000 10834457152 11291283456 1843304608 18.368 96 24 48 0 1861301952 11296576 6700768
15:41:30 34805 8192000000 10847685520 11292270592 1846141728 18.391 96 41 83 1 1867164896 9509232 11513936
15:42:14 26911 8192000000 10827829408 11290886144 1877506976 18.645 98 37 74 1 1901237728 13438992 10291760
15:42:53 39181 8192000000 10844397056 11292246016 1859518368 18.499 97 24 48 1 1875701888 9593536 6589984
15:44:18 70044 8192000000 10867014560 11340468224 1882138672 18.682 98 22 45 0 1906556000 18085280 6332048
15:45:35 98309 8192000000 10864749104 11350048768 1888373744 18.733 98 4 8 0 1909068528 19543904 1150880
15:48:17 109731 8192000000 10861898896 11339214848 1930571088 19.071 100 27 52 1 1948879776 10334368 7974320
15:50:16 44189 8192000000 10864415984 11341451264 1940107104 19.148 100 17 34 1 1957523664 12795952 4620608
15:52:04 46200 8192000000 10858407360 11334615040 1926897360 19.042 99 15 30 1 1943442144 12140896 4403888
15:53:04 53578 8192000000 10878569504 11357642752 1955539728 19.271 100 11 22 1 1975365216 16523184 3302304
15:54:04 85860 8192000000 10887497552 11355340800 1942583232 19.167 99 20 38 2 1966467472 17883440 6000800
15:55:40 70657 8192000000 10876931264 11362664448 1933842192 19.098 99 19 38 1 1962948352 23002384 6103776
15:57:03 63851 8192000000 10876904864 11346042880 1917665568 18.968 98 14 28 1 1937187712 15506112 4016032
15:58:14 97950 8192000000 10888706016 11370172416 1922192912 19.004 98 11 22 0 1937100368 11927312 2980144
15:59:58 80576 8192000000 10888115280 11369951232 1933876304 19.098 98 15 30 0 1957637728 19960288 3801136
16:01:26 95828 8192000000 10891197952 11370364928 1925659392 19.032 98 8 16 0 1941485760 13730656 2095712
16:03:09 67435 8192000000 10909551472 11368345600 1936833504 19.121 98 27 54 2 1951972496 8093152 7045840
16:04:24 38017 8192000000 10930469328 11385159680 1966206320 19.355 99 41 80 2 1985321792 8369664 10745808
16:05:09 30755 8192000000 10944256304 11399565312 1985738928 19.510 100 38 76 1 2008099840 11956336 10404576
16:05:48 16968 8192000000 10929001680 11388231680 1987678432 19.525 100 44 87 3 2010927440 11516336 11732672
16:06:15 29013 8192000000 10944670560 11399266304 1991684688 19.557 100 44 88 1 2015777696 11939568 12153440
16:06:53 73496 8192000000 10920854048 11389370368 1930920752 19.074 97 26 50 5 1952028720 14299264 6808704
16:08:13 87238 8192000000 10913256112 11402866688 1955696480 19.272 99 12 24 1 1985484544 26099984 3688080
16:09:52 69552 8192000000 10911204896 11386576896 1939985776 19.147 98 14 27 0 1959264608 15429584 3849248
16:11:10 118913 8192000000 10871293056 11350020096 1918320320 18.973 97 29 58 1 1939229664 12725072 8184272
16:14:07 18315 8192000000 10859672544 11321602048 1897142496 18.803 96 29 57 1 1915019792 9476112 8401184
16:14:31 62198 8192000000 10863945408 11352248320 1923409712 19.014 98 35 70 2 1945090752 11632688 10048352
16:16:09 40022 8192000000 10872196896 11364675584 1934580016 19.103 99 7 14 0 1948818000 12797264 1440720
16:16:57 7848 8192000000 10871857008 11360309248 1950935904 19.234 100 12 23 1 1966434032 12257888 3240240
16:17:11 61226 8192000000 10872927664 11350118400 1936035280 19.115 99 15 30 1 1949667600 9655136 3977184
16:18:50 98610 8192000000 10885388384 11371356160 1944924544 19.186 99 14 28 0 1959016496 9811024 4280928
16:20:43 61785 8192000000 10893890128 11366645760 1948917408 19.218 99 15 30 0 1963551536 9896080 4738048
16:22:02 67033 8192000000 10899323328 11365474304 1907917456 18.890 97 12 24 0 1918649424 6945168 3786800
16:23:29 55927 8192000000 10890448656 11368996864 1943817568 19.177 99 19 39 0 1958134912 9095936 5221408
16:24:31 74803 8192000000 10886418400 11371479040 1912261376 18.925 97 17 34 1 1929599664 12532928 4805360
16:25:52 54677 8192000000 10877994880 11348127744 1904988240 18.866 97 10 20 1 1918050112 10032528 3029344
16:26:57 48382 8192000000 9620703376 9946939392 759173168 8.481 39 14 29 0 769211840 6361552 3677120

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 16-06-2021 16:28:50 to 16-06-2021 16:29:22.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 111 v_add_invoice_to_stock 335544517
except 3 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 16-06-2021 16:29:23 to 16-06-2021 16:29:25.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          235738
MON$OLDEST_ACTIVE               235739
MON$OLDEST_SNAPSHOT             235739
MON$NEXT_TRANSACTION            235739
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-03 16:41:55.3470
MON$PAGES                       2026848
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33474 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33474 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33474 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33474 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
:54: 
:55: mscs-test-161.budzdorov.ru    Wed Jun 16 16:27:56 2021
:56:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:57: 
--- end of diff output ---

Final processing ISQL logs in /var/tmp/logs-oltp30 according to config parameter 'remove_isql_logs'

16.06.21 16:29:26. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2021-06-16 16:29:28 No severe PSQL-related problems occured
16.06.21 16:29:30. End of report.