Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 19.03.2021 01:29
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 df9f488d08424df294c459d6c283e9c3
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-03-04 16:07
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 4794.26
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 17334780 kB
MemAvailable 31585628 kB
Buffers 0 kB
Cached 14367276 kB
SwapCached 0 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-03-19 01:27:21
DTS_END                         2021-03-19 01:27:21.0360
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/57670
TRN_ID                          241832
ATT_ID                          654
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: 9584.23 23639 1150107
customer order: creation 171.13 381 20535
customer order: refuse 14.94 333 1793
order to supplier: creation 45.92 1264 5510
order to supplier: removal 3.36 105657 403
invoice (draft): creation 46.00 3459 5520
invoice (draft): removal 55.70 734 6684
invoice accept: apply 42.23 17666 5067
invoice accept: cancel 50.41 772 6049
customer reserve: creation 3912.83 175 469540
customer reserve: removal 4945.76 57 593491
realization accept: apply 82.70 214 9924
realization accept: cancel 83.25 121 9990
payment from customer: creation 58.22 194 6986
payment from customer: removal 5.76 135 691
payment to supplier: creation 50.62 194 6074
payment to supplier: removal 3.03 65 363
service: total inventory turnovers 4.78 1042 574
service: total monetary turnovers 6.73 24 807
service: aggregate perf. data 0.85 21358 102
service: refresh index statistics 0.03 318938 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 19-03-2021 01:29:37 to 19-03-2021 01:29:39.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3918
TEST_TIME 2 2535
TEST_TIME 3 2840
TEST_TIME 4 4756
TEST_TIME 5 4961
TEST_TIME 6 5014
TEST_TIME 7 5181
TEST_TIME 8 5152
TEST_TIME 9 5119
TEST_TIME 10 5378
TEST_TIME 11 5452
TEST_TIME 12 6074
TEST_TIME 13 5992
TEST_TIME 14 5953
TEST_TIME 15 6181
TEST_TIME 16 6488
TEST_TIME 17 6598
TEST_TIME 18 6714
TEST_TIME 19 7011
TEST_TIME 20 7426
TEST_TIME 21 7764
TEST_TIME 22 8020
TEST_TIME 23 8282
TEST_TIME 24 8879
TEST_TIME 25 8976
TEST_TIME 26 9322
TEST_TIME 27 10552
TEST_TIME 28 10367
TEST_TIME 29 10231
TEST_TIME 30 10080
TEST_TIME 31 10222
TEST_TIME 32 10406
TEST_TIME 33 10297
TEST_TIME 34 10510
TEST_TIME 35 10476
TEST_TIME 36 10403
TEST_TIME 37 10375
TEST_TIME 38 10241
TEST_TIME 39 10029
TEST_TIME 40 10059
TEST_TIME 41 10117
TEST_TIME 42 10051
TEST_TIME 43 9934
TEST_TIME 44 9853
TEST_TIME 45 9877
TEST_TIME 46 9874
TEST_TIME 47 9981
TEST_TIME 48 9886
TEST_TIME 49 9768
TEST_TIME 50 9781
TEST_TIME 51 9851
TEST_TIME 52 9809
TEST_TIME 53 9830
TEST_TIME 54 9809
TEST_TIME 55 9783
TEST_TIME 56 9840
TEST_TIME 57 9963
TEST_TIME 58 10019
TEST_TIME 59 10010
TEST_TIME 60 10089
TEST_TIME 61 10046
TEST_TIME 62 10086
TEST_TIME 63 10098
TEST_TIME 64 10272
TEST_TIME 65 10286
TEST_TIME 66 10156
TEST_TIME 67 10138
TEST_TIME 68 10059
TEST_TIME 69 10036
TEST_TIME 70 9988
TEST_TIME 71 9908
TEST_TIME 72 9889
TEST_TIME 73 9848
TEST_TIME 74 9789
TEST_TIME 75 9784
TEST_TIME 76 9816
TEST_TIME 77 9828
TEST_TIME 78 9888
TEST_TIME 79 9822
TEST_TIME 80 9775
TEST_TIME 81 9839
TEST_TIME 82 9831
TEST_TIME 83 9813
TEST_TIME 84 9798
TEST_TIME 85 9798
TEST_TIME 86 9815
TEST_TIME 87 9911
TEST_TIME 88 9873
TEST_TIME 89 9873
TEST_TIME 90 9911
TEST_TIME 91 9886
TEST_TIME 92 9803
TEST_TIME 93 9775
TEST_TIME 94 9689
TEST_TIME 95 9769
TEST_TIME 96 9765
TEST_TIME 97 9737
TEST_TIME 98 9708
TEST_TIME 99 9639
TEST_TIME 100 9585
TEST_TIME 101 9633
TEST_TIME 102 9608
TEST_TIME 103 9540
TEST_TIME 104 9577
TEST_TIME 105 9647
TEST_TIME 106 9630
TEST_TIME 107 9628
TEST_TIME 108 9602
TEST_TIME 109 9634
TEST_TIME 110 9734
TEST_TIME 111 9715
TEST_TIME 112 9713
TEST_TIME 113 9716
TEST_TIME 114 9708
TEST_TIME 115 9731
TEST_TIME 116 9721
TEST_TIME 117 9678
TEST_TIME 118 9647
TEST_TIME 119 9608
TEST_TIME 120 9584

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 19-03-2021 01:29:40 to 19-03-2021 01:29:44.

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 1583502 1583502 0 0.00 0 34747 7 0 0
doc_list_biud 1583502 1583502 0 0.00 0 24986 27 0 0
sp_add_invoice_to_stock 5281 5067 214 4.05 29 210071 17666 0 214
sp_cancel_adding_invoice 6049 6049 0 0.00 5 66418 773 0 0
sp_cancel_client_order 1793 1793 0 0.00 4 12665 333 0 0
sp_cancel_customer_reserve 593491 593491 0 0.00 1 23923 57 0 0
sp_cancel_pay_from_customer 691 691 0 0.00 3 12637 136 0 0
sp_cancel_pay_to_supplier 363 363 0 0.00 3 2449 65 0 0
sp_cancel_supplier_invoice 6700 6684 16 0.23 2 24994 735 0 16
sp_cancel_supplier_order 403 403 0 0.00 8 989197 105658 0 0
sp_cancel_write_off 9990 9990 0 0.00 1 17883 121 0 0
sp_client_order 20535 20535 0 0.00 3 35268 381 0 0
sp_customer_reserve 469540 469540 0 0.00 0 41622 175 0 0
sp_fill_shopping_cart 31565 31565 0 0.00 1 18475 35 0 0
sp_fill_shopping_cart_clo_res 469539 469539 0 0.00 0 14263 13 0 0
sp_get_clo_for_invoice 5066 5066 0 0.00 0 23788 291 0 0
sp_kill_cost_storno 17093 17093 0 0.00 0 12621 59 0 0
sp_kill_qstorno_ret_qs2qd 1204059 1204059 0 0.00 0 24983 31 0 0
sp_kill_qty_storno 633400 633400 0 0.00 0 24985 66 0 0
sp_lock_selected_doc 20794 20794 0 0.00 0 8990 7 0 0
sp_make_cost_storno 28050 28050 0 0.00 0 22009 71 0 0
sp_multiply_rows_for_pdistr 28050 28050 0 0.00 0 15975 37 0 0
sp_multiply_rows_for_qdistr 20535 20535 0 0.00 0 14690 151 0 0
sp_pay_from_customer 6986 6986 0 0.00 4 35364 195 0 0
sp_pay_to_supplier 6074 6074 0 0.00 5 33340 194 0 0
sp_payment_common 13060 13060 0 0.00 1 23045 54 0 0
sp_qd_handle_on_cancel_clo 1793 1793 0 0.00 0 12651 299 0 0
sp_qd_handle_on_invoice_upd_sts 11115 11115 0 0.00 0 16471 303 0 0
sp_qd_handle_on_reserve_upd_sts 9924 9924 0 0.00 0 16001 70 0 0
sp_reserve_write_off 9924 9924 0 0.00 6 18178 214 0 0
sp_supplier_invoice 5520 5520 0 0.00 6 115385 3459 0 0
sp_supplier_order 5510 5510 0 0.00 5 38142 1264 0 0
srv_aggregate_perf_data 103 102 1 0.97 2614 363274 21359 0 1
srv_fill_mon_cache_memory 149 149 0 0.00 1572 141639 34598 0 0
srv_find_qd_qs_mism 1101394 1101394 0 0.00 0 34746 5 0 0
srv_make_invnt_saldo 574 574 0 0.00 43 34665 1042 0 0
srv_make_money_saldo 807 807 0 0.00 1 2856 24 0 0
srv_recalc_idx_stat 4 4 0 0.00 124366 417573 318939 0 0
t$perf-abend:sp_add_invoice_to_stock 214 214 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 16 16 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 5067 5067 0 0.00 0 31684 177 0 0
t$perf-norm:sp_cancel_adding_invoice 437 437 0 0.00 0 3781 103 0 0
t$perf-norm:sp_cancel_client_order 1793 1793 0 0.00 0 14067 35 0 0
t$perf-norm:sp_cancel_customer_reserve 681 681 0 0.00 0 1090 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 691 691 0 0.00 0 5187 15 0 0
t$perf-norm:sp_cancel_pay_to_supplier 363 363 0 0.00 0 12719 42 0 0
t$perf-norm:sp_cancel_supplier_invoice 399 399 0 0.00 0 2308 28 0 0
t$perf-norm:sp_cancel_supplier_order 403 403 0 0.00 0 30006 1651 0 0
t$perf-norm:sp_cancel_write_off 1037 1037 0 0.00 0 8408 13 0 0
t$perf-norm:sp_client_order 20535 20535 0 0.00 0 14252 20 0 0
t$perf-norm:sp_customer_reserve 1022 1022 0 0.00 0 6251 14 0 0
t$perf-norm:sp_pay_from_customer 6986 6986 0 0.00 0 5950 12 0 0
t$perf-norm:sp_pay_to_supplier 6074 6074 0 0.00 0 14267 20 0 0
t$perf-norm:sp_reserve_write_off 9924 9924 0 0.00 0 12540 13 0 0
t$perf-norm:sp_supplier_invoice 5520 5520 0 0.00 0 11996 19 0 0
t$perf-norm:sp_supplier_order 5510 5510 0 0.00 0 13174 21 0 0
t$perf-norm:srv_aggregate_perf_data 102 102 0 0.00 0 101 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 149 149 0 0.00 0 551 8 0 0
t$perf-norm:srv_make_invnt_saldo 574 574 0 0.00 0 922 15 0 0
t$perf-norm:srv_make_money_saldo 807 807 0 0.00 0 3776 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 3 0 0
v_add_invoice_to_stock 10558 10130 428 4.05 0 10491 23 0 428
v_all_customers 37424 37424 0 0.00 0 21 1 0 0
v_all_suppliers 31118 31118 0 0.00 0 115 1 0 0
v_all_wares 41070 41070 0 0.00 0 208 1 0 0
v_cancel_adding_invoice 874 874 0 0.00 0 2640 13 0 0
v_cancel_client_order 3586 3586 0 0.00 0 4875 8 0 0
v_cancel_customer_prepayment 1382 1382 0 0.00 0 12139 16 0 0
v_cancel_customer_reserve 1362 1362 0 0.00 0 634 3 0 0
v_cancel_payment_to_supplier 726 726 0 0.00 0 344 4 0 0
v_cancel_supplier_invoice 830 798 32 3.85 0 500 14 0 32
v_cancel_supplier_order 806 806 0 0.00 0 608 5 0 0
v_cancel_write_off 2074 2074 0 0.00 0 9595 19 0 0
v_max_id_clo_ord 5510 5510 0 0.00 0 949 1 0 0
v_max_id_clo_res 1022 1022 0 0.00 0 1200 7 0 0
v_max_id_ord_sup 5520 5520 0 0.00 0 7079 6 0 0
v_max_non_paid_invoice 1545 1545 0 0.00 0 3029 5 0 0
v_max_non_paid_realizn 3726 3726 0 0.00 0 6158 9 0 0
v_min_id_clo_ord 5510 5510 0 0.00 0 1779 5 0 0
v_min_id_clo_res 1022 1022 0 0.00 0 3225 7 0 0
v_min_id_ord_sup 5520 5520 0 0.00 0 7235 7 0 0
v_min_non_paid_invoice 6074 6074 0 0.00 0 12613 33 0 0
v_min_non_paid_realizn 6986 6986 0 0.00 0 21182 42 0 0
v_our_firm 10166 10166 0 0.00 0 18 1 0 0
v_reserve_write_off 19848 19848 0 0.00 0 10866 8 0 0
x_lock_depdocs_on_canc_invoice 12334 12334 0 0.00 0 28398 109 0 0
x_lock_depdocs_on_canc_sup_ord 403 403 0 0.00 0 15709 397 0 0
x_make_qstorno_1000_1200 5510 5510 0 0.00 1 38133 1193 0 0
x_make_qstorno_1200_2000 5520 5520 0 0.00 3 115334 3334 0 0
x_make_qstorno_2100_3300 469540 469540 0 0.00 0 38962 160 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 19-03-2021 01:29:45 to 19-03-2021 01:29:49.

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
22:57:24 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:31 19910 8192000000 10251498752 10563022848 867657424 9.577 67 57 116 0 888403648 2366320 18379904
22:57:58 37851 8192000000 10376751952 10696859648 1414758864 14.726 100 83 166 1 1446296352 5672368 25865120
22:58:42 30239 8192000000 10422478336 10749112320 1459971488 15.126 100 90 180 1 1496299280 7386752 28941040
22:59:25 29232 8192000000 10442215680 10775326720 1494465808 15.428 100 92 184 1 1533965056 8846496 30652752
23:00:02 20097 8192000000 10448620688 10785001472 1506245248 15.531 100 88 176 1 1544006544 9445920 28315376
23:00:37 26267 8192000000 10468609312 10807853056 1527019712 15.711 100 87 175 0 1564926960 10285520 27621728
23:01:18 27889 8192000000 10505614576 10853388288 1560526496 16.001 100 90 180 0 1599219648 11108432 27584720
23:01:55 13829 8192000000 10532745664 10882306048 1584336192 16.205 100 82 164 0 1621491136 11533168 25621776
23:02:25 12307 8192000000 10555227888 10907385856 1608718976 16.414 100 81 160 1 1644582656 11579728 24283952
23:02:47 16646 8192000000 10571907600 10929897472 1628195616 16.580 100 79 158 3 1664290256 12174064 23920576
23:03:11 10147 8192000000 10582763216 10943913984 1645958368 16.730 100 80 160 0 1682451264 12434800 24058096
23:03:29 13040 8192000000 10605866464 10967478272 1660994848 16.857 100 87 174 0 1700659152 13451888 26212416
23:03:53 13216 8192000000 10609277264 10979127296 1671920544 16.949 100 75 150 0 1706826704 12906688 21999472
23:04:15 9066 8192000000 10629536464 10997268480 1689840112 17.100 100 74 148 1 1724762768 13296640 21626016
23:04:32 8209 8192000000 10635795280 11009196032 1698439792 17.172 100 70 140 1 1731824320 13342336 20042192
23:04:47 5873 8192000000 10649807024 11026071552 1719671184 17.349 100 80 161 0 1755494736 12320944 23502608
23:05:01 7297 8192000000 10668262976 11046662144 1731799872 17.450 100 72 143 2 1764290672 11453952 21036848
23:05:21 5590 8192000000 10694602656 11070709760 1753686928 17.632 100 79 158 1 1789081136 11996256 23397952
23:05:34 5686 8192000000 10691342416 11075624960 1761497920 17.697 100 67 134 1 1792307584 12118704 18690960
23:05:47 7684 8192000000 10700606016 11089305600 1767905360 17.750 100 70 140 1 1799277440 11905200 19466880
23:06:01 4248 8192000000 10727210640 11105165312 1781976800 17.866 100 73 143 0 1813582048 11796992 19808256
23:06:13 2902 8192000000 10743489504 11124920320 1795859056 17.980 100 80 160 0 1835459088 17253872 22346160
23:06:23 3272 8192000000 10740129664 11123511296 1801446432 18.026 100 80 161 0 1837603824 13722768 22434624
23:06:33 1797 8192000000 10751487968 11136753664 1814408784 18.132 100 87 175 1 1852681360 13528544 24744032
23:06:42 3263 8192000000 10765399632 11150368768 1824132400 18.211 100 92 184 2 1863497200 13976624 25388176
23:06:52 2498 8192000000 10770853552 11154812928 1828667392 18.248 100 85 171 0 1866616656 13886256 24063008
23:07:01 1710 8192000000 10768918000 11157389312 1832182528 18.277 100 85 169 1 1869567920 13776816 23608576
23:07:10 2310 8192000000 10780087184 11164209152 1838560544 18.329 100 94 186 3 1878619616 13613520 26445552
23:07:18 2715 8192000000 10793114656 11178070016 1844911552 18.381 100 90 180 2 1884596400 15100288 24584560
23:07:27 1847 8192000000 10796875488 11184545792 1852746032 18.444 100 92 182 3 1892925600 14858704 25320864
23:07:36 1865 8192000000 10802476640 11187130368 1854564512 18.459 100 91 182 1 1894615664 14380624 25670528
23:07:44 1405 8192000000 10806159440 11193483264 1860079376 18.504 100 93 186 0 1901145008 15363072 25702560
23:07:52 1744 8192000000 10809888176 11196235776 1866291648 18.554 100 94 190 0 1907753248 13867088 27594512
23:08:00 2163 8192000000 10813593488 11199606784 1869697680 18.582 100 92 183 1 1908668160 12802928 26167552
23:08:09 2253 8192000000 10814797856 11201777664 1872388112 18.604 100 95 185 0 1910684528 12325776 25970640
23:08:17 1686 8192000000 10825580672 11212611584 1879517024 18.661 100 93 188 3 1918240816 12223648 26500144
23:08:25 40088 8192000000 10795490528 11205263360 1874274176 18.619 100 61 122 0 1900266432 7933360 18058896
23:09:12 18333 8192000000 10793035744 11206270976 1872518032 18.605 100 41 82 0 1891613584 7513504 11582048
23:09:37 6312 8192000000 10782589728 11207983104 1873205760 18.610 100 38 76 1 1893115248 9379168 10530320
23:09:50 4159 8192000000 10799307728 11215183872 1884229936 18.699 100 51 102 2 1905964336 7611024 14123376
23:10:03 8073 8192000000 10784261952 11209261056 1878362672 18.652 100 28 56 2 1892812896 7157088 7293136
23:10:18 8674 8192000000 10779463152 11209306112 1874659360 18.622 100 19 39 0 1885645952 5937632 5048960
23:10:35 4992 8192000000 10785428560 11211988992 1878895392 18.656 100 27 54 1 1893453680 6889584 7668704
23:10:51 6930 8192000000 10790458544 11218968576 1879806000 18.664 100 25 50 0 1897421024 11047392 6567632
23:11:05 10978 8192000000 10785557104 11213127680 1883010832 18.689 100 12 24 0 1891621040 5560208 3050000
23:11:22 9926 8192000000 10797926144 11225571328 1883492496 18.693 100 20 40 0 1895171712 5494832 6184384
23:11:38 6091 8192000000 10793857520 11223265280 1887610368 18.727 100 23 46 0 1900380752 6205008 6565376
23:11:51 9796 8192000000 10793189824 11227934720 1887434960 18.725 100 19 38 1 1899456224 6321024 5700240
23:12:14 6594 8192000000 10801098704 11232182272 1891334816 18.757 100 24 49 1 1905114896 7212656 6567424
23:12:29 5441 8192000000 10804050992 11235086336 1894709488 18.784 100 29 59 1 1910282288 7000016 8572784
23:12:44 12563 8192000000 10792099088 11229908992 1892291456 18.764 100 15 28 1 1901944544 5678640 3974448
23:13:03 14588 8192000000 10797783600 11234168832 1893563600 18.774 100 21 41 2 1905163216 5756096 5843520
23:13:28 61659 8192000000 10852148848 11253633024 1904743808 18.864 100 52 104 0 1926224832 6675040 14805984
23:14:36 10824 8192000000 10821239648 11250716672 1900516432 18.830 100 28 55 1 1915420800 7525280 7379088
23:14:57 7308 8192000000 10808391440 11248963584 1905338560 18.869 100 24 49 2 1917929296 6166384 6424352
23:15:12 4959 8192000000 10833870560 11260727296 1906100080 18.875 100 35 70 2 1922868928 6199136 10569712
23:15:28 8280 8192000000 10831757680 11257982976 1906342304 18.877 100 22 44 1 1918846944 6283184 6221456
23:15:45 5384 8192000000 10814067424 11242618880 1884545952 18.702 99 31 62 1 1900447952 6908832 8993168
23:15:57 7238 8192000000 10814941392 11244118016 1882887648 18.688 99 29 58 2 1897599680 5590960 9121072
23:16:15 5386 8192000000 10812754944 11242434560 1897380544 18.805 100 34 68 1 1913795232 5900608 10514080
23:16:27 6797 8192000000 10798096400 11237867520 1879334448 18.660 99 28 56 1 1893610720 6343040 7933232
23:16:45 7749 8192000000 10809936816 11233357824 1872445856 18.604 99 31 62 0 1888554416 7038448 9070112
23:16:59 14347 8192000000 10804118032 11238883328 1887705280 18.727 100 14 28 4 1897663520 5346080 4612160
23:17:24 10045 8192000000 10772549936 11212148736 1842106144 18.358 98 18 36 2 1853002208 5678512 5217552
23:17:42 5846 8192000000 10781583680 11190484992 1817342272 18.156 97 44 87 2 1835166496 4389648 13434576
23:17:55 59247 8192000000 10731425488 11168059392 1739710384 17.516 93 36 73 0 1760623216 9858048 11054784
23:19:08 18805 8192000000 10759884368 11176378368 1760680416 17.690 95 23 46 1 1773150720 5569312 6900992
23:19:34 6658 8192000000 10735519552 11147931648 1764987184 17.726 97 28 56 1 1779362416 6515792 7859440
23:19:46 4247 8192000000 10736216832 11152605184 1785826112 17.897 98 19 37 0 1796613296 5194016 5593168
23:19:59 5279 8192000000 10719319488 11139911680 1775479792 17.812 98 35 71 2 1791523648 5026752 11017104
23:20:13 7422 8192000000 10740042240 11159371776 1821890352 18.193 100 24 48 0 1835081888 5219632 7971904
23:20:28 8654 8192000000 10734964240 11148836864 1740305104 17.521 95 29 58 0 1753902528 4965936 8631488
23:20:42 13301 8192000000 10730689440 11144704000 1741643216 17.532 96 24 49 1 1754057776 4850112 7564448
23:21:07 11954 8192000000 10743954080 11159912448 1791444352 17.944 98 24 48 0 1803944720 5590192 6910176
23:21:25 16524 8192000000 10727501936 11146326016 1734130784 17.470 95 21 42 1 1749622416 9359056 6132576
23:21:48 11949 8192000000 10726663808 11148271616 1795030704 17.973 99 20 40 1 1806689552 5650320 6008528
23:22:08 13288 8192000000 10732628256 11159277568 1816085696 18.146 100 29 58 2 1830507104 5376688 9044720
23:22:28 65356 8192000000 10723778608 11144536064 1778501168 17.837 97 22 44 0 1789873504 5251344 6120992
23:23:44 14881 8192000000 10770851504 11188768768 1843340720 18.368 100 32 63 2 1858021600 6792800 7888080
23:24:07 5303 8192000000 10758237040 11187933184 1847514256 18.402 100 36 72 2 1865382576 8205584 9662736
23:24:19 8009 8192000000 10760646320 11193008128 1850700080 18.428 100 34 68 0 1866438736 5768080 9970576
23:24:36 6119 8192000000 10775851872 11197108224 1853987680 18.455 100 37 75 2 1870732608 5938640 10806288
23:24:51 11534 8192000000 10773843344 11206127616 1857589040 18.484 100 23 46 1 1870725040 6953264 6182736
23:25:09 9333 8192000000 10780935776 11208290304 1859861136 18.502 100 26 52 1 1872844176 5649232 7333808
23:25:29 7882 8192000000 10773615328 11210481664 1865726192 18.550 100 24 48 1 1883386880 10388544 7272144
23:25:46 13272 8192000000 10787950544 11215736832 1863197680 18.529 100 19 38 1 1873402256 4854800 5349776
23:26:08 9453 8192000000 10790993376 11218419712 1864288880 18.538 100 13 25 1 1873032992 5084368 3659744
23:26:25 7780 8192000000 10789279088 11223941120 1869802800 18.583 100 25 50 1 1887044112 9953184 7288128
23:26:42 10805 8192000000 10793622016 11224408064 1874118896 18.618 100 32 65 1 1889670352 5527584 10023872
23:27:01 13075 8192000000 10797390032 11230601216 1881666864 18.679 100 14 28 0 1890026080 4757136 3602080
23:27:21 35450 8192000000 10833339456 11252711424 1896637024 18.799 100 30 57 2 1913609472 8785648 8186800
23:28:07 36426 8192000000 10837040880 11267158016 1913473344 18.935 100 36 72 2 1930297888 6036976 10787568
23:28:50 11203 8192000000 10862000688 11279667200 1922532480 19.007 100 44 89 2 1945146816 9852368 12761968
23:29:08 128745 8192000000 10859132752 11295465472 1926711696 19.041 100 41 82 1 1950327056 11409536 12205824
23:31:29 22442 8192000000 10870082400 11302273024 1932811152 19.089 100 27 53 2 1951602064 11500048 7290864
23:31:58 6262 8192000000 10883949360 11306700800 1943593856 19.175 100 59 112 1 1973051360 12751200 16706304
23:32:10 14888 8192000000 10882706208 11314032640 1949744800 19.224 100 56 111 2 1977779872 12854080 15180992
23:32:34 15191 8192000000 10899046320 11325104128 1959752688 19.304 100 73 146 0 1993789584 13713040 20323856
23:32:57 2064 8192000000 10899074576 11315789824 1945034944 19.187 99 76 150 2 1980993440 14921040 21037456
23:33:07 6294 8192000000 10913933024 11333451776 1964465184 19.342 100 71 141 2 1999929104 15615328 19848592
23:33:20 7824 8192000000 10908807920 11332919296 1964701696 19.343 100 63 126 1 1996925968 14413760 17810512
23:33:36 19777 8192000000 10913680912 11344490496 1967136096 19.363 100 54 108 0 2001185056 19462592 14586368
23:34:41 22468 8192000000 10915324064 11356786688 1981389296 19.476 100 42 84 1 2013938160 19323760 13225104
23:35:11 10392 8192000000 10930947824 11363569664 1986405328 19.515 100 45 86 1 2014998608 15403392 13189888
23:35:32 21504 8192000000 10926361632 11369807872 1973025424 19.409 99 40 80 0 2003799184 18816352 11957408
23:36:03 8528 8192000000 10946170416 11381215232 1996990288 19.599 100 48 96 1 2035390448 24411648 13988512
23:36:21 5408 8192000000 10948149744 11386265600 2000215232 19.624 100 61 122 0 2043958704 24952192 18791280
23:36:33 16078 8192000000 10962290848 11392901120 2003650736 19.652 100 61 122 0 2044005824 22556256 17798832
23:36:59 10098 8192000000 10963596432 11394207744 2007265776 19.680 100 54 106 2 2048318608 23833504 17219328
23:37:32 11592 8192000000 10967073008 11405774848 2012447088 19.721 100 54 108 1 2055307088 26917664 15942336
23:38:03 9513 8192000000 10965790960 11402559488 1997913664 19.606 99 55 110 2 2042931872 27903696 17114512
23:38:20 8166 8192000000 10960737744 11393183744 1973976304 19.417 98 62 122 0 2021514240 28916912 18621024
23:38:37 4747 8192000000 10974006608 11408777216 2006698192 19.676 100 68 135 2 2057686864 30583328 20405344
23:38:50 2353 8192000000 10975261632 11405209600 2014524992 19.737 100 76 146 1 2064372672 28749952 21097728
23:39:00 4130 8192000000 10972788864 11402534912 2004310688 19.657 100 73 146 1 2059262432 33040336 21911408
23:39:13 5270 8192000000 10971001056 11404419072 2011808912 19.716 100 65 130 1 2058936384 26752576 20374896
23:39:30 14793 8192000000 10968041648 11404021760 2014078960 19.734 100 74 148 1 2062288912 26086048 22123904
23:40:04 10705 8192000000 10970213040 11412336640 2016927472 19.756 100 51 102 0 2058204032 25878256 15398304
23:40:25 7396 8192000000 10977472112 11411877888 2019453312 19.776 100 54 108 1 2062024656 26008272 16563072
23:40:40 5855 8192000000 10980051712 11413823488 2023695632 19.809 100 61 120 5 2068569488 27137600 17736256
23:41:03 3365 8192000000 10983036528 11420246016 2026344224 19.830 100 64 128 5 2074738464 29021200 19373040
23:41:14 3305 8192000000 10987094768 11418972160 2023410880 19.807 100 70 140 2 2074309392 29208384 21690128
23:41:27 4512 8192000000 10981263056 11416133632 2018179440 19.766 100 61 120 0 2067128464 30245792 18703232
23:41:47 1571 8192000000 10994094016 11420311552 2024120960 19.813 100 75 150 2 2079939808 32230560 23588288
23:41:56 3901 8192000000 10986928224 11412115456 2000166224 19.624 99 76 152 1 2058262288 35430432 22665632
23:42:08 4283 8192000000 10977038496 11409154048 2007718976 19.684 100 65 130 1 2062378544 34408896 20250672
23:42:21 4502 8192000000 10977683760 11407544320 2005335952 19.665 100 66 130 1 2061092592 35260800 20495840
23:42:37 6933 8192000000 10965748480 11402432512 2001876112 19.638 100 59 118 0 2055974688 35120400 18978176
23:42:56 10078 8192000000 10979540944 11410591744 1994312208 19.578 99 59 118 1 2049851616 36556192 18983216
23:43:13 6404 8192000000 10980653200 11402571776 1992430928 19.563 99 81 162 2 2059669472 42101472 25137072
23:43:33 3150 8192000000 10972031888 11394940928 1966715232 19.359 98 78 157 1 2032389312 41719200 23954880
23:43:44 5249 8192000000 10977590016 11408506880 1998069024 19.608 100 68 136 0 2060420352 40802352 21548976
23:43:59 10589 8192000000 10961011856 11394686976 1966784992 19.360 98 60 120 1 2025053696 39532224 18736480
23:44:17 4417 8192000000 10948040304 11381104640 1967888432 19.369 99 53 105 0 2024452864 39947008 16617424
23:44:29 7789 8192000000 10956462112 11385274368 1960730736 19.312 99 56 110 4 2017407568 39391584 17285248
23:44:49 4807 8192000000 10966124768 11399122944 1986533600 19.516 100 58 116 2 2045277168 40512608 18230960
23:45:02 1654 8192000000 10966121040 11389878272 1981927056 19.480 100 80 158 0 2049232160 41581184 25723920
23:45:11 7259 8192000000 10942762304 11366940672 1967613648 19.367 100 83 162 0 2038858080 45551200 25693232
23:45:26 2851 8192000000 10954531504 11376631808 1967349968 19.364 100 70 140 1 2034706928 44414848 22942112
23:45:37 3927 8192000000 10943160528 11372306432 1954588656 19.263 99 60 120 1 2018674272 44257792 19827824
23:45:52 6520 8192000000 10948436784 11374759936 1966462352 19.357 100 65 128 0 2033080464 45903120 20714992
23:46:08 2528 8192000000 10966259088 11384709120 1970537424 19.390 100 70 137 0 2044153184 51609648 22006112
23:46:18 2676 8192000000 10967979536 11390341120 1975668400 19.430 100 78 156 1 2055399488 53644864 26086224
23:46:27 4122 8192000000 10959453440 11396268032 1979133552 19.458 100 57 112 0 2046532752 49154832 18244368
23:46:51 14415 8192000000 10953359920 11393232896 1974062464 19.418 100 40 78 0 2038864912 50847760 13954688
23:47:13 5831 8192000000 10989695552 11409502208 1982900288 19.488 100 66 131 2 2054764496 50887264 20976944
23:47:26 2090 8192000000 10991188592 11412283392 1995341264 19.586 100 76 152 2 2074836320 54170688 25324368
23:47:38 7670 8192000000 10972181616 11409235968 1973338624 19.412 99 48 96 0 2044982704 55788208 15855872
23:47:52 11187 8192000000 10970642864 11428917248 1991472656 19.555 100 44 88 0 2067375584 61516032 14386896
23:48:10 11756 8192000000 10931666768 11382468608 1940994816 19.155 98 36 72 0 2003589504 50533984 12060704
23:48:28 13568 8192000000 10949772384 11386933248 1961361024 19.317 99 38 76 1 2023023056 49207120 12454912
23:48:50 7378 8192000000 10925561456 11363475456 1937344512 19.126 99 48 92 1 2002470304 50125616 15000176
23:49:04 20368 8192000000 10927319840 11372568576 1938254576 19.133 99 36 72 2 2002624464 51995520 12374368
23:49:41 29422 8192000000 10927190992 11383291904 1939472656 19.143 99 29 58 0 2003136240 53596240 10067344
23:50:33 26381 8192000000 10894527984 11340304384 1891077344 18.754 97 21 42 0 1947273168 48040560 8155264
23:51:06 22938 8192000000 10896802608 11352883200 1911762256 18.921 99 27 54 1 1978693824 57268256 9663312
23:51:41 33414 8192000000 10887940688 11355893760 1921677648 19.000 100 22 44 1 1981890560 52348256 7864656
23:52:46 26542 8192000000 10905010624 11349594112 1914666896 18.944 99 39 78 1 1974476032 46521520 13287616
23:53:24 8942 8192000000 10910992528 11359596544 1932866128 19.090 100 29 58 0 1995324608 52216560 10241920
23:53:44 8805 8192000000 10901206672 11355361280 1930100672 19.068 100 22 43 1 1989655104 51860224 7694208
23:54:00 25908 8192000000 10868603392 11359694848 1932074256 19.083 100 18 36 0 1972741040 34502656 6164128
23:54:32 22140 8192000000 10832503072 11295862784 1842366832 18.360 96 12 24 1 1864471280 18147200 3957248
23:55:06 91172 8192000000 10840660912 11286822912 1813230736 18.122 95 21 43 0 1831465584 12698432 5536416
23:56:44 49596 8192000000 10833318656 11276640256 1837314528 18.319 96 28 54 1 1854610848 8903456 8392864
23:57:41 86756 8192000000 10838782512 11299647488 1834400032 18.295 96 10 20 1 1857574640 20118000 3056608
23:59:14 93248 8192000000 10860354400 11313405952 1820996864 18.186 95 8 16 1 1844210448 21445888 1767696
00:00:54 141639 8192000000 10864640384 11323826176 1878596608 18.654 97 10 20 0 1894656256 13730768 2328880
00:03:59 70387 8192000000 10912280192 11350110208 1954700400 19.264 100 26 52 1 1971437568 9519712 7217456
00:05:16 108233 8192000000 10896103728 11343474688 1941795104 19.161 99 36 72 2 1961823936 8774304 11254528
00:07:19 48913 8192000000 10892348032 11338272768 1923178688 19.012 98 46 90 0 1950636096 14570320 12887088
00:08:30 40464 8192000000 10890509968 11363856384 1970747072 19.391 100 40 80 1 1995977872 13854992 11375808
00:09:27 61483 8192000000 10908204736 11368910848 1977911456 19.448 100 20 40 2 1993789952 10449424 5429072
00:10:34 11230 8192000000 10922863424 11376820224 1986559360 19.517 100 41 81 4 2008563840 10050224 11954256
00:10:55 47916 8192000000 10951466560 11391041536 1987543488 19.524 100 26 52 2 2006290848 11094016 7653344
00:11:56 60670 8192000000 10928156272 11390246912 1994049904 19.576 100 32 64 1 2020276656 16317792 9908960
00:13:08 37322 8192000000 10933959024 11393744896 1993860512 19.574 100 41 81 2 2020778800 14562720 12355568
00:14:01 43445 8192000000 10905794816 11380948992 1968377952 19.373 99 16 32 0 1985226944 12214064 4634928
00:14:57 53373 8192000000 10920371952 11395313664 1995604608 19.588 100 10 20 0 2009397856 10545440 3247808
00:16:12 72499 8192000000 10929985856 11405631488 2005276656 19.664 100 11 22 1 2022365328 13427712 3660960
00:17:37 53622 8192000000 10931004128 11402113024 2000218560 19.624 100 14 28 1 2021058368 17167600 3672208
00:18:37 10450 8192000000 10928506192 11405832192 1998867344 19.614 100 15 30 0 2023452800 20331808 4253648
00:19:11 14886 8192000000 10916841088 11393396736 2001520464 19.635 100 16 31 0 2018856576 12763024 4573088
00:19:37 43749 8192000000 10923161776 11401682944 1986912272 19.519 99 21 42 0 1999915648 7317808 5685568
00:20:27 31663 8192000000 10895566016 11372843008 1940677296 19.152 97 8 17 0 1951190768 8372208 2141264
00:21:05 33413 8192000000 10897584928 11358711808 1931041088 19.075 97 31 62 1 1951114080 12091664 7981328
00:21:53 22234 8192000000 10918511200 11366662144 1972307904 19.404 100 36 71 2 1990472096 8064640 10099552
00:22:25 33675 8192000000 10899354560 11364933632 1943186032 19.172 98 21 42 1 1957490384 8192752 6111600
00:23:05 45519 8192000000 10898662816 11371622400 1916675392 18.960 97 25 50 3 1933015808 9248224 7092192
00:23:57 42019 8192000000 10898416384 11370172416 1894344416 18.781 96 13 26 3 1913940128 15894608 3701104
00:24:45 60611 8192000000 10881406336 11363840000 1937152080 19.124 99 11 22 0 1958615872 18625024 2838768
00:26:27 73479 8192000000 10898628864 11375616000 1912035600 18.923 97 24 48 0 1939308592 20296864 6976128
00:27:46 64527 8192000000 10847752800 11305435136 1820887424 18.185 93 13 26 0 1834949440 10878960 3183056
00:29:33 58384 8192000000 10828703184 11287343104 1776768224 17.823 93 15 30 0 1795396368 14879488 3748656
00:30:39 87433 8192000000 10863597040 11330347008 1840976304 18.349 96 14 28 2 1866595440 22393040 3226096
00:32:13 109515 8192000000 10886034960 11332259840 1927368000 19.046 99 39 79 2 1956186064 16744416 12073648
00:34:37 108080 8192000000 10885373552 11361701888 1938827664 19.137 99 19 38 0 1959935328 15775872 5331792
00:36:32 5851 8192000000 10876460544 11360378880 1953289328 19.253 100 9 18 0 1972863104 17294496 2279280
00:36:45 4996 8192000000 10875706064 11364057088 1951017600 19.235 100 6 12 1 1971177712 18595504 1564608
00:36:59 19309 8192000000 10878616448 11355414528 1957415104 19.285 100 10 20 1 1968872736 8101904 3355728
00:37:27 57493 8192000000 10874275872 11347300352 1923578784 19.016 98 18 36 1 1936465232 7814992 5071456
00:38:31 48204 8192000000 10864363792 11325263872 1883519200 18.694 96 20 41 1 1899062976 9707680 5836096
00:39:50 47503 8192000000 10845552512 11311509504 1865648688 18.549 96 14 28 1 1879887488 10032160 4206640
00:41:01 74454 8192000000 10859621344 11329159168 1900351312 18.829 98 16 31 2 1918353280 12973040 5028928
00:42:25 46933 8192000000 10867398240 11339747328 1918817056 18.977 99 21 42 2 1940548624 15294928 6436640
00:43:18 70221 8192000000 10861539856 11327729664 1855102064 18.464 96 14 29 1 1886867568 27673712 4091792
00:46:14 51028 8192000000 10866270752 11316318208 1852139280 18.439 96 21 42 0 1865556048 7941280 5475488
00:47:30 34912 8192000000 10840479088 11296522240 1842933888 18.365 96 27 54 0 1865684352 15245184 7505280
00:48:17 69572 8192000000 10824864080 11279618048 1851769584 18.436 97 22 43 3 1868620144 10481392 6369168
00:50:07 26493 8192000000 10854498160 11318173696 1904106320 18.859 99 39 76 3 1924048736 8923520 11018896
00:50:58 29660 8192000000 10851270272 11315183616 1920725248 18.993 100 29 58 1 1939456768 10826144 7905376
00:51:38 31512 8192000000 10875034080 11323219968 1897101184 18.803 98 40 78 1 1918430256 10453552 10875520
00:52:21 30658 8192000000 10877053392 11326779392 1924457952 19.023 100 39 76 0 1947084160 11906960 10719248
00:52:59 23560 8192000000 10894641360 11347107840 1949579408 19.223 100 43 86 0 1974000384 12487280 11933696
00:53:31 9080 8192000000 10896906128 11350265856 1936402608 19.118 99 43 86 0 1963358464 14966400 11989456
00:53:48 44162 8192000000 10853544384 11337822208 1884845856 18.704 97 24 48 1 1908449936 16868480 6735600
00:54:41 117445 8192000000 10881038112 11350073344 1907450752 18.886 98 16 32 0 1922923280 10879776 4592752
00:56:46 15281 8192000000 10892247968 11358044160 1956215760 19.276 100 26 52 0 1974680176 11136224 7328192
00:57:13 71281 8192000000 10898602080 11370885120 1964938400 19.345 100 23 46 1 1981863488 11092928 5832160
00:58:31 87227 8192000000 10898842624 11368902656 1941487728 19.159 98 20 40 1 1958336080 11108416 5739936
01:00:44 74644 8192000000 10922873248 11383390208 1970557968 19.390 100 24 47 0 1993663200 16045600 7059632
01:02:04 56689 8192000000 10892296640 11374215168 1959398128 19.301 99 21 42 2 1975557024 10248752 5910144
01:03:15 59427 8192000000 10904201920 11390607360 1974694880 19.423 100 11 22 1 1993645472 15904672 3045920
01:04:21 31992 8192000000 10890165728 11384754176 1962970896 19.330 99 6 12 0 1978415328 13686032 1758400
01:05:07 48395 8192000000 10901943184 11387387904 1962421632 19.325 99 16 32 1 1977353856 9193968 5738256
01:06:04 48570 8192000000 10887332448 11368419328 1906756304 18.881 96 8 16 1 1919714352 10395760 2562288
01:07:05 85900 8192000000 10889883552 11379097600 1954144400 19.259 99 24 46 2 1975640144 14640336 6855408
01:08:40 26793 8192000000 10904883072 11381358592 1980005248 19.465 100 19 38 0 1997144800 11744704 5394848
01:09:13 64740 8192000000 10896313648 11374989312 1943765456 19.177 98 19 38 1 1966390688 17266064 5359168
01:10:48 74291 8192000000 10917269264 11412942848 1984983120 19.504 100 16 32 1 2008945392 19294624 4667648
01:13:03 78902 8192000000 10898478112 11384356864 1894851312 18.785 95 20 38 2 1911037936 10647072 5539552
01:15:59 67064 8192000000 10920105760 11404591104 1989262320 19.538 100 24 48 1 2015810496 19585328 6962848
01:17:14 57232 8192000000 10909140400 11370397696 1933486816 19.095 98 19 38 2 1952953728 14101184 5365728
01:18:18 32203 8192000000 10885142688 11351355392 1878242560 18.651 95 31 62 1 1895400928 8508000 8650368
01:19:11 62479 8192000000 10887208816 11348586496 1897154944 18.803 97 26 51 2 1913571472 9130176 7286352
01:20:21 18993 8192000000 10890090672 11349680128 1930991984 19.075 99 41 82 0 1959087856 16388000 11707872
01:21:12 25607 8192000000 10884392512 11342422016 1928824096 19.057 99 42 84 0 1950662512 9790864 12047552
01:21:53 138866 8192000000 10873418992 11336015872 1834994816 18.300 94 31 62 1 1856196640 12620224 8581600
01:24:20 125647 8192000000 10845862064 11316342784 1862746768 18.526 96 27 54 0 1878897504 8962640 7188096
01:26:37 47391 8192000000 10257564768 10678988800 1375422768 14.376 71 27 54 0 1388968016 6101504 7443744

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:29, from 19-03-2021 01:29:51 to 19-03-2021 01:30:20.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 214 v_add_invoice_to_stock 335544517
except 16 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 19-03-2021 01:30:21 to 19-03-2021 01:30:23.

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          242150
MON$OLDEST_ACTIVE               242151
MON$OLDEST_SNAPSHOT             242151
MON$NEXT_TRANSACTION            242151
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                       2042272
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.33427 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33427 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33427 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33427 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 ---
:93: 
:94: mscs-test-161.budzdorov.ru    Fri Mar 19 01:27:42 2021
:95:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:96: 
--- end of diff output ---

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

19.03.21 01:30:24. 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-03-19 01:30:27 No severe PSQL-related problems occured
19.03.21 01:30:28. End of report.