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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 58e1ddde69c44dad93d327777e5becec
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-05-09 08:45
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4793.92
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17171212 kB
MemAvailable 31414952 kB
Buffers 0 kB
Cached 14470056 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-06-08 01:27:36
DTS_END                         2021-06-08 01:27:36.6750
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/53570
TRN_ID                          243821
ATT_ID                          626
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: 9108.88 21092 1093065
customer order: creation 173.36 350 20803
customer order: refuse 14.63 354 1755
order to supplier: creation 47.01 1406 5641
order to supplier: removal 3.47 94463 416
invoice (draft): creation 46.03 3551 5523
invoice (draft): removal 53.03 781 6363
invoice accept: apply 41.49 19356 4979
invoice accept: cancel 47.18 842 5662
customer reserve: creation 3748.31 197 449797
customer reserve: removal 4643.26 55 557191
realization accept: apply 83.95 181 10074
realization accept: cancel 74.18 115 8902
payment from customer: creation 60.73 128 7287
payment from customer: removal 6.19 69 743
payment to supplier: creation 50.32 143 6038
payment to supplier: removal 3.43 69 412
service: total inventory turnovers 4.93 1060 592
service: total monetary turnovers 6.47 33 776
service: aggregate perf. data 0.89 19758 107
service: refresh index statistics 0.03 278921 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 08-06-2021 01:28:49 to 08-06-2021 01:28:51.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5926
TEST_TIME 2 6030
TEST_TIME 3 6371
TEST_TIME 4 7210
TEST_TIME 5 6695
TEST_TIME 6 6587
TEST_TIME 7 6720
TEST_TIME 8 6720
TEST_TIME 9 6470
TEST_TIME 10 6260
TEST_TIME 11 6371
TEST_TIME 12 6309
TEST_TIME 13 6614
TEST_TIME 14 6651
TEST_TIME 15 6687
TEST_TIME 16 6716
TEST_TIME 17 7369
TEST_TIME 18 7328
TEST_TIME 19 7389
TEST_TIME 20 7324
TEST_TIME 21 7586
TEST_TIME 22 7877
TEST_TIME 23 8579
TEST_TIME 24 8543
TEST_TIME 25 8964
TEST_TIME 26 8939
TEST_TIME 27 8881
TEST_TIME 28 9198
TEST_TIME 29 9283
TEST_TIME 30 9902
TEST_TIME 31 9855
TEST_TIME 32 10032
TEST_TIME 33 9821
TEST_TIME 34 9589
TEST_TIME 35 9624
TEST_TIME 36 9606
TEST_TIME 37 9458
TEST_TIME 38 9385
TEST_TIME 39 9275
TEST_TIME 40 9240
TEST_TIME 41 9540
TEST_TIME 42 9568
TEST_TIME 43 9464
TEST_TIME 44 9533
TEST_TIME 45 9471
TEST_TIME 46 9456
TEST_TIME 47 9497
TEST_TIME 48 9499
TEST_TIME 49 9542
TEST_TIME 50 9555
TEST_TIME 51 9431
TEST_TIME 52 9283
TEST_TIME 53 9280
TEST_TIME 54 9229
TEST_TIME 55 9118
TEST_TIME 56 9101
TEST_TIME 57 9129
TEST_TIME 58 9148
TEST_TIME 59 9193
TEST_TIME 60 9140
TEST_TIME 61 9138
TEST_TIME 62 9051
TEST_TIME 63 8998
TEST_TIME 64 8964
TEST_TIME 65 9018
TEST_TIME 66 9095
TEST_TIME 67 9100
TEST_TIME 68 9123
TEST_TIME 69 9148
TEST_TIME 70 9139
TEST_TIME 71 9187
TEST_TIME 72 9266
TEST_TIME 73 9217
TEST_TIME 74 9220
TEST_TIME 75 9408
TEST_TIME 76 9427
TEST_TIME 77 9423
TEST_TIME 78 9369
TEST_TIME 79 9441
TEST_TIME 80 9361
TEST_TIME 81 9307
TEST_TIME 82 9266
TEST_TIME 83 9178
TEST_TIME 84 9283
TEST_TIME 85 9272
TEST_TIME 86 9219
TEST_TIME 87 9179
TEST_TIME 88 9126
TEST_TIME 89 9132
TEST_TIME 90 9170
TEST_TIME 91 9173
TEST_TIME 92 9187
TEST_TIME 93 9200
TEST_TIME 94 9183
TEST_TIME 95 9231
TEST_TIME 96 9244
TEST_TIME 97 9275
TEST_TIME 98 9245
TEST_TIME 99 9259
TEST_TIME 100 9275
TEST_TIME 101 9272
TEST_TIME 102 9264
TEST_TIME 103 9304
TEST_TIME 104 9268
TEST_TIME 105 9286
TEST_TIME 106 9360
TEST_TIME 107 9279
TEST_TIME 108 9248
TEST_TIME 109 9201
TEST_TIME 110 9172
TEST_TIME 111 9207
TEST_TIME 112 9162
TEST_TIME 113 9164
TEST_TIME 114 9124
TEST_TIME 115 9080
TEST_TIME 116 9036
TEST_TIME 117 9036
TEST_TIME 118 9074
TEST_TIME 119 9125
TEST_TIME 120 9113

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 08-06-2021 01:28:53 to 08-06-2021 01:28:56.

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 1509676 1509676 0 0.00 0 16695 7 0 0
doc_list_biud 1509673 1509673 0 0.00 0 26543 26 0 0
sp_add_invoice_to_stock 5145 4979 166 3.22 35 204984 19357 0 166
sp_cancel_adding_invoice 5662 5662 0 0.00 5 71498 842 0 0
sp_cancel_client_order 1755 1755 0 0.00 4 7787 354 0 0
sp_cancel_customer_reserve 557191 557191 0 0.00 1 26546 55 0 0
sp_cancel_pay_from_customer 743 743 0 0.00 3 2053 69 0 0
sp_cancel_pay_to_supplier 412 412 0 0.00 3 1559 69 0 0
sp_cancel_supplier_invoice 6378 6363 15 0.23 1 20929 782 0 15
sp_cancel_supplier_order 416 416 0 0.00 7 865358 94463 0 0
sp_cancel_write_off 8902 8902 0 0.00 1 12585 115 0 0
sp_client_order 20803 20803 0 0.00 3 30614 350 0 0
sp_customer_reserve 449797 449797 0 0.00 0 93106 197 0 0
sp_fill_shopping_cart 31959 31959 0 0.00 1 12155 40 0 0
sp_fill_shopping_cart_clo_res 449789 449789 0 0.00 0 13835 14 0 0
sp_get_clo_for_invoice 4971 4971 0 0.00 0 15311 265 0 0
sp_kill_cost_storno 15719 15719 0 0.00 0 10876 61 0 0
sp_kill_qstorno_ret_qs2qd 1130063 1130063 0 0.00 0 26537 30 0 0
sp_kill_qty_storno 595333 595333 0 0.00 0 26542 66 0 0
sp_lock_selected_doc 20971 20971 0 0.00 0 9416 5 0 0
sp_make_cost_storno 28369 28369 0 0.00 0 16657 60 0 0
sp_multiply_rows_for_pdistr 28369 28369 0 0.00 0 14879 31 0 0
sp_multiply_rows_for_qdistr 20802 20802 0 0.00 0 30283 138 0 0
sp_pay_from_customer 7287 7287 0 0.00 4 12879 128 0 0
sp_pay_to_supplier 6038 6038 0 0.00 5 15378 144 0 0
sp_payment_common 13325 13325 0 0.00 2 14034 36 0 0
sp_qd_handle_on_cancel_clo 1755 1755 0 0.00 0 7768 329 0 0
sp_qd_handle_on_invoice_upd_sts 10632 10632 0 0.00 0 26316 337 0 0
sp_qd_handle_on_reserve_upd_sts 10074 10074 0 0.00 0 14975 61 0 0
sp_reserve_write_off 10074 10074 0 0.00 7 14993 181 0 0
sp_supplier_invoice 5523 5523 0 0.00 7 96387 3551 0 0
sp_supplier_order 5641 5641 0 0.00 5 54492 1407 0 0
srv_aggregate_perf_data 108 107 1 0.92 2888 326705 19759 0 1
srv_fill_mon_cache_memory 163 163 0 0.00 1101 161674 31955 0 0
srv_find_qd_qs_mism 1045269 1045269 0 0.00 0 15258 5 0 0
srv_make_invnt_saldo 592 592 0 0.00 40 63345 1060 0 0
srv_make_money_saldo 776 776 0 0.00 1 7074 34 0 0
srv_recalc_idx_stat 4 4 0 0.00 83170 469154 278922 0 0
t$perf-abend:sp_add_invoice_to_stock 166 166 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 15 15 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 4979 4979 0 0.00 0 14183 169 0 0
t$perf-norm:sp_cancel_adding_invoice 429 429 0 0.00 0 7004 110 0 0
t$perf-norm:sp_cancel_client_order 1755 1755 0 0.00 0 4229 13 0 0
t$perf-norm:sp_cancel_customer_reserve 713 713 0 0.00 0 3938 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 743 743 0 0.00 0 7349 18 0 0
t$perf-norm:sp_cancel_pay_to_supplier 412 412 0 0.00 0 458 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 400 400 0 0.00 0 1561 26 0 0
t$perf-norm:sp_cancel_supplier_order 416 416 0 0.00 0 18980 1721 0 0
t$perf-norm:sp_cancel_write_off 1059 1059 0 0.00 0 9630 23 0 0
t$perf-norm:sp_client_order 20803 20803 0 0.00 0 12338 22 0 0
t$perf-norm:sp_customer_reserve 1013 1013 0 0.00 0 1753 5 0 0
t$perf-norm:sp_pay_from_customer 7287 7287 0 0.00 0 7557 11 0 0
t$perf-norm:sp_pay_to_supplier 6038 6038 0 0.00 0 4214 11 0 0
t$perf-norm:sp_reserve_write_off 10074 10074 0 0.00 0 10774 14 0 0
t$perf-norm:sp_supplier_invoice 5523 5523 0 0.00 0 12513 21 0 0
t$perf-norm:sp_supplier_order 5641 5641 0 0.00 0 3754 14 0 0
t$perf-norm:srv_aggregate_perf_data 107 107 0 0.00 0 228 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 163 163 0 0.00 0 595 10 0 0
t$perf-norm:srv_make_invnt_saldo 592 592 0 0.00 0 2004 28 0 0
t$perf-norm:srv_make_money_saldo 776 776 0 0.00 0 1399 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 10272 9940 332 3.23 0 5048 19 0 332
v_all_customers 37476 37476 0 0.00 0 17 1 0 0
v_all_suppliers 30670 30670 0 0.00 0 34 1 0 0
v_all_wares 41602 41602 0 0.00 0 90 1 0 0
v_cancel_adding_invoice 858 858 0 0.00 0 978 7 0 0
v_cancel_client_order 3510 3510 0 0.00 0 1484 4 0 0
v_cancel_customer_prepayment 1486 1486 0 0.00 0 1039 6 0 0
v_cancel_customer_reserve 1426 1426 0 0.00 0 8937 10 0 0
v_cancel_payment_to_supplier 824 824 0 0.00 0 695 4 0 0
v_cancel_supplier_invoice 830 800 30 3.61 0 6366 24 0 30
v_cancel_supplier_order 832 832 0 0.00 0 2449 7 0 0
v_cancel_write_off 2118 2118 0 0.00 0 4272 16 0 0
v_max_id_clo_ord 5639 5639 0 0.00 0 814 2 0 0
v_max_id_clo_res 1013 1013 0 0.00 0 4879 19 0 0
v_max_id_ord_sup 5518 5518 0 0.00 0 3473 4 0 0
v_max_non_paid_invoice 1860 1860 0 0.00 0 143 2 0 0
v_max_non_paid_realizn 4063 4063 0 0.00 0 674 3 0 0
v_min_id_clo_ord 5639 5639 0 0.00 0 3197 7 0 0
v_min_id_clo_res 1013 1013 0 0.00 0 4990 17 0 0
v_min_id_ord_sup 5518 5518 0 0.00 0 4421 10 0 0
v_min_non_paid_invoice 6038 6038 0 0.00 0 14029 29 0 0
v_min_non_paid_realizn 7287 7287 0 0.00 0 12011 25 0 0
v_our_firm 10574 10574 0 0.00 0 22 1 0 0
v_reserve_write_off 20148 20148 0 0.00 0 9132 7 0 0
x_lock_depdocs_on_canc_invoice 11625 11625 0 0.00 0 18396 119 0 0
x_lock_depdocs_on_canc_sup_ord 416 416 0 0.00 0 14393 366 0 0
x_make_qstorno_1000_1200 5641 5641 0 0.00 1 54476 1321 0 0
x_make_qstorno_1200_2000 5523 5523 0 0.00 3 96374 3412 0 0
x_make_qstorno_2100_3300 449797 449797 0 0.00 0 93104 181 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 08-06-2021 01:28:57 to 08-06-2021 01:29:01.

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:40 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:46 5209 8192000000 9930374400 10188648448 810095456 8.998 67 45 94 0 828466864 2471152 15900256
22:58:00 19520 8192000000 10307159824 10623283200 1361546032 14.251 100 74 148 1 1389366528 3859680 23960816
22:58:27 20121 8192000000 10368043792 10684809216 1426005648 14.826 100 88 176 0 1459792560 5520032 28266880
22:58:56 29828 8192000000 10409161696 10732306432 1451248160 15.049 100 87 174 0 1486250608 6904784 28097664
22:59:35 25336 8192000000 10441694192 10770493440 1481197344 15.312 100 89 178 0 1517999280 8122752 28679184
23:00:19 21687 8192000000 10463267216 10797703168 1513436528 15.593 100 90 180 0 1550908176 8795696 28675952
23:00:51 25704 8192000000 10483627552 10822803456 1530629984 15.742 100 87 174 0 1567383248 9555632 27197632
23:01:24 26484 8192000000 10506174960 10849083392 1563010208 16.022 100 91 182 0 1601509008 10659648 27839152
23:02:01 19672 8192000000 10537327536 10885664768 1576519744 16.138 100 82 164 0 1612705584 11150144 25035696
23:02:35 9627 8192000000 10561728960 10915020800 1615222576 16.469 100 88 176 1 1654139536 12004912 26912048
23:02:52 11995 8192000000 10561385616 10917945344 1621877904 16.526 100 87 174 1 1660852640 12734768 26239968
23:03:14 14609 8192000000 10588197472 10949324800 1633779680 16.627 100 83 166 1 1670782832 12636208 24366944
23:03:38 10551 8192000000 10604707616 10967986176 1659828624 16.847 100 77 154 2 1695969024 12672000 23468400
23:03:59 11490 8192000000 10614389440 10980851712 1673425792 16.962 100 77 154 0 1708909408 12734912 22748704
23:04:19 10260 8192000000 10631802304 10998583296 1684223440 17.053 100 80 160 1 1721322624 12979216 24119968
23:04:37 9876 8192000000 10643855136 11016761344 1703357840 17.213 100 74 148 1 1737465488 12438320 21669328
23:04:56 7488 8192000000 10656243440 11035136000 1723264112 17.379 100 75 150 0 1757142624 12493600 21384912
23:05:10 7307 8192000000 10672112416 11053309952 1740890912 17.526 100 76 153 0 1774096784 11606992 21598880
23:05:24 5835 8192000000 10690577104 11066814464 1748131648 17.586 100 74 147 0 1780930496 11714240 21084608
23:05:38 4786 8192000000 10691244016 11074715648 1760611744 17.689 100 68 136 0 1791663600 11520368 19531488
23:05:52 5610 8192000000 10711283120 11091980288 1776046624 17.817 100 83 166 0 1812406896 12961888 23398384
23:06:04 3748 8192000000 10725624480 11107557376 1787105072 17.908 100 84 168 1 1824397792 13703248 23589472
23:06:15 4593 8192000000 10732247584 11114336256 1791935584 17.948 100 86 172 1 1830790352 14637264 24217504
23:06:28 8697 8192000000 10732458272 11118018560 1799799872 18.012 100 73 145 1 1833647264 13853680 19993712
23:06:46 4215 8192000000 10744476784 11125899264 1805934992 18.063 100 74 148 1 1839532224 12846800 20750432
23:06:57 3110 8192000000 10760359168 11142828032 1818591184 18.166 100 80 160 2 1853405360 12517984 22296192
23:07:07 3405 8192000000 10762426928 11148247040 1832964464 18.283 100 81 162 0 1870045568 13152896 23928208
23:07:17 2795 8192000000 10787061168 11167481856 1837158256 18.318 100 90 181 3 1876222352 12987616 26076480
23:07:26 2377 8192000000 10785573840 11169869824 1841137808 18.350 100 88 175 2 1879310768 13845072 24327888
23:07:35 2386 8192000000 10787452720 11178418176 1848293504 18.408 100 89 176 0 1887553168 14653504 24606160
23:07:44 2342 8192000000 10800499808 11186733056 1858925472 18.495 100 95 190 1 1898795648 13717568 26152608
23:07:52 2553 8192000000 10803189312 11187793920 1860733600 18.509 100 90 181 0 1899255904 13375200 25147104
23:08:01 1750 8192000000 10799269136 11186049024 1862960512 18.527 100 95 190 0 1902458960 12853344 26645104
23:08:09 2446 8192000000 10808356304 11194040320 1865028000 18.544 100 90 180 1 1904431408 14688992 24714416
23:08:18 2138 8192000000 10808401312 11195314176 1865989808 18.552 100 97 193 3 1907813776 14375120 27448848
23:08:27 1895 8192000000 10808111568 11193724928 1864420816 18.539 100 91 182 1 1902448064 13100400 24926848
23:08:35 2014 8192000000 10822586320 11208081408 1873475360 18.612 100 91 183 2 1912375632 13631808 25268464
23:08:43 2235 8192000000 10821578800 11209940992 1874941728 18.624 100 90 180 1 1914247232 13630512 25674992
23:08:53 1777 8192000000 10821874816 11211849728 1880178016 18.667 100 96 192 0 1919291744 11971040 27142688
23:09:02 12566 8192000000 10821063296 11213275136 1880859440 18.672 100 77 154 1 1914160384 12814912 20486032
23:09:21 1239 8192000000 10834716064 11223609344 1888587840 18.734 100 92 184 0 1927857520 12832080 26437600
23:09:28 38811 8192000000 10811749520 11218391040 1883848144 18.696 100 52 104 0 1907814688 8695328 15271216
23:10:13 17046 8192000000 10803725600 11215552512 1882896976 18.688 100 30 60 2 1898190752 6202800 9090976
23:10:37 6099 8192000000 10787814512 11216384000 1882440640 18.685 100 26 52 3 1896925840 7622720 6862480
23:10:49 6993 8192000000 10799837824 11222667264 1887176016 18.723 100 34 69 2 1903267120 6735456 9355648
23:11:03 9362 8192000000 10794865040 11221475328 1885103584 18.706 100 21 40 1 1897163408 6231344 5828480
23:11:20 8180 8192000000 10798344160 11226628096 1888231760 18.732 100 21 42 0 1900348784 6151392 5965632
23:11:36 6926 8192000000 10805443616 11231285248 1892617408 18.767 100 29 58 1 1908122912 6638544 8866960
23:11:51 7198 8192000000 10801539504 11228966912 1895163360 18.787 100 29 58 1 1909730768 6134608 8432800
23:12:07 9850 8192000000 10799714032 11233611776 1894726032 18.784 100 25 48 0 1908213456 7078976 6408448
23:12:23 4175 8192000000 10809555040 11234316288 1894683808 18.784 100 28 57 2 1908238864 6022624 7532432
23:12:35 5852 8192000000 10789431872 11229806592 1893678240 18.775 100 20 40 1 1905704496 6285920 5740336
23:12:49 8385 8192000000 10799310256 11234697216 1897662560 18.807 100 16 32 1 1912090496 10327776 4100160
23:13:05 7107 8192000000 10801389536 11234312192 1896955040 18.802 100 19 38 1 1908900016 6494752 5450224
23:13:21 13252 8192000000 10800419104 11238944768 1901792240 18.841 100 33 66 1 1917536656 6436448 9307968
23:13:40 8430 8192000000 10801106160 11240660992 1899015504 18.818 100 21 42 1 1911318368 6314944 5987920
23:13:59 11257 8192000000 10807466160 11237638144 1902066640 18.843 100 20 40 2 1913796976 5418448 6311888
23:14:16 11978 8192000000 10806593104 11244179456 1903012160 18.851 100 20 41 1 1915352080 6512272 5827648
23:15:13 24062 8192000000 10819073616 11258015744 1908087312 18.891 100 47 94 3 1928698384 6310816 14300256
23:15:44 7781 8192000000 10826136144 11261190144 1907301504 18.885 100 30 59 3 1921875504 6531504 8042496
23:16:00 6520 8192000000 10829169712 11258884096 1907505856 18.887 100 30 60 1 1922198688 6187568 8505264
23:16:14 5738 8192000000 10826606432 11262152704 1911290224 18.917 100 25 50 0 1925340832 7209040 6841568
23:16:28 5447 8192000000 10818771680 11255762944 1892449552 18.766 99 22 44 2 1904445408 4881440 7114416
23:16:40 3440 8192000000 10841966656 11262259200 1909437344 18.902 100 32 64 0 1925956272 7100160 9418768
23:16:51 7484 8192000000 10806279392 11245740032 1898714000 18.816 100 27 53 0 1913476624 6952080 7810544
23:17:06 7775 8192000000 10816375744 11258519552 1905209680 18.868 100 25 51 2 1918579824 6237584 7132560
23:17:20 5478 8192000000 10813448736 11251818496 1903696960 18.856 100 30 60 1 1918051776 5519568 8835248
23:17:36 10931 8192000000 10794858736 11227992064 1841036896 18.349 97 24 48 0 1853795696 6066432 6692368
23:17:53 9200 8192000000 10785879008 11213574144 1840647536 18.346 98 22 45 0 1852795184 6001888 6145760
23:18:09 6308 8192000000 10780448960 11213062144 1857216896 18.481 99 21 42 0 1868674912 5163296 6294720
23:18:21 6594 8192000000 10768834032 11202629632 1833506752 18.288 98 19 36 3 1843726448 4937776 5281920
23:18:34 5682 8192000000 10760412880 11179302912 1831566368 18.272 100 27 54 2 1846038448 6722384 7749696
23:18:50 11888 8192000000 10725026256 11134803968 1761929088 17.700 96 24 48 4 1774610304 5548144 7133072
23:19:09 59726 8192000000 10714510112 11120590848 1690118192 17.102 93 31 62 2 1705198736 4779872 10300672
23:20:19 13512 8192000000 10705883568 11123818496 1718926368 17.343 96 18 36 1 1728667552 4995472 4745712
23:20:39 7158 8192000000 10709696080 11118002176 1748597808 17.590 97 29 58 0 1762467440 5203472 8666160
23:20:52 4579 8192000000 10714402848 11121815552 1773702512 17.798 99 48 97 1 1795910944 8832688 13375744
23:21:04 5264 8192000000 10698357536 11117715456 1785776512 17.897 100 33 66 0 1801276208 6473408 9026288
23:21:19 5196 8192000000 10692615536 11097018368 1725140976 17.395 96 24 45 2 1737344144 6252656 5950512
23:21:30 11952 8192000000 10721610784 11135094784 1767765616 17.749 98 25 50 3 1780618368 6117104 6735648
23:21:50 8371 8192000000 10690690528 11104198656 1701685760 17.199 95 26 51 1 1714562528 4651360 8225408
23:22:11 10605 8192000000 10714554736 11123539968 1754962992 17.643 98 25 51 1 1768048672 5396336 7689344
23:22:31 6535 8192000000 10712112272 11123154944 1761346912 17.696 97 29 58 0 1775865408 6059168 8459328
23:22:44 9488 8192000000 10698836480 11114627072 1779310336 17.844 99 18 36 3 1789588880 5473488 4805056
23:23:00 7287 8192000000 10723934448 11147137024 1805930992 18.063 100 22 44 0 1818273552 6316128 6026432
23:23:15 4605 8192000000 10742390288 11161583616 1823015728 18.202 100 28 56 3 1837607264 5415824 9175712
23:23:29 6950 8192000000 10740948976 11167522816 1829050480 18.252 100 26 52 1 1842266304 5730608 7485216
23:23:44 15151 8192000000 10765873392 11176067072 1837567088 18.321 100 28 55 2 1855559168 10106960 7885120
23:24:07 63958 8192000000 10771595744 11199795200 1848585696 18.411 100 32 60 3 1866553280 9284208 8683376
23:25:24 7278 8192000000 10769858352 11192475648 1852752768 18.444 100 16 32 2 1862687264 5755152 4179344
23:25:38 7866 8192000000 10774915904 11200880640 1858661968 18.492 100 30 60 0 1873736448 5820208 9254272
23:25:54 7654 8192000000 10789624832 11200675840 1859245088 18.497 100 24 48 2 1871632784 5515344 6872352
23:26:09 9739 8192000000 10774780496 11202437120 1860588576 18.508 100 20 40 1 1872227600 4939808 6699216
23:26:26 6258 8192000000 10782312736 11210534912 1864452912 18.539 100 34 68 1 1880322704 6731936 9137856
23:26:39 5070 8192000000 10782921040 11211456512 1865092960 18.545 100 22 43 4 1882408928 10097088 7218880
23:26:50 10542 8192000000 10777479312 11209125888 1865600096 18.549 100 13 27 1 1874059664 5063712 3395856
23:27:07 9968 8192000000 10795173152 11228647424 1885505248 18.710 100 17 34 1 1895427472 4699888 5222336
23:27:23 7499 8192000000 10810753600 11241308160 1893317456 18.773 100 16 32 1 1906572704 9412720 3842528
23:27:38 19511 8192000000 10825555024 11249602560 1900999936 18.834 100 23 46 2 1912855856 5096224 6759696
23:28:06 5319 8192000000 10845207728 11264688128 1918474640 18.975 100 53 106 2 1939445536 6091936 14878960
23:28:22 25325 8192000000 10863184720 11283779584 1926705744 19.041 100 46 92 1 1950099856 9934016 13460096
23:28:54 14156 8192000000 10860681952 11287863296 1931663648 19.080 100 49 98 0 1955142704 9447616 14031440
23:29:23 85020 8192000000 10873933056 11306831872 1942056048 19.163 100 45 90 0 1964372400 8747280 13569072
23:30:57 3163 8192000000 10886825424 11316617216 1955562704 19.271 100 70 139 4 1986791728 10557312 20671712
23:31:07 9215 8192000000 10894505984 11322224640 1956651216 19.279 100 59 116 1 1983229552 10666192 15912144
23:31:25 6576 8192000000 10900397792 11329413120 1942408432 19.166 99 50 98 0 1969131872 13533792 13189648
23:31:40 8359 8192000000 10882568320 11323789312 1958034800 19.290 100 46 93 0 1980958400 9705072 13218528
23:31:56 2129 8192000000 10897620992 11330650112 1964397184 19.341 100 50 99 1 1987027040 8985536 13644320
23:32:13 4663 8192000000 10913644208 11341578240 1970949136 19.393 100 70 139 3 2001270144 10037136 20283872
23:32:30 26414 8192000000 10902143120 11342979072 1971931840 19.401 100 42 84 1 1994797568 11019952 11845776
23:33:22 17403 8192000000 10909854096 11350757376 1978260880 19.451 100 44 88 3 2002472000 11261664 12949456
23:33:47 7343 8192000000 10904006016 11348361216 1961969088 19.322 99 43 86 0 1986721536 12053824 12698624
23:34:05 6506 8192000000 10919488912 11355238400 1977761072 19.447 100 48 94 3 2004531392 12185392 14584928
23:34:23 19390 8192000000 10925728480 11358380032 1966265376 19.356 99 56 110 1 1995148448 12879680 16003392
23:34:52 5580 8192000000 10912704528 11341279232 1966804352 19.360 99 69 138 2 2000699904 13584304 20311248
23:35:11 12413 8192000000 10923142624 11361828864 1988196688 19.530 100 61 123 1 2024305024 18468768 17639568
23:35:32 9370 8192000000 10921846992 11355394048 1982315552 19.483 100 72 143 1 2018360928 14356304 21689072
23:35:58 36866 8192000000 10911559680 11347619840 1969901504 19.385 100 48 96 3 1998308240 14229360 14177376
23:36:45 25984 8192000000 10907660672 11353530368 1975517312 19.429 100 37 73 1 2002437744 16434816 10485616
23:37:19 36961 8192000000 10906258528 11354075136 1960128208 19.307 99 28 56 0 1987030320 17664944 9237168
23:38:47 12044 8192000000 10891203408 11339448320 1945524736 19.191 99 27 52 2 1969435536 15526400 8384400
23:39:08 16120 8192000000 10917195088 11349778432 1974830528 19.424 100 52 102 0 2005484880 15280432 15373920
23:39:33 2868 8192000000 10932484720 11355590656 1973075248 19.410 100 62 122 0 2009608464 18279552 18253664
23:39:42 4379 8192000000 10925705920 11348418560 1974273360 19.419 100 66 130 0 2013577840 19841360 19463120
23:39:56 13589 8192000000 10934975024 11363885056 1976069088 19.434 100 54 108 1 2012850304 20767216 16014000
23:40:24 4075 8192000000 10897869616 11326652416 1954570352 19.263 100 65 130 2 1994615264 20057728 19987184
23:40:39 2014 8192000000 10922805424 11347152896 1968828416 19.376 100 75 151 0 2012833008 20677856 23326736
23:40:49 3939 8192000000 10923147184 11343179776 1957795408 19.289 99 63 126 0 1996526080 19574160 19156512
23:41:00 8002 8192000000 10936486720 11362205696 1977942352 19.448 100 64 128 2 2018264368 21449936 18872080
23:41:16 5932 8192000000 10942944784 11363930112 1986424912 19.516 100 71 141 1 2029054784 21959232 20670640
23:41:33 2870 8192000000 10950797552 11372879872 1990631136 19.549 100 80 159 5 2036500288 22681760 23187392
23:41:43 4085 8192000000 10918835952 11341975552 1953580448 19.255 99 74 148 1 1999812000 24021488 22210064
23:41:55 7139 8192000000 10893111984 11327995904 1929012032 19.059 98 56 112 2 1970397856 23984208 17401616
23:42:09 3595 8192000000 10902947936 11335815168 1954666256 19.264 100 44 88 0 1990869952 22444096 13759600
23:42:26 3547 8192000000 10931756576 11345657856 1966290656 19.356 100 61 122 0 2006659728 21991440 18377632
23:42:38 3848 8192000000 10950174560 11363512320 1982011312 19.481 100 83 164 1 2036053008 29593424 24448272
23:42:50 5660 8192000000 10910894976 11322101760 1940269392 19.149 99 75 149 1 1989596256 26595104 22731760
23:43:04 4297 8192000000 10933461056 11345760256 1958554592 19.295 100 73 146 0 2013162560 32534992 22072976
23:43:15 5178 8192000000 10921158928 11340013568 1944371616 19.182 99 76 152 1 1996621376 28797248 23452512
23:43:30 14643 8192000000 10909394752 11330822144 1922499936 19.007 98 60 120 1 1970196656 28652656 19044064
23:43:58 4041 8192000000 10914183248 11331936256 1915386160 18.950 98 66 134 1 1972122224 35447840 21288224
23:44:18 4532 8192000000 10912210208 11346219008 1953783232 19.257 100 59 117 0 1999524864 28199904 17541728
23:44:31 1458 8192000000 10939794752 11348271104 1968619296 19.374 100 83 167 1 2021997376 27877040 25501040
23:44:39 3770 8192000000 10922560272 11332026368 1948836496 19.217 99 81 161 2 1999710176 25561616 25312064
23:44:51 8398 8192000000 10917090192 11339649024 1959560400 19.303 100 64 128 0 2003852032 23780384 20511248
23:45:06 22443 8192000000 10900604480 11322540032 1919100448 18.980 98 54 108 0 1960555536 24899472 16555616
23:45:38 4762 8192000000 10901345984 11326337024 1934163632 19.100 99 62 122 1 1978923680 26165536 18594512
23:45:58 7368 8192000000 10922297376 11351351296 1964872672 19.345 100 55 110 2 2009711504 27745984 17092848
23:46:12 3025 8192000000 10945438208 11355811840 1979235952 19.459 100 85 169 3 2032292816 28409840 24647024
23:46:24 3383 8192000000 10958478576 11375812608 1981400960 19.476 100 79 158 0 2035250048 30322944 23526144
23:46:36 1098 8192000000 10931794000 11340226560 1927512208 19.047 97 89 178 1 1984968768 30341600 27114960
23:46:48 9200 8192000000 10923798352 11351072768 1964593200 19.343 100 57 114 0 2011340736 28980080 17767456
23:47:04 13431 8192000000 10901882624 11330015232 1914845488 18.946 98 50 99 1 1961601600 31426016 15330096
23:47:26 3163 8192000000 10895103248 11322204160 1922508864 19.007 99 52 104 0 1971156624 32531568 16116192
23:47:46 6252 8192000000 10902684960 11326439424 1922345040 19.006 99 63 125 3 1975191104 32900400 19945664
23:47:59 1778 8192000000 10880067072 11290648576 1906775776 18.881 99 73 145 0 1962912240 33974560 22161904
23:48:08 2618 8192000000 10918409328 11328647168 1936390016 19.118 100 82 160 1 1997556752 36980160 24186576
23:48:21 2142 8192000000 10935117488 11340640256 1945035280 19.187 100 86 169 4 2008246272 38095472 25115520
23:48:29 6829 8192000000 10927182000 11341479936 1946538016 19.199 100 76 152 2 2010227472 40522480 23166976
23:48:45 3057 8192000000 10915358512 11336904704 1914318560 18.941 98 77 153 2 1975826640 37767664 23740416
23:48:57 5680 8192000000 10902698928 11334524928 1936995600 19.123 100 47 94 1 1988899376 36196688 15707088
23:49:13 12676 8192000000 10907058800 11344564224 1945552608 19.191 100 44 88 0 2000587344 40219616 14815120
23:49:33 13476 8192000000 10903709968 11344769024 1944286608 19.181 100 35 70 1 1990836640 34477728 12072304
23:49:53 11107 8192000000 10890184928 11324436480 1884832304 18.704 97 32 64 0 1930846624 34875744 11138576
23:50:16 9129 8192000000 10874170560 11306913792 1898783280 18.817 98 33 65 2 1948512416 38624240 11104896
23:50:38 6323 8192000000 10908489728 11343433728 1933980752 19.099 100 32 63 0 1983205312 38717392 10507168
23:50:52 22510 8192000000 10882334192 11328110592 1913418864 18.934 99 27 54 1 1950668640 28740576 8509200
23:51:22 8078 8192000000 10896547824 11337334784 1942088432 19.163 100 60 119 1 1993567648 32988528 18490688
23:51:37 13923 8192000000 10892104608 11331493888 1915345840 18.950 99 35 70 3 1961378000 34392960 11639200
23:51:58 14799 8192000000 10895175408 11316813824 1894358896 18.781 98 39 74 0 1939397728 33242400 11796432
23:52:20 6265 8192000000 10875533184 11311382528 1914821008 18.945 100 35 70 0 1958725952 32380768 11524176
23:52:34 17319 8192000000 10858043600 11300413440 1898429488 18.814 99 22 44 3 1939051520 33169984 7452048
23:52:58 16102 8192000000 10865598768 11311452160 1901409360 18.838 99 27 54 0 1940026528 30257616 8359552
23:53:30 17041 8192000000 10850249216 11296600064 1873756960 18.615 98 21 42 1 1907689872 27083088 6849824
23:53:54 5688 8192000000 10888623840 11313950720 1918316176 18.973 100 48 95 3 1958898896 25136896 15445824
23:54:12 25606 8192000000 10880767264 11320729600 1926665888 19.040 100 20 40 1 1961226208 26985184 7575136
23:54:45 8921 8192000000 10884339744 11324395520 1930123728 19.068 100 23 46 1 1967550000 29422272 8004000
23:55:04 10066 8192000000 10897812208 11331112960 1921577040 18.999 99 47 94 1 1967941408 31708304 14656064
23:55:22 29462 8192000000 10884250240 11338756096 1936589408 19.120 100 23 46 1 1972073424 27487856 7996160
23:56:14 25873 8192000000 10863220784 11317202944 1904111728 18.859 99 19 38 2 1938931840 28712272 6107840
23:56:47 37752 8192000000 10910360912 11346194432 1929678784 19.064 100 25 50 1 1973220656 35480784 8061088
23:57:32 4423 8192000000 10943498176 11373842432 1959676016 19.303 100 53 104 0 2009393408 32748288 16969104
23:57:48 33091 8192000000 10911057808 11354476544 1963759472 19.336 100 29 55 4 1990964032 18837280 8367280
23:58:48 27409 8192000000 10907070368 11355312128 1969355216 19.380 100 35 70 1 1999052768 19276240 10421312
23:59:30 35880 8192000000 10874629456 11345760256 1941170640 19.156 99 8 15 0 1956728096 13544864 2012592
00:00:13 37330 8192000000 10889437792 11343278080 1950509216 19.231 100 12 20 2 1966353840 12742032 3102592
00:01:16 54823 8192000000 10884647536 11346190336 1943411104 19.174 99 18 36 0 1962443216 13433216 5598896
00:03:10 35433 8192000000 10911995888 11343138816 1945165120 19.188 99 28 55 2 1962466272 8271488 9029664
00:03:55 26314 8192000000 10934901728 11372072960 1976948080 19.441 100 61 118 2 2002433120 9220432 16264608
00:04:53 25932 8192000000 10919681664 11366666240 1960338960 19.309 99 27 53 2 1984424016 16629184 7455872
00:05:41 48145 8192000000 10919745728 11374866432 1977678752 19.446 100 38 77 2 2007746096 18564944 11502400
00:06:35 45801 8192000000 10921221344 11375955968 1962234000 19.324 99 26 50 1 1986407296 17250976 6922320
00:07:35 15007 8192000000 10952732544 11389747200 1986249440 19.514 100 55 111 2 2024817504 22309504 16258560
00:08:04 48674 8192000000 10913964112 11404804096 1977165408 19.442 100 12 24 0 1999776896 18946112 3665376
00:09:01 72546 8192000000 10920917152 11388383232 1963606384 19.335 99 20 38 0 1994778000 25747568 5424048
00:10:23 143359 8192000000 10907753600 11385081856 1965145664 19.347 99 17 34 0 1984715584 14654384 4915536
00:12:52 161672 8192000000 10928037056 11391111168 1951823728 19.241 98 17 34 0 1968128480 11946432 4358320
00:15:42 86068 8192000000 10928024000 11411181568 1976874336 19.440 99 30 60 1 2006442768 20094736 9473696
00:17:19 134673 8192000000 10927320240 11394064384 1973493664 19.413 99 18 36 2 1999467600 20785760 5188176
00:20:05 97266 8192000000 10941273168 11398410240 1958591392 19.295 98 27 54 0 1975891984 9882176 7418416
00:21:51 103784 8192000000 10887555504 11354472448 1876959760 18.641 94 26 52 2 1894677024 10205312 7511952
00:23:44 24396 8192000000 10917909712 11359756288 1958623040 19.295 99 41 79 1 1979453296 8682176 12148080
00:24:18 12652 8192000000 10891747584 11338043392 1940267840 19.149 98 52 104 0 1967231088 11703936 15259312
00:24:41 7195 8192000000 10890660896 11336388608 1936926320 19.122 99 52 102 4 1967906160 16430016 14549824
00:24:56 13320 8192000000 10908786432 11356102656 1962525504 19.326 100 58 116 2 1990124080 11609792 15988784
00:25:17 10751 8192000000 10894671408 11343872000 1943023616 19.171 99 61 121 0 1972240208 12163968 17052624
00:25:37 65147 8192000000 10818303888 11292303360 1825186032 18.220 94 17 35 1 1840580448 10758032 4636384
00:26:55 19220 8192000000 10844007392 11311529984 1904112816 18.859 99 9 18 1 1914855904 8547760 2195328
00:27:24 124977 8192000000 10866171488 11340677120 1903257168 18.852 97 21 43 0 1921456736 12333488 5866080
00:29:36 28286 8192000000 10870433392 11342356480 1905610672 18.871 98 6 12 0 1920847104 13105360 2131072
00:30:13 50469 8192000000 10859408880 11328139264 1924961216 19.027 99 16 32 0 1943243344 13681584 4600544
00:31:13 43933 8192000000 10852296864 11303280640 1868602704 18.573 96 16 28 3 1880730096 8330368 3797024
00:32:04 45452 8192000000 10817341168 11283542016 1801721808 18.028 93 18 36 1 1814419056 7876832 4820416
00:32:58 64563 8192000000 10849915296 11321163776 1880199776 18.667 98 11 22 0 1892459376 9208064 3051536
00:34:13 36281 8192000000 10840179104 11296849920 1848516128 18.410 96 12 24 1 1859213792 7738640 2959024
00:34:56 73611 8192000000 10826849840 11293655040 1853545312 18.451 96 15 30 0 1868463840 9968752 4949776
00:36:19 49302 8192000000 10868492000 11319238656 1876607184 18.638 97 23 46 1 1895433712 12297424 6529104
00:37:19 26647 8192000000 10882160688 11331362816 1922330224 19.006 99 42 84 0 1945906176 11472912 12103040
00:37:52 46448 8192000000 10873408528 11345948672 1943265072 19.173 100 22 44 0 1964685568 15172272 6248224
00:38:45 52159 8192000000 10872686640 11320262656 1843897728 18.373 95 18 36 0 1859620192 10668736 5053728
00:39:46 31937 8192000000 10854616016 11307741184 1881216672 18.675 97 24 48 1 1901640528 13656784 6767072
00:40:29 68085 8192000000 10890046576 11345334272 1931581200 19.080 100 29 58 2 1961188128 20651792 8955136
00:41:47 53566 8192000000 10852740960 11329998848 1871121664 18.593 97 14 28 0 1899435776 23975040 4339072
00:42:49 97940 8192000000 10862056080 11328032768 1855032848 18.463 96 12 24 0 1873900912 15576448 3291616
00:44:35 54928 8192000000 10872690704 11329454080 1904239088 18.860 98 25 50 1 1919674592 8417472 7018032
00:45:36 20141 8192000000 10881504960 11321925632 1930078240 19.068 99 46 92 0 1953573680 10308496 13186944
00:46:04 34650 8192000000 10899249728 11361361920 1952407712 19.246 100 47 94 2 1980323760 14862720 13053328
00:48:36 76688 8192000000 10876622048 11339460608 1922030928 19.003 98 23 46 1 1942086288 13315392 6739968
00:50:24 58937 8192000000 10894500608 11374817280 1961651168 19.319 100 26 52 3 1995867632 26200272 8016192
00:51:29 55290 8192000000 10899226112 11377352704 1969751200 19.383 100 26 50 2 1997095152 19211440 8132512
00:54:06 70566 8192000000 10909418416 11381710848 1969392544 19.381 100 16 32 0 1987950208 14076816 4480848
00:55:24 53238 8192000000 10882450720 11365892096 1933039216 19.091 98 13 24 1 1956892144 20182384 3670544
00:56:55 81786 8192000000 10891082384 11377139712 1950408352 19.230 99 16 33 1 1972527184 17563968 4554864
00:58:31 48526 8192000000 10909379136 11389042688 1980428608 19.468 100 14 27 1 1995026064 11217184 3380272
00:59:32 78452 8192000000 10908851712 11393171456 1964176432 19.339 99 18 36 1 1986640464 17436080 5027952
01:00:57 77506 8192000000 10921870960 11410460672 1992528640 19.564 100 13 26 2 2010364320 14169952 3665728
01:02:21 47117 8192000000 10932397408 11404681216 1996717824 19.597 100 12 24 0 2009573360 9600304 3255232
01:03:19 51545 8192000000 10963455920 11416489984 2004371056 19.657 100 21 42 0 2018630368 8654720 5604592
01:04:19 33583 8192000000 10930389328 11414081536 1987523936 19.524 99 18 36 2 2004433696 11808912 5100848
01:05:00 44354 8192000000 10936235824 11402047488 1986466736 19.516 99 43 87 3 2005087744 7101536 11519472
01:05:53 19776 8192000000 10941084992 11394936832 1963512144 19.334 98 46 92 1 1985468672 9261472 12695056
01:06:22 37624 8192000000 10935660496 11406434304 1975379728 19.428 99 41 82 1 1998694496 12169888 11144880
01:07:10 51951 8192000000 10901164880 11386474496 1937837696 19.129 97 32 64 0 1961287184 14493344 8956144
01:08:08 52455 8192000000 10937875280 11389227008 1933183504 19.092 97 43 84 2 1955319648 10345728 11790416
01:09:06 37327 8192000000 10937334640 11402452992 1989277408 19.538 100 32 64 1 2010354576 12394368 8682800
01:09:51 87340 8192000000 10910839744 11387527168 1905399680 18.870 95 12 24 0 1919207984 10917600 2890704
01:11:25 63219 8192000000 10878400544 11349299200 1842048752 18.357 93 12 24 2 1862257616 17165376 3043488
01:12:36 76943 8192000000 10865677024 11350618112 1873453632 18.612 96 9 18 1 1891540496 15833648 2253216
01:14:48 72692 8192000000 10852601456 11321978880 1869270016 18.578 96 18 35 2 1889000560 14675872 5054672
01:16:08 44928 8192000000 10866046976 11327545344 1884691744 18.703 97 26 48 0 1899758912 8247072 6820096
01:17:09 13828 8192000000 10882976624 11338575872 1946959888 19.202 100 40 80 1 1969756464 11477472 11319104
01:17:34 45647 8192000000 10861408064 11340673024 1936613312 19.120 100 28 56 1 1956152080 11869920 7668848
01:18:28 49724 8192000000 10813413760 11285544960 1855426384 18.466 96 9 18 1 1873367840 15414944 2526512
01:19:24 32777 8192000000 10826729760 11300356096 1839692096 18.338 96 9 18 1 1852114176 10262576 2159504
01:20:03 44700 8192000000 10856278048 11329245184 1919932368 18.986 100 9 18 0 1930774176 8364736 2477072
01:20:54 119427 8192000000 10865792368 11335237632 1909937312 18.906 98 17 34 3 1923836672 9074912 4824448
01:23:06 88833 8192000000 10873170912 11344826368 1900558416 18.831 97 20 40 1 1920146352 13813600 5774336
01:24:41 8329 8192000000 10894609712 11346661376 1952127920 19.243 100 39 78 2 1978924144 15126464 11669760
01:24:57 68213 8192000000 10880686304 11354091520 1930125920 19.068 99 19 38 1 1954775376 19062112 5587344
01:26:12 67540 8192000000 10854128384 11347202048 1897491136 18.806 98 12 25 0 1931415312 29821072 4103104
01:27:32 7743 8192000000 8928580064 9101053952 102766240 1.238 6 1 2 0 103258112 429744 62128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 08-06-2021 01:29:03 to 08-06-2021 01:29:34.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 166 v_add_invoice_to_stock 335544517
except 15 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 08-06-2021 01:29:35 to 08-06-2021 01:29:37.

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          244422
MON$OLDEST_ACTIVE               244423
MON$OLDEST_SNAPSHOT             244423
MON$NEXT_TRANSACTION            244423
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                       2041440
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.33471 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33471 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33471 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33471 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 ---
--- end of diff output ---

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

08.06.21 01:29:38. 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-08 01:29:41 No severe PSQL-related problems occured
08.06.21 01:29:42. End of report.