Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 09.06.2021 22:27
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 17110084 kB
MemAvailable 31407560 kB
Buffers 0 kB
Cached 14528356 kB
SwapCached 80 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-09 22:27:41
DTS_END                         2021-06-09 22:27:41.3790
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(38:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/55146
TRN_ID                          245721
ATT_ID                          700
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: 9484.05 20370 1138086
customer order: creation 177.10 316 21252
customer order: refuse 14.86 309 1783
order to supplier: creation 48.38 1256 5806
order to supplier: removal 3.56 93972 427
invoice (draft): creation 47.13 3537 5656
invoice (draft): removal 54.93 807 6592
invoice accept: apply 43.17 16265 5180
invoice accept: cancel 49.26 701 5911
customer reserve: creation 3917.48 165 470097
customer reserve: removal 4821.58 53 578589
realization accept: apply 86.34 158 10361
realization accept: cancel 86.29 97 10355
payment from customer: creation 60.89 103 7307
payment from customer: removal 5.83 82 700
payment to supplier: creation 51.13 127 6136
payment to supplier: removal 3.48 49 417
service: total inventory turnovers 5.01 1142 601
service: total monetary turnovers 6.84 25 821
service: aggregate perf. data 0.76 28336 91
service: refresh index statistics 0.03 259903 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 09-06-2021 22:28:13 to 09-06-2021 22:28:16.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3575
TEST_TIME 2 2894
TEST_TIME 3 3576
TEST_TIME 4 4522
TEST_TIME 5 4638
TEST_TIME 6 4634
TEST_TIME 7 4583
TEST_TIME 8 4689
TEST_TIME 9 4938
TEST_TIME 10 5281
TEST_TIME 11 5772
TEST_TIME 12 5946
TEST_TIME 13 6254
TEST_TIME 14 6174
TEST_TIME 15 6226
TEST_TIME 16 6295
TEST_TIME 17 6671
TEST_TIME 18 6750
TEST_TIME 19 7174
TEST_TIME 20 7341
TEST_TIME 21 7576
TEST_TIME 22 7833
TEST_TIME 23 8400
TEST_TIME 24 9113
TEST_TIME 25 9623
TEST_TIME 26 9357
TEST_TIME 27 10071
TEST_TIME 28 10013
TEST_TIME 29 10007
TEST_TIME 30 9894
TEST_TIME 31 9841
TEST_TIME 32 9949
TEST_TIME 33 9934
TEST_TIME 34 9831
TEST_TIME 35 10027
TEST_TIME 36 9930
TEST_TIME 37 9943
TEST_TIME 38 10071
TEST_TIME 39 9844
TEST_TIME 40 9611
TEST_TIME 41 9871
TEST_TIME 42 9756
TEST_TIME 43 9768
TEST_TIME 44 9727
TEST_TIME 45 9685
TEST_TIME 46 9636
TEST_TIME 47 9593
TEST_TIME 48 9787
TEST_TIME 49 9695
TEST_TIME 50 9704
TEST_TIME 51 9639
TEST_TIME 52 9557
TEST_TIME 53 9474
TEST_TIME 54 9489
TEST_TIME 55 9600
TEST_TIME 56 9500
TEST_TIME 57 9426
TEST_TIME 58 9339
TEST_TIME 59 9293
TEST_TIME 60 9271
TEST_TIME 61 9288
TEST_TIME 62 9240
TEST_TIME 63 9374
TEST_TIME 64 9426
TEST_TIME 65 9380
TEST_TIME 66 9462
TEST_TIME 67 9398
TEST_TIME 68 9604
TEST_TIME 69 9532
TEST_TIME 70 9596
TEST_TIME 71 9644
TEST_TIME 72 9619
TEST_TIME 73 9718
TEST_TIME 74 9686
TEST_TIME 75 9583
TEST_TIME 76 9575
TEST_TIME 77 9552
TEST_TIME 78 9598
TEST_TIME 79 9573
TEST_TIME 80 9481
TEST_TIME 81 9456
TEST_TIME 82 9420
TEST_TIME 83 9360
TEST_TIME 84 9374
TEST_TIME 85 9341
TEST_TIME 86 9362
TEST_TIME 87 9404
TEST_TIME 88 9366
TEST_TIME 89 9352
TEST_TIME 90 9399
TEST_TIME 91 9499
TEST_TIME 92 9491
TEST_TIME 93 9559
TEST_TIME 94 9593
TEST_TIME 95 9572
TEST_TIME 96 9629
TEST_TIME 97 9624
TEST_TIME 98 9690
TEST_TIME 99 9605
TEST_TIME 100 9547
TEST_TIME 101 9506
TEST_TIME 102 9506
TEST_TIME 103 9511
TEST_TIME 104 9479
TEST_TIME 105 9435
TEST_TIME 106 9405
TEST_TIME 107 9398
TEST_TIME 108 9349
TEST_TIME 109 9349
TEST_TIME 110 9361
TEST_TIME 111 9346
TEST_TIME 112 9381
TEST_TIME 113 9370
TEST_TIME 114 9398
TEST_TIME 115 9426
TEST_TIME 116 9445
TEST_TIME 117 9417
TEST_TIME 118 9490
TEST_TIME 119 9505
TEST_TIME 120 9485

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 09-06-2021 22:28:17 to 09-06-2021 22:28:20.

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 1574634 1574634 0 0.00 0 17966 6 0 0
doc_list_biud 1574595 1574595 0 0.00 0 48320 25 0 0
sp_add_invoice_to_stock 5348 5180 168 3.14 37 190692 16266 0 168
sp_cancel_adding_invoice 5911 5911 0 0.00 4 98492 701 0 0
sp_cancel_client_order 1783 1783 0 0.00 5 9368 310 0 0
sp_cancel_customer_reserve 578589 578589 0 0.00 1 48321 53 0 0
sp_cancel_pay_from_customer 700 700 0 0.00 3 3165 83 0 0
sp_cancel_pay_to_supplier 417 417 0 0.00 3 1590 49 0 0
sp_cancel_supplier_invoice 6604 6592 12 0.18 2 34610 808 0 12
sp_cancel_supplier_order 427 427 0 0.00 6 1083894 93972 0 0
sp_cancel_write_off 10355 10355 0 0.00 1 8762 98 0 0
sp_client_order 21252 21252 0 0.00 4 29966 317 0 0
sp_customer_reserve 470097 470097 0 0.00 0 106343 165 0 0
sp_fill_shopping_cart 32712 32712 0 0.00 1 24678 42 0 0
sp_fill_shopping_cart_clo_res 470095 470095 0 0.00 0 16319 12 0 0
sp_get_clo_for_invoice 5178 5178 0 0.00 0 22669 263 0 0
sp_kill_cost_storno 17383 17383 0 0.00 0 6478 50 0 0
sp_kill_qstorno_ret_qs2qd 1174552 1174552 0 0.00 0 48312 29 0 0
sp_kill_qty_storno 619175 619175 0 0.00 0 48320 63 0 0
sp_lock_selected_doc 21451 21451 0 0.00 0 7317 5 0 0
sp_make_cost_storno 28982 28982 0 0.00 0 15126 48 0 0
sp_multiply_rows_for_pdistr 28943 28943 0 0.00 0 14519 27 0 0
sp_multiply_rows_for_qdistr 21252 21252 0 0.00 0 26339 138 0 0
sp_pay_from_customer 7307 7307 0 0.00 4 10327 103 0 0
sp_pay_to_supplier 6136 6136 0 0.00 5 15136 127 0 0
sp_payment_common 13425 13425 0 0.00 1 8253 25 0 0
sp_qd_handle_on_cancel_clo 1783 1783 0 0.00 0 9358 274 0 0
sp_qd_handle_on_invoice_upd_sts 11083 11083 0 0.00 0 23641 298 0 0
sp_qd_handle_on_reserve_upd_sts 10346 10346 0 0.00 0 11399 50 0 0
sp_reserve_write_off 10361 10361 0 0.00 6 11430 158 0 0
sp_supplier_invoice 5656 5656 0 0.00 6 89895 3538 0 0
sp_supplier_order 5806 5806 0 0.00 5 21227 1256 0 0
srv_aggregate_perf_data 91 91 0 0.00 2215 875869 28337 0 0
srv_fill_mon_cache_memory 161 161 0 0.00 1388 127649 32692 0 0
srv_find_qd_qs_mism 1089615 1089615 0 0.00 0 17966 5 0 0
srv_make_invnt_saldo 601 601 0 0.00 34 59990 1143 0 0
srv_make_money_saldo 821 821 0 0.00 1 2542 25 0 0
srv_recalc_idx_stat 4 4 0 0.00 153903 351241 259903 0 0
t$perf-abend:sp_add_invoice_to_stock 168 168 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5180 5180 0 0.00 0 14460 151 0 0
t$perf-norm:sp_cancel_adding_invoice 434 434 0 0.00 1 1855 66 0 0
t$perf-norm:sp_cancel_client_order 1783 1783 0 0.00 0 2206 12 0 0
t$perf-norm:sp_cancel_customer_reserve 659 659 0 0.00 0 4219 22 0 0
t$perf-norm:sp_cancel_pay_from_customer 700 700 0 0.00 0 1751 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 417 417 0 0.00 0 2594 11 0 0
t$perf-norm:sp_cancel_supplier_invoice 428 428 0 0.00 0 5245 23 0 0
t$perf-norm:sp_cancel_supplier_order 427 427 0 0.00 0 24655 1671 0 0
t$perf-norm:sp_cancel_write_off 1085 1085 0 0.00 0 3701 10 0 0
t$perf-norm:sp_client_order 21252 21252 0 0.00 0 7891 17 0 0
t$perf-norm:sp_customer_reserve 1072 1072 0 0.00 0 1542 9 0 0
t$perf-norm:sp_pay_from_customer 7307 7307 0 0.00 0 15922 11 0 0
t$perf-norm:sp_pay_to_supplier 6136 6136 0 0.00 0 5283 13 0 0
t$perf-norm:sp_reserve_write_off 10361 10361 0 0.00 0 7435 10 0 0
t$perf-norm:sp_supplier_invoice 5656 5656 0 0.00 0 7789 20 0 0
t$perf-norm:sp_supplier_order 5806 5806 0 0.00 0 6953 15 0 0
t$perf-norm:srv_aggregate_perf_data 91 91 0 0.00 0 921 12 0 0
t$perf-norm:srv_fill_mon_cache_memory 161 161 0 0.00 0 779 6 0 0
t$perf-norm:srv_make_invnt_saldo 601 601 0 0.00 0 1197 18 0 0
t$perf-norm:srv_make_money_saldo 821 821 0 0.00 0 2042 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 6 3 0 0
v_add_invoice_to_stock 10680 10344 336 3.14 0 9472 20 0 336
v_all_customers 38854 38854 0 0.00 0 16 1 0 0
v_all_suppliers 31586 31586 0 0.00 0 14 1 0 0
v_all_wares 42504 42504 0 0.00 0 30 1 0 0
v_cancel_adding_invoice 868 868 0 0.00 0 2862 11 0 0
v_cancel_client_order 3566 3566 0 0.00 0 3112 7 0 0
v_cancel_customer_prepayment 1400 1400 0 0.00 0 1582 9 0 0
v_cancel_customer_reserve 1318 1318 0 0.00 0 2287 8 0 0
v_cancel_payment_to_supplier 834 834 0 0.00 0 671 3 0 0
v_cancel_supplier_invoice 880 856 24 2.72 0 4755 32 0 24
v_cancel_supplier_order 854 854 0 0.00 0 1395 5 0 0
v_cancel_write_off 2170 2170 0 0.00 0 2597 14 0 0
v_max_id_clo_ord 5804 5804 0 0.00 0 774 2 0 0
v_max_id_clo_res 1072 1072 0 0.00 0 2586 10 0 0
v_max_id_ord_sup 5656 5656 0 0.00 0 4245 7 0 0
v_max_non_paid_invoice 1788 1788 0 0.00 0 1259 3 0 0
v_max_non_paid_realizn 3873 3873 0 0.00 0 2092 4 0 0
v_min_id_clo_ord 5804 5804 0 0.00 0 1462 5 0 0
v_min_id_clo_res 1072 1072 0 0.00 0 3543 13 0 0
v_min_id_ord_sup 5656 5656 0 0.00 0 6227 15 0 0
v_min_non_paid_invoice 6124 6124 0 0.00 0 7508 14 0 0
v_min_non_paid_realizn 7299 7299 0 0.00 0 7072 15 0 0
v_our_firm 10502 10502 0 0.00 0 14 1 0 0
v_reserve_write_off 20692 20692 0 0.00 0 10209 7 0 0
x_lock_depdocs_on_canc_invoice 12075 12075 0 0.00 0 28911 119 0 0
x_lock_depdocs_on_canc_sup_ord 427 427 0 0.00 0 9103 298 0 0
x_make_qstorno_1000_1200 5806 5806 0 0.00 1 20377 1179 0 0
x_make_qstorno_1200_2000 5656 5656 0 0.00 3 89861 3379 0 0
x_make_qstorno_2100_3300 470097 470097 0 0.00 0 106342 151 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 09-06-2021 22:28:21 to 09-06-2021 22:28:25.

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
19:57:44 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:51 25478 8192000000 10253488752 10565193728 837796176 9.278 65 54 108 0 862317168 6658528 17862464
19:58:26 33504 8192000000 10340129856 10651549696 1384952064 14.461 100 86 173 0 1418319680 4954128 28413488
19:59:11 26109 8192000000 10365962144 10686681088 1414150688 14.721 100 88 176 0 1449731392 6551344 29029360
20:00:00 25476 8192000000 10397682848 10724315136 1450205488 15.040 100 87 174 0 1486226080 7294368 28726224
20:00:35 9666 8192000000 10414440464 10742755328 1470002336 15.214 100 87 174 1 1506342240 8250416 28089488
20:00:54 16731 8192000000 10425882640 10757206016 1483171648 15.329 100 92 184 0 1521633680 8634912 29827120
20:01:25 20813 8192000000 10449530768 10784718848 1498205808 15.461 100 84 168 2 1533545792 9134704 26205280
20:02:06 14040 8192000000 10481147632 10826412032 1535960208 15.789 100 75 150 0 1568611792 9053424 23598160
20:02:35 10425 8192000000 10522024416 10872774656 1584957920 16.211 100 82 164 0 1619756832 9866592 24932320
20:02:52 15772 8192000000 10540022960 10893324288 1598401232 16.326 100 84 168 1 1634942928 10583472 25958224
20:03:20 11664 8192000000 10566799616 10929377280 1621882960 16.526 100 76 153 2 1656233584 11071456 23279168
20:03:41 10732 8192000000 10601675472 10965893120 1650257904 16.767 100 79 157 1 1684970768 11146672 23566192
20:04:01 8465 8192000000 10615035408 10980024320 1668078416 16.917 100 79 158 0 1703160832 11818192 23264224
20:04:16 7736 8192000000 10625670112 10993451008 1681768704 17.032 100 77 153 3 1715710256 11596208 22345344
20:04:31 7782 8192000000 10641055424 11010011136 1701726128 17.200 100 81 162 2 1737372976 11862576 23784272
20:04:50 8068 8192000000 10663267088 11035938816 1722809360 17.376 100 82 164 2 1759019248 12110496 24099392
20:05:07 6295 8192000000 10676901264 11051167744 1735628464 17.482 100 77 153 1 1768439840 11566688 21244688
20:05:21 4898 8192000000 10685921312 11061366784 1749213872 17.595 100 86 170 1 1785957408 12488400 24255136
20:05:34 7725 8192000000 10697721504 11074723840 1758385936 17.671 100 90 178 0 1797127008 13634432 25106640
20:05:49 4985 8192000000 10702916832 11081289728 1769302416 17.761 100 86 172 0 1806803408 13633536 23867456
20:06:02 4016 8192000000 10722097344 11101360128 1776350832 17.819 100 89 177 1 1814720784 13774000 24595952
20:06:13 3184 8192000000 10715375456 11097354240 1778295696 17.835 100 80 159 1 1814738976 13687216 22756064
20:06:23 3503 8192000000 10728923808 11107704832 1785705232 17.896 100 82 163 0 1821186640 13238368 22243040
20:06:33 2544 8192000000 10736690128 11117002752 1795171392 17.974 100 86 169 2 1832031584 13199648 23660544
20:06:43 2979 8192000000 10738323824 11119534080 1799009312 18.006 100 92 182 0 1838014400 13532080 25473008
20:06:52 4224 8192000000 10745329568 11126800384 1805689520 18.061 100 93 186 1 1845479584 13918544 25871520
20:07:03 3487 8192000000 10751944912 11134799872 1816476240 18.149 100 91 183 1 1855959648 13787296 25696112
20:07:14 2427 8192000000 10760886400 11145547776 1822622832 18.199 100 90 179 2 1860804928 13656096 24526000
20:07:22 6666 8192000000 10758366880 11144376320 1820657552 18.183 100 78 155 0 1854760816 13394432 20708832
20:07:37 4185 8192000000 10778143152 11164254208 1832416480 18.279 100 87 174 0 1870622560 13955728 24250352
20:07:47 2178 8192000000 10778446768 11164442624 1837031600 18.317 100 93 188 0 1877904192 14663888 26208704
20:07:56 2156 8192000000 10774917856 11162492928 1843610496 18.370 100 93 186 0 1884912864 15077040 26225328
20:08:04 2998 8192000000 10793867024 11179147264 1847841264 18.405 100 89 176 1 1886161344 13577904 24742176
20:08:14 1722 8192000000 10796826544 11183566848 1854256144 18.457 100 92 182 4 1892537968 12946992 25334832
20:08:22 1987 8192000000 10793134320 11178893312 1858563488 18.492 100 94 186 2 1898670432 13355904 26751040
20:08:31 1157 8192000000 10811517648 11197198336 1864049760 18.536 100 94 189 1 1903613728 13438896 26125072
20:08:38 1582 8192000000 10812993280 11203481600 1868962528 18.576 100 95 191 3 1909239040 12756656 27519856
20:08:46 1333 8192000000 10819492704 11207577600 1874897056 18.624 100 94 186 2 1915007472 12499760 27610656
20:08:54 47021 8192000000 10781736736 11201110016 1866755504 18.558 100 47 91 1 1886358320 6250448 13352368
20:09:50 10493 8192000000 10790676400 11204734976 1873110992 18.609 100 31 62 0 1889247680 8006272 8130416
20:10:06 3380 8192000000 10789441440 11209322496 1873738064 18.615 100 47 92 2 1896050224 9131696 13180464
20:10:19 9964 8192000000 10779156912 11202977792 1869951648 18.584 100 19 36 3 1882682832 7064128 5667056
20:10:36 9060 8192000000 10792404976 11215130624 1874867488 18.624 100 28 57 1 1889863392 6913616 8082288
20:10:52 6915 8192000000 10789689424 11216220160 1877510144 18.645 100 28 56 0 1892750016 7058624 8181248
20:11:07 6050 8192000000 10795224096 11223732224 1881296688 18.676 100 28 56 0 1896449760 6644848 8508224
20:11:20 13669 8192000000 10798596112 11226652672 1881991088 18.681 100 20 39 0 1897890000 10532416 5366496
20:11:39 12231 8192000000 10794433760 11226566656 1882378064 18.684 100 9 18 0 1891071344 5864784 2828496
20:11:58 12373 8192000000 10804999440 11231051776 1887410480 18.725 100 14 29 1 1897046608 5540864 4095264
20:12:16 6222 8192000000 10798619312 11230953472 1891012048 18.754 100 18 36 2 1902107696 6162448 4933200
20:12:30 6764 8192000000 10812735744 11239784448 1900173232 18.828 100 39 78 1 1918939664 8295584 10470848
20:12:49 30856 8192000000 10814489408 11246813184 1899175984 18.820 100 28 54 3 1911888496 4748080 7964432
20:13:37 22908 8192000000 10856757520 11260235776 1907296512 18.885 100 67 135 0 1933152336 6777264 19078560
20:14:06 5048 8192000000 10821566800 11260268544 1904879744 18.866 100 35 70 0 1927105280 13154432 9071104
20:14:18 10877 8192000000 10809979056 11250180096 1901769168 18.841 100 20 40 1 1917203456 10059744 5374544
20:14:36 4440 8192000000 10837385472 11260346368 1905488896 18.870 100 25 50 1 1919291472 5904064 7898512
20:14:48 6127 8192000000 10828538000 11262365696 1910707296 18.912 100 30 60 0 1926386560 7590000 8089264
20:15:02 4209 8192000000 10837074384 11262136320 1912880608 18.930 100 35 71 1 1929716224 6672768 10162848
20:15:13 5293 8192000000 10825003488 11258212352 1896188400 18.796 99 35 70 3 1913917840 7568400 10161040
20:15:26 8398 8192000000 10828511024 11260637184 1910000864 18.907 100 24 48 4 1922944704 6202464 6741376
20:15:43 9571 8192000000 10833238688 11266146304 1913277840 18.933 100 28 55 1 1932371824 11975424 7118560
20:15:59 7769 8192000000 10819228944 11238785024 1891990832 18.762 99 32 66 0 1905864736 4876592 8997312
20:16:15 5153 8192000000 10818281952 11248508928 1889435248 18.741 99 24 47 1 1902310016 5690848 7183920
20:16:27 11766 8192000000 10830998528 11261804544 1908784032 18.897 100 16 32 1 1919163696 6090912 4288752
20:16:45 9595 8192000000 10800499360 11239100416 1867299088 18.562 98 12 22 1 1876765888 6150352 3316448
20:17:02 6753 8192000000 10816354800 11252166656 1907734752 18.888 100 17 32 1 1917457808 5303536 4419520
20:17:15 7010 8192000000 10808798896 11237298176 1860530896 18.508 98 23 46 0 1874194528 6982688 6680944
20:17:31 35541 8192000000 10776501872 11209789440 1807228080 18.073 95 30 58 1 1821812080 5108144 9475856
20:18:12 55486 8192000000 10792392128 11227095040 1816537616 18.149 96 45 89 0 1835092912 5819696 12735600
20:19:16 6069 8192000000 10801689792 11232428032 1884200880 18.699 100 34 68 1 1901882912 7777616 9904416
20:19:31 7063 8192000000 10748526208 11164946432 1771171440 17.777 95 39 78 2 1788730608 6582704 10976464
20:19:44 5426 8192000000 10770826048 11189358592 1838026656 18.325 99 43 86 2 1857394192 7203376 12164160
20:19:59 6042 8192000000 10746257152 11172917248 1821464048 18.190 99 29 59 3 1836466336 6524752 8477536
20:20:11 9784 8192000000 10745458240 11173920768 1781962352 17.866 96 24 48 1 1793676256 4681232 7032672
20:20:30 6362 8192000000 10737998224 11162816512 1802885984 18.038 98 20 40 3 1814539536 5656576 5996976
20:20:43 6220 8192000000 10746460912 11156082688 1785592432 17.896 97 24 48 1 1798080864 5371312 7117120
20:20:55 6104 8192000000 10728339552 11148484608 1786061760 17.899 98 28 56 3 1801506928 7376096 8069072
20:21:11 7662 8192000000 10733437120 11153723392 1790288096 17.934 98 32 65 2 1805693568 5800016 9605456
20:21:25 9586 8192000000 10715042480 11138473984 1763374464 17.712 97 19 38 2 1774262624 4707216 6180944
20:21:42 6254 8192000000 10726402016 11149938688 1785756880 17.897 98 16 31 0 1795604064 5613216 4233968
20:21:55 12376 8192000000 10689794400 11108458496 1686295680 17.070 93 27 54 1 1699595088 5377952 7921456
20:22:13 11969 8192000000 10730057584 11145465856 1802983920 18.038 100 29 58 3 1817859888 5717904 9158064
20:22:33 7613 8192000000 10730965280 11147247616 1786081968 17.900 98 41 80 1 1803987184 5405600 12499616
20:22:47 41372 8192000000 10704532192 11118968832 1749340176 17.596 96 35 69 0 1765662032 5292064 11029792
20:23:47 32267 8192000000 10723583952 11149635584 1760574352 17.689 97 18 36 0 1771422496 5566448 5281696
20:24:29 10388 8192000000 10749326304 11165855744 1812864784 18.119 99 42 84 0 1831446992 6960592 11621616
20:24:47 5924 8192000000 10749954304 11174469632 1837597808 18.321 100 35 68 1 1854495728 6898256 9999664
20:25:00 6513 8192000000 10768672352 11188060160 1843920080 18.373 100 26 51 1 1860430928 10046448 6464400
20:25:15 9728 8192000000 10776138624 11198722048 1851384224 18.433 100 34 68 1 1871729456 10641152 9704080
20:25:32 5704 8192000000 10786671024 11213291520 1855377760 18.466 100 23 46 1 1880008016 18775584 5854672
20:25:44 7935 8192000000 10772569024 11200307200 1861865040 18.518 100 28 55 3 1875586320 5877408 7843872
20:26:02 8713 8192000000 10786271024 11212738560 1868213760 18.570 100 29 55 2 1881224352 4989872 8020720
20:26:18 10235 8192000000 10789268320 11218944000 1869844800 18.583 100 18 36 2 1880158288 5070080 5243408
20:26:38 7548 8192000000 10799937888 11223937024 1876601280 18.638 100 28 57 2 1894724928 9916976 8206672
20:26:52 5514 8192000000 10781023680 11219877888 1875160400 18.626 100 17 34 1 1887048992 6607408 5281184
20:27:04 12320 8192000000 10806106720 11236732928 1890209296 18.747 100 24 49 2 1902906448 6189776 6507376
20:27:27 49261 8192000000 10833050096 11255119872 1901613568 18.839 100 25 48 1 1917983568 8420240 7949760
20:28:26 55933 8192000000 10834770720 11266924544 1911734640 18.921 100 26 52 1 1924578944 5161760 7682544
20:29:31 18201 8192000000 10852216960 11278782464 1929236016 19.061 100 47 94 1 1950543792 7250608 14057168
20:30:00 5192 8192000000 10874527840 11293356032 1935763648 19.113 100 59 118 0 1963261344 10162064 17335632
20:30:18 37227 8192000000 10870416544 11302600704 1942311776 19.165 100 52 104 0 1968624992 11328512 14984704
20:31:08 30939 8192000000 10876354864 11316297728 1944958752 19.186 100 34 68 0 1965504720 10252448 10293520
20:31:49 24880 8192000000 10899324736 11326513152 1964389344 19.341 100 56 111 3 1989872352 8913904 16569104
20:32:45 5169 8192000000 10898609328 11330514944 1948950944 19.218 99 48 94 3 1971647808 8938640 13758224
20:33:01 5124 8192000000 10912449760 11342163968 1976405456 19.436 100 60 118 1 2005758560 11607600 17745504
20:33:16 16424 8192000000 10922492544 11354284032 1986560640 19.517 100 61 121 1 2018736272 14120160 18055472
20:33:50 18723 8192000000 10926728032 11360903168 1991071136 19.552 100 50 100 0 2023657120 17675904 14910080
20:34:16 8099 8192000000 10939035312 11369119744 1996248048 19.593 100 56 112 1 2030387392 17476016 16663328
20:34:33 7448 8192000000 10938704560 11372761088 1997564656 19.604 100 50 100 0 2029129712 15948880 15616176
20:34:57 7595 8192000000 10937642000 11377803264 1999215584 19.617 100 43 86 1 2029731360 18067280 12448496
20:35:14 8579 8192000000 10936376560 11369840640 1980523328 19.469 99 59 118 0 2017303536 19383776 17396432
20:35:30 8701 8192000000 10940027184 11371872256 1996102432 19.592 100 59 116 2 2032896736 19617328 17176976
20:35:46 6549 8192000000 10950394208 11377954816 1998302288 19.609 100 60 118 0 2036168496 19518512 18347696
20:36:05 6909 8192000000 10959303392 11388022784 2000540464 19.627 100 56 112 1 2034746288 18945136 15260688
20:36:20 1839 8192000000 10959787392 11389861888 2012442912 19.721 100 72 146 2 2054315520 20783696 21088912
20:36:29 6105 8192000000 10964768336 11396173824 2010857360 19.708 100 66 132 0 2053665008 23101152 19706496
20:36:53 5154 8192000000 10971210624 11396145152 2009255120 19.696 100 68 136 0 2055074688 26334656 19484912
20:37:05 4894 8192000000 10970223856 11400658944 2013549840 19.729 100 66 130 2 2058973456 26492128 18931488
20:37:18 5629 8192000000 10978027584 11410182144 2019267728 19.774 100 62 122 3 2064811824 27046416 18497680
20:37:33 9452 8192000000 10980111424 11410776064 2003065728 19.647 99 55 110 1 2047316304 27124912 17125664
20:37:52 2756 8192000000 10946516576 11374374912 1984047952 19.497 99 72 144 0 2033081120 27283888 21749280
20:38:05 7901 8192000000 10964684160 11391963136 2002697152 19.644 100 62 124 2 2049868272 28341248 18829872
20:38:23 2634 8192000000 10973751760 11401449472 2010450704 19.705 100 62 121 0 2056642912 27964032 18228176
20:38:34 6996 8192000000 10981464032 11412369408 2014802640 19.739 100 64 128 0 2068053760 33670480 19580640
20:38:53 5565 8192000000 10984559632 11416956928 2019924704 19.780 100 64 127 1 2072883472 34140608 18818160
20:39:08 3788 8192000000 10988352768 11421687808 2025003568 19.819 100 55 105 2 2068775024 27239520 16531936
20:39:21 5929 8192000000 10981092144 11417862144 2021293952 19.790 100 59 117 0 2067224368 27090464 18839952
20:39:47 5834 8192000000 11008159968 11434708992 2032366544 19.877 100 66 130 1 2085163776 32413984 20383248
20:40:00 9746 8192000000 10981900000 11417616384 2018114048 19.765 100 60 120 1 2069311232 32061952 19135232
20:40:18 12537 8192000000 10977882752 11422855168 2023208240 19.805 100 58 114 3 2073554288 32125424 18220624
20:40:38 5603 8192000000 11000315056 11436560384 2038889936 19.928 100 61 121 1 2086306736 29282512 18134288
20:40:51 3808 8192000000 11002811008 11431530496 2022073888 19.796 99 71 140 2 2072557808 29727776 20756144
20:41:06 5097 8192000000 11000971184 11435573248 2034438176 19.893 100 57 114 2 2082607168 30874848 17294144
20:41:19 8381 8192000000 11002779584 11435646976 2036107984 19.906 100 64 126 0 2086375744 30844224 19423536
20:41:43 2911 8192000000 11000803216 11438776320 2039863952 19.936 100 61 122 2 2090841600 31704640 19273008
20:41:54 3257 8192000000 10989998272 11415089152 2015103888 19.742 99 80 160 2 2072034768 32545264 24385616
20:42:06 2740 8192000000 10999113328 11430277120 2025999296 19.827 100 68 136 1 2080291696 33437392 20855008
20:42:18 2049 8192000000 11004709024 11428315136 2029225008 19.853 100 82 165 1 2087630016 33888224 24516784
20:42:28 10119 8192000000 10993023712 11425456128 2008650304 19.691 99 68 136 0 2065553568 35440480 21462784
20:42:44 3242 8192000000 10988518464 11424010240 2021468576 19.792 100 63 126 1 2076633216 35639296 19525344
20:42:56 5945 8192000000 10989271472 11426148352 2003694192 19.652 99 60 119 1 2059200592 35670896 19835504
20:43:10 5055 8192000000 10990831712 11424505856 2021833248 19.795 100 70 139 0 2078699808 34963568 21902992
20:43:24 3416 8192000000 10986583808 11419992064 2016181648 19.750 100 66 130 1 2072923728 36298768 20443312
20:43:36 4208 8192000000 10976631936 11406393344 2000104080 19.624 99 67 132 2 2058281840 36775296 21402464
20:43:54 2080 8192000000 10984299632 11412381696 2008267600 19.688 100 72 141 2 2070281680 39424240 22589840
20:44:05 1459 8192000000 10996924416 11415064576 2010502272 19.705 100 84 169 0 2077639296 40664816 26472208
20:44:20 4189 8192000000 10980421424 11415252992 2007574320 19.682 100 65 130 1 2069865840 41371648 20919872
20:44:35 2458 8192000000 10976549808 11406139392 2000612448 19.628 100 68 136 1 2063717376 41804384 21300544
20:44:45 2945 8192000000 10995387984 11417296896 2009269712 19.696 100 66 131 0 2070458512 40625264 20563536
20:44:56 5858 8192000000 10943580240 11369824256 1971608160 19.398 98 78 155 1 2035823520 39874224 24341136
20:45:14 5065 8192000000 10961250624 11388223488 1981045648 19.473 100 71 140 2 2044677296 41324176 22307472
20:45:35 3987 8192000000 10972477152 11402670080 1990314816 19.546 100 66 130 0 2057426272 46727488 20383968
20:45:47 1471 8192000000 10985491072 11397730304 1990677248 19.549 100 74 148 1 2058438816 43673712 24087856
20:45:56 1387 8192000000 10990629840 11403399168 1996639888 19.596 100 94 191 2 2067941840 42799712 28502240
20:46:04 1458 8192000000 10999219552 11416477696 2007591568 19.683 100 88 176 0 2075324048 40746368 26986112
20:46:12 3490 8192000000 10974851136 11403599872 2001675088 19.636 100 63 127 1 2058892976 38126016 19091872
20:46:29 4710 8192000000 10975691120 11407028224 2002232720 19.640 100 57 113 3 2059295648 38549088 18513840
20:46:42 3735 8192000000 10988725376 11417481216 2006859808 19.677 100 72 145 1 2070473616 40238048 23375760
20:46:54 11327 8192000000 10953384448 11407077376 1969017392 19.378 98 45 90 0 2028168160 44013904 15136864
20:47:21 12056 8192000000 10939318080 11381952512 1947613120 19.207 98 40 77 1 2003660464 43394304 12653040
20:47:44 7077 8192000000 10935637344 11365179392 1950417136 19.230 100 51 102 1 2014811696 47334704 17059856
20:47:57 8692 8192000000 10909540608 11346255872 1917701760 18.968 98 38 76 1 1977855360 47188272 12965328
20:48:21 5670 8192000000 10913890960 11346288640 1931705792 19.081 100 50 100 1 1995691312 46860704 17124816
20:48:35 1547 8192000000 10934287152 11349540864 1941827200 19.161 100 78 150 2 2017089440 51260336 24001904
20:48:45 2610 8192000000 10931628128 11351834624 1943824304 19.177 100 75 151 1 2017374640 49933312 23617024
20:49:00 8286 8192000000 10909275056 11339804672 1886237520 18.715 97 45 90 0 1954878960 53821248 14820192
20:49:16 13385 8192000000 10913164032 11341524992 1924059840 19.019 100 35 69 1 1990495008 53733600 12701568
20:49:36 5209 8192000000 10915092800 11348275200 1928914048 19.058 100 49 98 2 2004318752 58562864 16841840
20:49:53 12797 8192000000 10922127264 11360559104 1946546960 19.199 100 44 88 0 2014986736 52874208 15565568
20:50:34 13169 8192000000 10904815456 11351633920 1903957952 18.858 99 29 57 1 1972008224 57531536 10518736
20:50:56 16928 8192000000 10899041056 11340496896 1908469936 18.894 99 44 88 0 1971539632 47858144 15211552
20:51:30 23671 8192000000 10894908592 11336183808 1925928224 19.034 100 28 57 2 1980367920 44462608 9977088
20:52:00 31456 8192000000 10874938208 11332628480 1916444512 18.958 99 16 32 0 1956072560 33561280 6066768
20:53:22 15768 8192000000 10890853792 11339964416 1938581632 19.135 100 31 60 4 1975278784 26545664 10151488
20:53:50 21667 8192000000 10866046896 11331235840 1928597440 19.056 100 14 28 0 1966521136 32795040 5128656
20:54:23 33488 8192000000 10856593664 11316387840 1899742960 18.824 98 21 41 2 1919518880 13720592 6055328
20:55:05 35609 8192000000 10836257296 11296235520 1866819712 18.559 97 13 26 2 1882421792 11534224 4067856
20:55:54 79958 8192000000 10860711856 11298111488 1871561840 18.597 97 28 52 4 1887479568 7432160 8485568
20:57:20 39311 8192000000 10856590224 11303505920 1904813600 18.865 98 32 65 2 1921536480 7882256 8840624
20:58:07 77770 8192000000 10878870112 11327344640 1898844640 18.817 98 17 34 1 1915025152 11485312 4695200
20:59:31 117741 8192000000 10865795856 11319021568 1891077328 18.754 97 8 16 1 1910236512 17308016 1851168
21:01:52 121337 8192000000 10878822784 11330367488 1877524176 18.645 96 9 18 1 1892761312 13015520 2221616
21:04:00 20125 8192000000 10906689248 11353583616 1965805920 19.352 100 30 60 1 1984159456 9748992 8604544
21:04:29 51150 8192000000 10932579856 11390070784 1979657088 19.462 100 19 38 1 1999205168 13734128 5813952
21:05:29 99493 8192000000 10895985328 11350908928 1940861248 19.154 98 15 29 2 1975389744 29819936 4708560
21:07:51 79170 8192000000 10915566160 11364700160 1959270912 19.300 99 40 79 1 1992003200 21155600 11576688
21:09:20 48856 8192000000 10932842672 11377074176 1986531184 19.516 100 39 78 0 2008022848 10822688 10668976
21:12:07 26746 8192000000 10942179360 11382943744 1990701952 19.549 100 24 48 3 2007710976 10248336 6760688
21:12:44 32161 8192000000 10921741552 11387248640 1995665104 19.589 100 13 26 1 2010190032 10830256 3694672
21:13:37 44819 8192000000 10931346528 11400204288 2002914720 19.646 100 24 48 1 2022457216 12388032 7154464
21:14:34 50799 8192000000 10924755712 11398803456 1966752992 19.360 98 35 69 0 1993172576 15890064 10529520
21:15:32 41424 8192000000 10923696272 11413164032 1998342720 19.610 100 10 20 0 2017335200 16259056 2733424
21:17:15 74928 8192000000 10919969152 11407065088 2000059776 19.623 100 15 31 0 2017516784 13025152 4431856
21:18:40 76070 8192000000 10908558896 11382710272 1932464048 19.087 96 17 34 0 1947439296 10057968 4917280
21:20:36 84889 8192000000 10916756336 11407486976 1979898000 19.464 99 18 36 0 2003879424 18177760 5803664
21:22:16 39490 8192000000 10886282960 11356258304 1949706864 19.224 98 15 30 0 1962273392 8783888 3782640
21:23:02 52684 8192000000 10859309584 11333926912 1931869136 19.082 98 10 20 0 1940966416 6697904 2399376
21:24:14 56604 8192000000 10873420192 11355406336 1938977456 19.139 98 20 40 0 1951558880 7328368 5253056
21:25:18 43829 8192000000 10877256464 11361853440 1966617312 19.359 100 5 10 0 1975109824 7328256 1164256
21:26:14 31107 8192000000 10893717888 11378450432 1974905808 19.424 100 8 16 1 1989213376 12003952 2303616
21:26:52 48649 8192000000 10889050624 11368091648 1939169744 19.140 98 8 16 0 1953707168 12197280 2340144
21:27:47 31010 8192000000 10889035024 11368976384 1949900640 19.226 99 14 28 1 1968450448 14467248 4082560
21:28:25 21547 8192000000 10885057936 11351502848 1940888768 19.154 98 24 48 2 1958720000 11523488 6307744
21:28:53 25745 8192000000 10883218496 11352035328 1931719824 19.081 98 21 42 0 1947241536 9522352 5999360
21:29:25 60298 8192000000 10891569328 11369938944 1930250704 19.069 98 22 44 0 1951181504 14886560 6044240
21:30:48 64287 8192000000 10854283184 11322114048 1799553328 18.010 92 14 28 2 1820056928 16512048 3991552
21:31:58 27549 8192000000 10848752736 11304108032 1846637616 18.395 95 37 74 0 1866665152 9415552 10611984
21:32:34 29955 8192000000 10841717008 11294941184 1880358832 18.668 98 36 70 2 1903311680 12483808 10469040
21:33:13 38218 8192000000 10843449264 11309871104 1876879376 18.640 98 27 54 0 1900059344 15895584 7284384
21:33:58 17821 8192000000 10859374960 11310534656 1891732128 18.760 98 37 75 0 1911086512 8766592 10587792
21:34:25 22324 8192000000 10855008752 11299098624 1873060960 18.609 98 51 102 1 1900721456 12823968 14836528
21:35:18 103324 8192000000 10850751712 11302805504 1825682768 18.224 95 17 34 0 1838593296 8862976 4047552
21:37:10 23701 8192000000 10850375808 11304599552 1848743680 18.412 96 31 62 2 1868333648 10785536 8804432
21:37:41 49086 8192000000 10840569008 11313807360 1892555312 18.766 99 17 34 2 1911997232 14698032 4743888
21:38:36 50175 8192000000 10854836176 11320819712 1882500144 18.685 98 25 50 1 1905255728 15644896 7110688
21:39:33 88439 8192000000 10848845312 11329163264 1888097792 18.730 98 15 30 0 1904836864 12010752 4728320
21:41:08 55229 8192000000 10875864848 11333464064 1892686528 18.767 98 25 50 3 1911588528 11642800 7259200
21:42:09 101123 8192000000 10866306320 11333423104 1912352352 18.926 99 22 44 0 1931951824 13562128 6037344
21:43:59 53526 8192000000 10878210208 11350646784 1943632528 19.176 100 26 52 0 1972006432 21073008 7300896
21:44:59 11384 8192000000 10870394816 11333664768 1923833296 19.018 99 24 47 1 1947701232 17314256 6553680
21:45:18 59998 8192000000 10855760896 11329458176 1914212576 18.940 99 32 64 0 1937522672 14204480 9105616
21:46:31 78676 8192000000 10843062016 11320668160 1872252240 18.602 97 10 20 0 1884996880 10185248 2559392
21:47:56 45613 8192000000 10852676848 11331948544 1922809296 19.009 100 13 26 0 1938189216 11484064 3895856
21:48:49 48139 8192000000 10848691888 11329007616 1929516128 19.063 100 6 12 0 1944278224 13159376 1602720
21:49:49 46235 8192000000 10868033056 11337871360 1936851216 19.122 100 10 20 0 1954002016 14780672 2370128
21:50:45 46561 8192000000 10865731360 11336249344 1923404496 19.014 99 17 33 0 1940341392 11199344 5737552
21:51:38 53248 8192000000 10878412848 11336257536 1906504176 18.879 98 15 30 0 1922162272 11174704 4483392
21:52:48 32828 8192000000 10871341440 11339673600 1928557440 19.055 99 21 42 0 1945613920 10600592 6455888
21:53:27 71472 8192000000 10878313120 11355512832 1931353392 19.078 99 12 24 0 1946018944 11209888 3455664
21:54:54 59323 8192000000 10894873824 11362529280 1941032192 19.155 99 21 42 0 1963001776 15680432 6289152
21:56:00 62337 8192000000 10900634848 11371900928 1947108928 19.203 99 17 34 2 1971077328 18817776 5150624
21:57:17 38989 8192000000 10896265616 11375763456 1947450592 19.206 99 14 28 1 1971087936 19696848 3940496
21:58:02 53855 8192000000 10894786272 11353563136 1939454624 19.142 99 24 49 1 1955997392 10288784 6253984
21:59:20 67830 8192000000 10899699440 11376205824 1953490704 19.254 99 25 50 1 1972767520 12566768 6710048
22:00:34 85828 8192000000 10900520016 11378368512 1938766624 19.137 98 21 42 1 1958264272 14682272 4815376
22:02:11 43421 8192000000 10923566064 11379474432 1942992304 19.171 98 33 66 1 1967355840 15216448 9147088
22:03:04 50128 8192000000 10912469264 11390746624 1956781568 19.280 99 22 44 2 1975485168 12744800 5958800
22:04:00 127649 8192000000 10928151616 11395551232 1947038368 19.203 98 16 32 0 1971942640 20605984 4298288
22:06:22 106113 8192000000 10885876512 11352850432 1922361280 19.006 97 19 38 1 1938558672 10877456 5319936
22:08:24 28381 8192000000 10901564368 11361685504 1953300064 19.253 99 32 65 1 1974391296 12493296 8597936
22:08:59 43652 8192000000 10902462624 11378622464 1979778624 19.463 100 35 70 1 2000234880 9966624 10489632
22:09:50 71969 8192000000 10877918704 11372068864 1950706400 19.232 99 8 16 0 1964618256 11464272 2447584
22:11:09 26053 8192000000 10865756096 11362066432 1924323472 19.021 98 5 11 1 1937140624 11255472 1561680
22:11:41 5503 8192000000 10869313248 11364827136 1952003808 19.242 100 3 6 0 1964354912 11613088 738016
22:12:07 71454 8192000000 10882617104 11361923072 1934161648 19.100 98 22 46 1 1950980944 10604128 6215168
22:13:32 89700 8192000000 10865137824 11352240128 1924565600 19.023 98 20 41 0 1939092960 9401920 5125440
22:15:11 63465 8192000000 10869848976 11353231360 1892816800 18.768 97 8 16 0 1909570960 14628336 2125824
22:16:20 53613 8192000000 10835423888 11322396672 1866666912 18.557 96 12 24 0 1886397504 16743216 2987376
22:17:22 67487 8192000000 10855970784 11315568640 1826669776 18.232 94 29 58 3 1847604720 12609632 8325312
22:18:40 54049 8192000000 10867081152 11329101824 1861334096 18.514 96 35 70 0 1891704224 20187152 10182976
22:19:41 68373 8192000000 10838694560 11310575616 1886343440 18.716 98 23 46 1 1909794448 16671264 6779744
22:21:39 67402 8192000000 10822404624 11284156416 1862091568 18.520 98 14 28 0 1882188864 15849360 4247936
22:22:55 39834 8192000000 10840645632 11303505920 1866067680 18.552 98 32 64 1 1887378336 12115792 9194864
22:23:45 77272 8192000000 10845533616 11310178304 1867787424 18.566 98 22 44 0 1887485760 13357232 6341104
22:25:12 70160 8192000000 10856377408 11327827968 1890724832 18.752 99 19 38 1 1912140192 16149888 5265472
22:26:33 34074 8192000000 10853355264 11302666240 1865589120 18.549 97 36 72 1 1885375808 9827264 9959424
22:27:14 30566 8192000000 9784074304 10134274048 909214064 9.990 48 25 50 1 922444448 6479392 6750992

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 09-06-2021 22:28:27 to 09-06-2021 22:28:58.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 168 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 09-06-2021 22:28:59 to 09-06-2021 22:29:01.

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          244467
MON$OLDEST_ACTIVE               245963
MON$OLDEST_SNAPSHOT             245963
MON$NEXT_TRANSACTION            245963
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                       2048032
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.33472 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33472 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33472 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33472 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 ---
:24: 
:25: mscs-test-161.budzdorov.ru    Wed Jun  9 22:27:47 2021
:26:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:27: 
:28: 
:29: mscs-test-161.budzdorov.ru    Wed Jun  9 22:27:47 2021
:30:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:31: 
:32: 
:33: mscs-test-161.budzdorov.ru    Wed Jun  9 22:27:47 2021
:34:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:35: 
:36: 
:37: mscs-test-161.budzdorov.ru    Wed Jun  9 22:27:47 2021
:38:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:39: 
:40: 
:41: mscs-test-161.budzdorov.ru    Wed Jun  9 22:27:50 2021
:42:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:43: 
:44: 
:45: mscs-test-161.budzdorov.ru    Wed Jun  9 22:27:50 2021
:46:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:47: 
:48: 
:49: mscs-test-161.budzdorov.ru    Wed Jun  9 22:27:50 2021
:50:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:51: 
--- end of diff output ---

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

09.06.21 22:29:02. 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-09 22:29:05 No severe PSQL-related problems occured
09.06.21 22:29:06. End of report.