Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 03.04.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 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 17177884 kB
MemAvailable 31465024 kB
Buffers 0 kB
Cached 14492460 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-04-03 01:27:26
DTS_END                         2021-04-03 01:27:26.7850
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_AGGREGATE_PERF_DATA(83:5) ==> TMP_AGGREGATE_PERF_DATA_AUTOGEN(226:13) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/35376
TRN_ID                          240991
ATT_ID                          643
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: 9234.88 21038 1108185
customer order: creation 172.35 372 20682
customer order: refuse 14.68 363 1762
order to supplier: creation 44.87 1412 5384
order to supplier: removal 3.40 97579 408
invoice (draft): creation 45.14 3192 5417
invoice (draft): removal 54.40 738 6528
invoice accept: apply 41.61 17971 4993
invoice accept: cancel 47.91 755 5749
customer reserve: creation 3808.19 179 456983
customer reserve: removal 4703.57 56 564428
realization accept: apply 83.45 189 10014
realization accept: cancel 84.41 102 10129
payment from customer: creation 59.63 146 7155
payment from customer: removal 5.96 71 715
payment to supplier: creation 49.28 126 5914
payment to supplier: removal 3.55 102 426
service: total inventory turnovers 4.63 1090 556
service: total monetary turnovers 7.02 23 842
service: aggregate perf. data 0.80 20557 96
service: refresh index statistics 0.03 275734 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4176
TEST_TIME 2 4234
TEST_TIME 3 4214
TEST_TIME 4 4645
TEST_TIME 5 4468
TEST_TIME 6 4867
TEST_TIME 7 4906
TEST_TIME 8 5556
TEST_TIME 9 5468
TEST_TIME 10 5608
TEST_TIME 11 5726
TEST_TIME 12 6003
TEST_TIME 13 6090
TEST_TIME 14 6109
TEST_TIME 15 6587
TEST_TIME 16 7113
TEST_TIME 17 7623
TEST_TIME 18 7834
TEST_TIME 19 8052
TEST_TIME 20 8079
TEST_TIME 21 8245
TEST_TIME 22 8522
TEST_TIME 23 8498
TEST_TIME 24 9026
TEST_TIME 25 9273
TEST_TIME 26 9636
TEST_TIME 27 9886
TEST_TIME 28 10352
TEST_TIME 29 10287
TEST_TIME 30 10320
TEST_TIME 31 10259
TEST_TIME 32 10385
TEST_TIME 33 10370
TEST_TIME 34 10250
TEST_TIME 35 10141
TEST_TIME 36 10243
TEST_TIME 37 10170
TEST_TIME 38 10117
TEST_TIME 39 10098
TEST_TIME 40 9973
TEST_TIME 41 10034
TEST_TIME 42 10141
TEST_TIME 43 10055
TEST_TIME 44 10077
TEST_TIME 45 10046
TEST_TIME 46 10030
TEST_TIME 47 10147
TEST_TIME 48 10058
TEST_TIME 49 9905
TEST_TIME 50 9765
TEST_TIME 51 9779
TEST_TIME 52 9798
TEST_TIME 53 9666
TEST_TIME 54 9618
TEST_TIME 55 9531
TEST_TIME 56 9448
TEST_TIME 57 9595
TEST_TIME 58 9590
TEST_TIME 59 9567
TEST_TIME 60 9537
TEST_TIME 61 9487
TEST_TIME 62 9495
TEST_TIME 63 9521
TEST_TIME 64 9553
TEST_TIME 65 9532
TEST_TIME 66 9555
TEST_TIME 67 9617
TEST_TIME 68 9544
TEST_TIME 69 9575
TEST_TIME 70 9552
TEST_TIME 71 9667
TEST_TIME 72 9657
TEST_TIME 73 9815
TEST_TIME 74 9793
TEST_TIME 75 9775
TEST_TIME 76 9720
TEST_TIME 77 9658
TEST_TIME 78 9599
TEST_TIME 79 9565
TEST_TIME 80 9550
TEST_TIME 81 9484
TEST_TIME 82 9556
TEST_TIME 83 9503
TEST_TIME 84 9460
TEST_TIME 85 9427
TEST_TIME 86 9432
TEST_TIME 87 9380
TEST_TIME 88 9340
TEST_TIME 89 9368
TEST_TIME 90 9371
TEST_TIME 91 9384
TEST_TIME 92 9376
TEST_TIME 93 9393
TEST_TIME 94 9422
TEST_TIME 95 9380
TEST_TIME 96 9496
TEST_TIME 97 9479
TEST_TIME 98 9457
TEST_TIME 99 9449
TEST_TIME 100 9589
TEST_TIME 101 9546
TEST_TIME 102 9539
TEST_TIME 103 9525
TEST_TIME 104 9629
TEST_TIME 105 9553
TEST_TIME 106 9511
TEST_TIME 107 9463
TEST_TIME 108 9464
TEST_TIME 109 9399
TEST_TIME 110 9389
TEST_TIME 111 9369
TEST_TIME 112 9343
TEST_TIME 113 9294
TEST_TIME 114 9278
TEST_TIME 115 9291
TEST_TIME 116 9282
TEST_TIME 117 9241
TEST_TIME 118 9256
TEST_TIME 119 9246
TEST_TIME 120 9238

Performance per minute, chart


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

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 1530957 1530957 0 0.00 0 37180 6 0 0
doc_list_biud 1530955 1530955 0 0.00 0 25715 26 0 0
sp_add_invoice_to_stock 5134 4993 141 2.74 55 187614 17971 0 141
sp_cancel_adding_invoice 5749 5749 0 0.00 5 49606 756 0 0
sp_cancel_client_order 1762 1762 0 0.00 4 8705 363 0 0
sp_cancel_customer_reserve 564428 564428 0 0.00 1 24641 56 0 0
sp_cancel_pay_from_customer 715 715 0 0.00 2 6452 72 0 0
sp_cancel_pay_to_supplier 426 426 0 0.00 3 5083 102 0 0
sp_cancel_supplier_invoice 6539 6528 11 0.16 2 15167 739 0 11
sp_cancel_supplier_order 408 408 0 0.00 7 1093346 97580 0 0
sp_cancel_write_off 10129 10129 0 0.00 1 23869 103 0 0
sp_client_order 20682 20682 0 0.00 4 29417 373 0 0
sp_customer_reserve 456983 456983 0 0.00 0 90688 179 0 0
sp_fill_shopping_cart 31480 31480 0 0.00 1 17339 39 0 0
sp_fill_shopping_cart_clo_res 456978 456978 0 0.00 0 18918 14 0 0
sp_get_clo_for_invoice 4988 4988 0 0.00 0 18007 256 0 0
sp_kill_cost_storno 17019 17019 0 0.00 0 10137 54 0 0
sp_kill_qstorno_ret_qs2qd 1145921 1145921 0 0.00 0 24635 30 0 0
sp_kill_qty_storno 604004 604004 0 0.00 0 25715 66 0 0
sp_lock_selected_doc 20822 20822 0 0.00 0 7937 7 0 0
sp_make_cost_storno 28071 28071 0 0.00 0 32163 62 0 0
sp_multiply_rows_for_pdistr 28070 28070 0 0.00 0 7756 30 0 0
sp_multiply_rows_for_qdistr 20682 20682 0 0.00 0 23330 172 0 0
sp_pay_from_customer 7155 7155 0 0.00 4 31470 146 0 0
sp_pay_to_supplier 5914 5914 0 0.00 5 19187 127 0 0
sp_payment_common 13069 13069 0 0.00 1 31462 35 0 0
sp_qd_handle_on_cancel_clo 1762 1762 0 0.00 0 8677 331 0 0
sp_qd_handle_on_invoice_upd_sts 10735 10735 0 0.00 0 25714 322 0 0
sp_qd_handle_on_reserve_upd_sts 10014 10014 0 0.00 0 23194 64 0 0
sp_reserve_write_off 10014 10014 0 0.00 6 23602 190 0 0
sp_supplier_invoice 5417 5417 0 0.00 6 88134 3193 0 0
sp_supplier_order 5384 5384 0 0.00 6 36000 1412 0 0
srv_aggregate_perf_data 97 96 1 1.03 2727 364939 20558 0 1
srv_fill_mon_cache_memory 158 158 0 0.00 1206 123682 32883 0 0
srv_find_qd_qs_mism 1060378 1060378 0 0.00 0 21429 5 0 0
srv_make_invnt_saldo 556 556 0 0.00 61 58740 1090 0 0
srv_make_money_saldo 842 842 0 0.00 1 3179 24 0 0
srv_recalc_idx_stat 4 4 0 0.00 167505 420128 275734 0 0
t$perf-abend:sp_add_invoice_to_stock 141 141 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 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 4993 4993 0 0.00 0 23660 181 0 0
t$perf-norm:sp_cancel_adding_invoice 386 386 0 0.00 0 2550 83 0 0
t$perf-norm:sp_cancel_client_order 1762 1762 0 0.00 0 3359 13 0 0
t$perf-norm:sp_cancel_customer_reserve 710 710 0 0.00 0 1464 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 715 715 0 0.00 0 3356 17 0 0
t$perf-norm:sp_cancel_pay_to_supplier 426 426 0 0.00 0 2229 15 0 0
t$perf-norm:sp_cancel_supplier_invoice 417 417 0 0.00 0 1630 17 0 0
t$perf-norm:sp_cancel_supplier_order 408 408 0 0.00 0 34402 1753 0 0
t$perf-norm:sp_cancel_write_off 998 998 0 0.00 0 1409 5 0 0
t$perf-norm:sp_client_order 20682 20682 0 0.00 0 13960 19 0 0
t$perf-norm:sp_customer_reserve 1016 1016 0 0.00 0 3060 9 0 0
t$perf-norm:sp_pay_from_customer 7155 7155 0 0.00 0 7913 10 0 0
t$perf-norm:sp_pay_to_supplier 5914 5914 0 0.00 0 13492 13 0 0
t$perf-norm:sp_reserve_write_off 10014 10014 0 0.00 0 13827 15 0 0
t$perf-norm:sp_supplier_invoice 5417 5417 0 0.00 0 12618 25 0 0
t$perf-norm:sp_supplier_order 5384 5384 0 0.00 0 11959 19 0 0
t$perf-norm:srv_aggregate_perf_data 96 96 0 0.00 0 185 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 158 158 0 0.00 0 632 9 0 0
t$perf-norm:srv_make_invnt_saldo 556 556 0 0.00 0 1585 23 0 0
t$perf-norm:srv_make_money_saldo 842 842 0 0.00 0 2799 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 10253 9971 282 2.75 0 7166 23 0 282
v_all_customers 37596 37596 0 0.00 0 17 1 0 0
v_all_suppliers 30042 30042 0 0.00 0 19 1 0 0
v_all_wares 41364 41364 0 0.00 0 182 1 0 0
v_cancel_adding_invoice 772 772 0 0.00 0 1596 9 0 0
v_cancel_client_order 3524 3524 0 0.00 0 3955 5 0 0
v_cancel_customer_prepayment 1430 1430 0 0.00 0 3390 5 0 0
v_cancel_customer_reserve 1420 1420 0 0.00 0 4300 9 0 0
v_cancel_payment_to_supplier 852 852 0 0.00 0 3967 8 0 0
v_cancel_supplier_invoice 856 834 22 2.57 0 2806 21 0 22
v_cancel_supplier_order 816 816 0 0.00 0 1606 7 0 0
v_cancel_write_off 1996 1996 0 0.00 0 3033 12 0 0
v_max_id_clo_ord 5381 5381 0 0.00 0 1690 2 0 0
v_max_id_clo_res 1016 1016 0 0.00 0 3929 14 0 0
v_max_id_ord_sup 5416 5416 0 0.00 0 5601 6 0 0
v_max_non_paid_invoice 1689 1689 0 0.00 0 531 2 0 0
v_max_non_paid_realizn 3942 3942 0 0.00 0 3397 6 0 0
v_min_id_clo_ord 5381 5381 0 0.00 0 7016 15 0 0
v_min_id_clo_res 1016 1016 0 0.00 0 3553 10 0 0
v_min_id_ord_sup 5416 5416 0 0.00 0 7352 8 0 0
v_min_non_paid_invoice 5914 5914 0 0.00 0 5973 17 0 0
v_min_non_paid_realizn 7155 7155 0 0.00 0 31458 23 0 0
v_our_firm 10194 10194 0 0.00 0 16 1 0 0
v_reserve_write_off 20028 20028 0 0.00 0 7571 6 0 0
x_lock_depdocs_on_canc_invoice 11860 11860 0 0.00 0 11811 108 0 0
x_lock_depdocs_on_canc_sup_ord 408 408 0 0.00 0 7962 354 0 0
x_make_qstorno_1000_1200 5384 5384 0 0.00 2 35961 1323 0 0
x_make_qstorno_1200_2000 5417 5417 0 0.00 2 85456 3059 0 0
x_make_qstorno_2100_3300 456983 456983 0 0.00 0 90686 163 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 03-04-2021 01:29:08 to 03-04-2021 01:29:12.

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:30 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:36 12552 8192000000 10196230016 10495635456 851675584 9.417 69 58 117 1 874637424 2462768 20499072
22:57:59 19169 8192000000 10312046848 10625753088 1352901024 14.174 100 83 166 0 1385422848 4320128 28201696
22:58:29 18384 8192000000 10361036656 10678071296 1413499664 14.715 100 89 178 0 1448739728 5745728 29494336
22:59:02 18520 8192000000 10380396848 10706034688 1441857120 14.966 100 86 172 0 1476563616 6665968 28040528
22:59:38 21604 8192000000 10425266912 10753994752 1475773312 15.264 100 91 182 0 1512308000 7474336 29060352
23:00:09 26953 8192000000 10445722896 10776424448 1496695200 15.447 100 91 182 0 1534214688 8116544 29402944
23:00:45 22889 8192000000 10462334480 10798514176 1514828448 15.605 100 87 174 2 1551791248 8714592 28248208
23:01:18 16787 8192000000 10486703056 10828746752 1539960768 15.823 100 89 178 1 1577224256 9246960 28016528
23:01:51 19416 8192000000 10498507184 10846892032 1559945584 15.996 100 82 164 1 1595053472 9609920 25497968
23:02:21 11291 8192000000 10517278064 10871246848 1575999120 16.134 100 76 152 0 1608918624 9817776 23101728
23:02:47 6156 8192000000 10559840160 10917732352 1617624512 16.490 100 74 148 0 1650206992 10123792 22458688
23:03:04 10753 8192000000 10578762208 10936844288 1637553632 16.659 100 81 162 2 1672245280 10626640 24065008
23:03:29 9459 8192000000 10593924736 10962968576 1659825888 16.847 100 74 148 0 1693371136 11886736 21658512
23:03:47 10401 8192000000 10627361216 10990493696 1680222064 17.019 100 77 154 0 1714482704 11814896 22445744
23:04:05 8123 8192000000 10633582288 11004194816 1695907712 17.151 100 79 157 0 1730666368 11866960 22891696
23:04:25 10582 8192000000 10664877168 11037196288 1723506576 17.381 100 83 165 0 1759739600 12381792 23851232
23:04:43 5255 8192000000 10676676912 11048513536 1733681568 17.466 100 83 166 4 1771150640 13699632 23769440
23:05:00 9080 8192000000 10681087248 11061280768 1747600768 17.582 100 75 150 0 1781775520 13467520 20707232
23:05:16 4207 8192000000 10699228960 11078893568 1761367776 17.696 100 78 156 1 1795523744 12481072 21674896
23:05:29 5051 8192000000 10711916704 11090096128 1773307232 17.794 100 75 149 0 1807195600 13053904 20834464
23:05:41 5520 8192000000 10725587392 11107446784 1789801936 17.930 100 79 158 1 1825061392 13432496 21826960
23:05:53 4339 8192000000 10741082144 11123298304 1797023552 17.989 100 83 165 2 1832055680 12271712 22760416
23:06:04 3802 8192000000 10749100144 11129204736 1802401824 18.034 100 83 166 0 1839099392 13659456 23038112
23:06:15 7154 8192000000 10750648800 11130327040 1805297712 18.057 100 81 162 0 1842186672 14746976 22141984
23:06:29 4076 8192000000 10757764960 11145388032 1813362752 18.123 100 81 162 1 1850062496 13962624 22737120
23:06:40 4225 8192000000 10773520768 11161645056 1824210384 18.212 100 82 164 0 1861073824 13654832 23208608
23:06:51 2694 8192000000 10776332320 11164381184 1841394928 18.352 100 88 174 0 1879373712 13127024 24851760
23:07:00 2698 8192000000 10783511248 11172917248 1843719920 18.371 100 87 173 1 1880384992 12710128 23954944
23:07:09 2668 8192000000 10793058992 11179937792 1851097136 18.431 100 85 170 0 1889129232 13543616 24488480
23:07:18 2231 8192000000 10796678528 11183108096 1853169584 18.448 100 80 160 2 1887784592 12836256 21778752
23:07:27 1809 8192000000 10797915088 11187200000 1861061232 18.512 100 85 167 0 1895924400 11643376 23219792
23:07:35 1673 8192000000 10809571728 11197206528 1862492608 18.523 100 89 181 0 1901117264 12830320 25794336
23:07:44 2419 8192000000 10805646032 11199356928 1867557424 18.565 100 89 177 2 1905236304 13097904 24580976
23:07:52 1347 8192000000 10819167824 11207540736 1870547472 18.589 100 91 182 3 1909790336 13755024 25487840
23:08:00 2271 8192000000 10816712480 11206578176 1872264752 18.603 100 91 184 0 1911171520 13476368 25430400
23:08:09 1393 8192000000 10817921248 11210100736 1870439520 18.588 100 88 176 1 1909757120 14021472 25296128
23:08:17 1883 8192000000 10823845072 11212341248 1873978800 18.616 100 91 182 0 1914240432 14332912 25928720
23:08:25 12567 8192000000 10817602688 11211071488 1875225408 18.627 100 70 140 1 1905676624 10788992 19662224
23:08:44 12535 8192000000 10819737344 11222069248 1881499152 18.677 100 73 142 0 1912895312 10421856 20974304
23:09:03 17436 8192000000 10802270640 11218739200 1889004816 18.738 100 70 140 0 1919933760 10924960 20003984
23:09:27 11446 8192000000 10807139952 11219529728 1884665616 18.703 100 37 74 1 1901864400 6323648 10875136
23:09:46 6334 8192000000 10800946576 11222581248 1884622400 18.702 100 38 74 2 1902592336 8159632 9810304
23:09:58 4590 8192000000 10810037664 11224903680 1889497120 18.742 100 39 78 5 1908230160 8421248 10311792
23:10:10 9345 8192000000 10813968544 11223654400 1887515536 18.726 100 21 42 0 1899332240 6262208 5554496
23:10:26 6092 8192000000 10797082848 11226083328 1891982912 18.762 100 23 46 0 1906112736 7789920 6339904
23:10:38 6168 8192000000 10794704448 11227262976 1890251968 18.748 100 24 48 2 1903388016 6652368 6483680
23:10:51 10307 8192000000 10808125344 11233284096 1893710672 18.776 100 18 36 1 1904873040 6305792 4856576
23:11:08 7390 8192000000 10805258048 11233607680 1896740512 18.800 100 19 37 3 1907431408 5855280 4835616
23:11:22 11059 8192000000 10805758272 11240951808 1897200352 18.804 100 16 32 0 1911690752 10288736 4201664
23:11:40 11202 8192000000 10804865120 11240075264 1901097712 18.835 100 17 34 1 1912046224 5862752 5085760
23:11:58 11723 8192000000 10800378208 11239710720 1903763376 18.857 100 22 44 1 1916563824 6829776 5970672
23:12:17 6863 8192000000 10810211632 11241140224 1903569472 18.855 100 19 38 0 1915013664 6176208 5267984
23:12:30 14205 8192000000 10812153120 11244355584 1904957008 18.866 100 11 22 0 1913518560 5714896 2846656
23:12:52 13771 8192000000 10804365040 11247181824 1910430976 18.910 100 21 42 0 1922596832 6098800 6067056
23:13:17 70656 8192000000 10826033712 11259285504 1912865616 18.930 100 29 58 1 1926590176 5422480 8302080
23:14:35 16097 8192000000 10837072224 11258298368 1893940176 18.778 99 29 58 3 1907598016 5874672 7783168
23:15:01 6695 8192000000 10819732576 11257462784 1906115088 18.875 100 17 32 3 1916584864 6144672 4325104
23:15:16 2878 8192000000 10845132512 11271880704 1919718736 18.985 100 34 68 1 1936566912 6733040 10115136
23:15:26 7855 8192000000 10835466272 11270746112 1921147408 18.996 100 23 46 3 1934483008 6513008 6822592
23:15:43 12558 8192000000 10840580864 11272876032 1923328896 19.014 100 30 58 0 1938609520 6742848 8537776
23:16:05 6905 8192000000 10832057120 11261911040 1897880416 18.809 99 21 43 0 1909245648 5367872 5997360
23:16:23 8055 8192000000 10813517824 11247779840 1901774000 18.841 100 21 42 0 1913768160 6169008 5825152
23:16:37 10505 8192000000 10792247472 11232940032 1832471008 18.279 96 17 35 0 1842946080 4939712 5535360
23:16:56 7614 8192000000 10802666752 11234217984 1885324064 18.708 100 25 51 0 1898403680 6117360 6962256
23:17:12 8659 8192000000 10790757488 11220332544 1869665968 18.582 99 22 44 4 1885391616 9585200 6140448
23:17:30 12588 8192000000 10800708688 11231440896 1867659424 18.565 99 15 30 1 1877770576 5997136 4114016
23:17:49 8323 8192000000 10773683568 11206316032 1819203936 18.171 97 12 24 0 1828056960 5279552 3573472
23:18:04 18344 8192000000 10784692416 11211251712 1838332144 18.327 98 18 36 1 1849349296 5202736 5814416
23:18:34 48600 8192000000 10722716272 11149545472 1715670032 17.316 92 35 70 3 1732031552 6754176 9607344
23:19:31 9455 8192000000 10734929312 11165880320 1801307440 18.025 98 13 26 1 1810320960 5256480 3757040
23:19:47 11157 8192000000 10755835632 11178971136 1766353088 17.737 95 30 60 1 1781310368 6915312 8041968
23:20:07 7429 8192000000 10719043856 11130482688 1696272816 17.154 93 26 52 3 1707995008 5128704 6593488
23:20:22 4688 8192000000 10694400016 11103453184 1729640880 17.433 96 25 49 0 1741686224 5061984 6983360
23:20:36 6260 8192000000 10700370704 11111452672 1741887360 17.534 97 31 62 1 1756699088 5507184 9304544
23:20:53 8920 8192000000 10711327648 11132456960 1783174544 17.876 99 28 56 0 1798789552 7031696 8583312
23:21:11 6203 8192000000 10647416272 11057364992 1682842000 17.041 94 27 55 1 1695910656 4713248 8355408
23:21:24 4293 8192000000 10705558240 11120824320 1790417744 17.935 100 35 70 1 1807923872 7085888 10420240
23:21:37 10947 8192000000 10715746416 11135483904 1801394288 18.025 100 34 68 0 1817695152 5832400 10468464
23:21:54 8941 8192000000 10726398608 11145437184 1790170064 17.933 99 33 65 1 1806064880 5858704 10036112
23:22:09 7644 8192000000 10739735952 11152883712 1789337088 17.926 98 37 74 0 1805733952 4231312 12165552
23:22:24 10125 8192000000 10719929392 11135332352 1763852736 17.716 97 20 40 1 1775458880 5822224 5783920
23:22:41 10196 8192000000 10731999264 11155664896 1806777744 18.069 99 29 58 0 1821519616 5666016 9075856
23:23:01 58074 8192000000 10763250400 11172966400 1831242816 18.269 100 30 60 2 1845786464 5110912 9432736
23:24:07 23418 8192000000 10750397600 11181420544 1836063136 18.309 100 21 42 0 1847716240 5384640 6268464
23:24:38 6340 8192000000 10777802528 11194531840 1846168112 18.391 100 31 63 1 1860821600 5870528 8782960
23:24:50 7204 8192000000 10775632416 11199909888 1853231024 18.448 100 35 70 0 1869701680 6703344 9767312
23:25:06 5693 8192000000 10784583744 11206635520 1865146304 18.545 100 43 87 1 1884323824 6925344 12252176
23:25:20 7548 8192000000 10778543072 11204820992 1864430448 18.539 100 28 55 1 1878718016 6127120 8160448
23:25:36 5448 8192000000 10791207008 11213066240 1868577456 18.573 100 27 54 4 1881016832 5259808 7179568
23:25:49 6642 8192000000 10793408480 11217129472 1869301600 18.579 100 30 58 1 1882757632 5498768 7957264
23:26:04 7534 8192000000 10799093312 11222044672 1874575840 18.621 100 33 66 1 1890916048 5723904 10616304
23:26:17 8605 8192000000 10800853824 11223523328 1875336000 18.627 100 20 41 0 1886400064 5280240 5783824
23:26:34 5908 8192000000 10791446960 11226157056 1880118544 18.666 100 29 58 1 1894969456 6318096 8532816
23:26:47 10395 8192000000 10805561024 11232661504 1882844288 18.688 100 16 32 1 1892462352 4897936 4720128
23:27:09 8733 8192000000 10813391824 11245887488 1898423696 18.814 100 16 32 0 1907739168 4842656 4472816
23:27:24 29568 8192000000 10828211264 11254669312 1905955008 18.874 100 23 45 1 1918328400 5406576 6966816
23:28:18 6921 8192000000 10864190048 11282718720 1925691632 19.032 100 47 94 0 1951486832 12523184 13272016
23:28:34 56111 8192000000 10871549696 11298607104 1942109488 19.164 100 50 100 1 1970993744 13956288 14927968
23:29:38 55593 8192000000 10877224208 11313557504 1951685056 19.240 100 59 120 1 1982715456 13809296 17221104
23:31:07 41373 8192000000 10877575040 11323568128 1948045136 19.211 100 20 41 0 1971348208 16513248 6789824
23:31:55 13969 8192000000 10890185504 11329458176 1955463488 19.270 100 31 61 1 1981578448 16123856 9991104
23:32:20 8193 8192000000 10900176320 11331743744 1963172944 19.331 100 47 93 0 1991168768 14682864 13312960
23:32:35 34873 8192000000 10901205824 11333808128 1961400768 19.317 100 55 106 1 1993570864 17106896 15063200
23:33:42 4205 8192000000 10918196272 11346456576 1972196384 19.403 100 53 104 1 2005587232 18404256 14986592
23:33:57 16023 8192000000 10920984288 11351236608 1972825792 19.408 100 49 98 0 2006261856 19305440 14130624
23:34:22 13847 8192000000 10923375904 11331203072 1953713072 19.256 99 65 129 0 1993018016 19783168 19521776
23:34:43 10012 8192000000 10933794896 11357855744 1974088960 19.418 100 79 158 2 2020210496 23359488 22762048
23:35:03 1205 8192000000 10933238704 11354349568 1975231440 19.427 100 75 149 2 2022183712 24330272 22622000
23:35:13 8382 8192000000 10923922912 11349250048 1972092608 19.402 100 63 123 0 2012132640 21892416 18147616
23:35:29 24934 8192000000 10926380400 11358154752 1973691536 19.415 100 43 86 4 2006725456 20915632 12118288
23:36:01 9272 8192000000 10925982624 11365683200 1981341280 19.475 100 48 95 3 2018009952 22718720 13949952
23:36:18 6318 8192000000 10938203952 11373187072 1990040528 19.544 100 63 126 0 2032587792 23222240 19325024
23:36:36 4894 8192000000 10949742224 11382108160 1996422304 19.595 100 56 112 3 2038361536 24274688 17664544
23:36:49 3153 8192000000 10958373296 11383857152 2003071680 19.647 100 67 133 0 2048610960 26017072 19522208
23:36:59 4136 8192000000 10972886288 11397615616 2005384640 19.665 100 77 153 1 2059273104 31568560 22319904
23:37:14 7504 8192000000 10969891136 11389976576 2004345728 19.657 100 73 146 2 2053643488 27787344 21510416
23:37:29 4413 8192000000 10954268512 11369099264 1987512080 19.524 99 78 154 3 2038548208 27742368 23293760
23:37:41 8496 8192000000 10959314256 11384909824 1994935520 19.583 100 61 122 1 2043891360 30680688 18275152
23:37:58 7231 8192000000 10965987712 11392118784 2001051024 19.631 100 61 123 1 2050530000 30797952 18681024
23:38:19 16268 8192000000 10958779792 11396026368 2001245408 19.633 100 50 97 1 2045035664 29429072 14361184
23:38:43 6098 8192000000 10976170912 11404636160 2011710480 19.715 100 69 134 0 2064743136 32804048 20228608
23:38:57 8514 8192000000 10977155552 11404550144 2008667200 19.691 100 70 140 0 2063832192 34073088 21091904
23:39:14 7818 8192000000 10975804352 11408781312 2013545456 19.729 100 71 141 1 2068955456 34080032 21329968
23:39:31 6687 8192000000 10979528176 11405381632 1995214816 19.585 99 62 123 0 2048569360 34494704 18859840
23:39:44 5469 8192000000 10980928640 11401080832 2004261632 19.656 100 72 144 1 2062249008 36218496 21768880
23:39:56 2694 8192000000 10965156896 11389853696 1990637664 19.549 99 70 138 0 2046073696 34255984 21180048
23:40:09 12167 8192000000 10975446208 11408609280 2007902144 19.685 100 59 118 0 2060635392 34720400 18012848
23:40:29 3032 8192000000 10993018880 11412983808 2014417696 19.736 100 81 163 4 2076051872 36087216 25546960
23:40:41 2816 8192000000 10980938096 11403370496 2007148736 19.679 100 68 134 2 2065563280 37491728 20922816
23:40:55 6691 8192000000 10977068480 11403419648 1992449856 19.563 99 72 142 4 2054164544 39742640 21972048
23:41:08 1827 8192000000 10978320224 11404148736 2000985872 19.631 100 70 138 1 2063535584 40934432 21615280
23:41:17 3097 8192000000 10994374944 11414892544 2008379552 19.689 100 82 163 1 2073866608 40177792 25309264
23:41:27 5052 8192000000 10974128976 11399348224 1981731536 19.478 99 75 150 0 2046952480 41916368 23304576
23:41:43 4815 8192000000 10978832496 11412193280 1999066832 19.615 100 61 121 1 2062023552 44738704 18218016
23:41:56 5296 8192000000 10968911520 11399090176 1965515360 19.350 98 57 112 1 2028511104 44848352 18147392
23:42:09 5963 8192000000 10976492352 11403853824 1998801264 19.613 100 76 152 3 2060662352 38436016 23425072
23:42:23 6896 8192000000 10948692400 11375947776 1973832800 19.416 99 62 120 1 2031444624 38030672 19581152
23:42:38 4611 8192000000 10956737312 11386695680 1982542464 19.485 99 75 151 1 2045814288 39905984 23365840
23:42:51 4731 8192000000 10962299104 11385659392 1981438240 19.476 100 73 145 4 2044849952 41052016 22359696
23:43:05 2519 8192000000 10972351120 11390894080 1982866320 19.487 100 89 175 0 2053603680 43141936 27595424
23:43:17 5974 8192000000 10969805632 11390607360 1981740864 19.478 100 87 174 0 2051936352 43505488 26690000
23:43:37 2615 8192000000 10934262992 11346673664 1953338944 19.253 100 83 164 2 2012779280 34556592 24883744
23:43:47 5458 8192000000 10950170064 11370180608 1966048336 19.354 100 74 148 3 2026882400 37947712 22886352
23:43:59 3018 8192000000 10952258416 11373494272 1963116720 19.331 99 92 182 1 2029541616 38409952 28014944
23:44:09 2273 8192000000 10953507792 11368038400 1958328016 19.293 99 88 176 3 2023260096 37984256 26947824
23:44:18 3707 8192000000 10956322704 11374006272 1974096752 19.418 100 78 155 3 2036611072 39098512 23415808
23:44:30 3996 8192000000 10954608624 11375759360 1976668944 19.438 100 77 152 2 2038552528 38422000 23461584
23:44:42 4735 8192000000 10956525872 11378614272 1978900320 19.456 100 71 139 3 2040793520 39381616 22511584
23:44:56 10846 8192000000 10917436912 11347324928 1949565936 19.223 99 52 104 2 2002140496 36739488 15835072
23:45:15 13137 8192000000 10920707264 11347992576 1919473712 18.983 98 51 102 0 1971425392 36085504 15866176
23:45:36 3795 8192000000 10923877824 11351007232 1952935472 19.250 100 54 106 0 2007597264 37758880 16902912
23:45:54 8223 8192000000 10889919792 11327557632 1905292544 18.869 98 41 82 2 1955462352 35867408 14302400
23:46:14 2176 8192000000 10924269856 11347488768 1938054432 19.131 99 73 146 1 1997810256 36575968 23179856
23:46:24 8069 8192000000 10905721744 11343872000 1930201744 19.068 99 45 90 2 1981312976 36953408 14157824
23:46:39 7152 8192000000 10884176192 11316862976 1881685120 18.679 97 39 78 2 1932885248 38301376 12898752
23:46:58 10218 8192000000 10898573376 11335176192 1934228320 19.101 100 37 74 3 1983911872 37957808 11725744
23:47:18 9465 8192000000 10893771536 11336593408 1924754784 19.025 99 30 60 1 1973370384 38165520 10450080
23:47:40 3384 8192000000 10929579024 11346821120 1947587552 19.207 100 63 126 1 2004365824 36792784 19985488
23:47:52 2088 8192000000 10931784688 11346997248 1936148944 19.116 99 73 144 0 1997891200 39142432 22599824
23:48:01 5553 8192000000 10938814736 11345121280 1940386128 19.150 99 77 151 0 2005907232 42605136 22915968
23:48:16 2927 8192000000 10941350624 11355762688 1951363280 19.237 100 80 159 0 2020600944 44118272 25119392
23:48:27 9498 8192000000 10922610960 11355394048 1943052832 19.171 100 39 78 1 2001430608 45724784 12652992
23:48:48 8835 8192000000 10901901872 11335782400 1901052192 18.835 98 26 52 0 1957708544 47749632 8906720
23:49:08 6445 8192000000 10932324880 11353300992 1941780992 19.161 100 59 118 1 2012131328 50624592 19725744
23:49:23 9043 8192000000 10927915840 11363876864 1949347168 19.221 100 46 92 0 2012549440 48122576 15079696
23:49:38 16043 8192000000 10917074320 11357650944 1941852432 19.162 100 34 66 0 2001338400 47964960 11521008
23:50:01 23441 8192000000 10923120224 11373330432 1951240416 19.236 100 37 74 1 2011353776 47895568 12217792
23:50:31 22594 8192000000 10925671776 11366629376 1936641280 19.120 99 36 72 0 1998311360 49824032 11846048
23:51:01 18572 8192000000 10909490064 11346649088 1926990000 19.043 99 27 54 3 1979867584 43555568 9322016
23:51:27 18437 8192000000 10896739984 11338481664 1919217024 18.981 99 30 59 1 1964793984 35258000 10318960
23:51:53 18302 8192000000 10892419328 11337269248 1915467472 18.951 99 24 48 1 1964012304 40130880 8413952
23:52:19 18064 8192000000 10903002032 11346292736 1938463616 19.134 100 32 63 3 1987130800 37945952 10721232
23:52:56 40399 8192000000 10903067568 11361624064 1937890480 19.130 100 20 40 0 1991738752 46503328 7344944
23:53:45 19431 8192000000 10902717200 11363708928 1937635072 19.128 100 22 43 4 1990117232 44902288 7579872
23:54:13 26983 8192000000 10913828784 11365863424 1943121328 19.172 100 27 54 2 1992062944 40197984 8743632
23:54:47 22235 8192000000 10898864112 11356889088 1929062608 19.059 99 21 40 1 1970793184 34085744 7644832
23:55:16 5569 8192000000 10913821536 11350515712 1952498480 19.246 100 43 86 2 1991467248 25616096 13352672
23:55:38 33293 8192000000 10888278768 11329966080 1940717616 19.152 99 41 79 2 1969808720 16922288 12168816
23:56:18 20010 8192000000 10884054496 11340660736 1935486064 19.111 99 30 60 1 1963662032 19212336 8963632
23:56:48 43425 8192000000 10870228496 11319726080 1890623392 18.751 97 24 48 0 1917949424 19638288 7687744
23:58:07 34030 8192000000 10880810016 11348557824 1924193120 19.020 99 17 34 2 1958237840 28303968 5740752
23:59:51 99832 8192000000 10890622224 11349819392 1924118576 19.020 99 7 14 1 1941389120 15906768 1363776
00:01:48 65342 8192000000 10891258016 11344867328 1924442048 19.022 98 27 54 1 1939293904 6841376 8010480
00:03:00 45653 8192000000 10905433936 11367608320 1960861792 19.313 100 6 13 0 1974371760 12337424 1172544
00:04:30 106796 8192000000 10916818048 11370012672 1961426640 19.317 99 13 26 1 1975793888 11506880 2860368
00:06:33 49326 8192000000 10906556880 11367333888 1939017584 19.139 98 7 14 1 1948350528 7544912 1788032
00:07:36 50927 8192000000 10940620208 11393003520 1979704416 19.462 100 9 18 0 1998657056 16421760 2530880
00:09:12 68930 8192000000 10917413040 11390210048 1964191568 19.339 99 5 10 0 1986568064 21019184 1357312
00:10:27 67715 8192000000 10932978096 11399774208 1971903168 19.401 99 13 26 1 1985209152 9850208 3455776
00:11:42 68803 8192000000 10959696608 11409551360 1990589184 19.548 100 10 20 1 2013481872 20286480 2606208
00:12:57 61666 8192000000 10927739344 11390423040 1953695280 19.256 98 8 16 1 1972950656 16993136 2262240
00:14:07 123682 8192000000 10918271728 11378425856 1954089776 19.259 98 16 32 0 1971398320 12439504 4869040
00:16:17 13947 8192000000 10932524624 11388706816 1998857648 19.614 100 34 66 1 2015247776 6836704 9553424
00:16:45 75011 8192000000 10938815888 11394228224 1981503312 19.477 99 50 98 3 2002510768 7804816 13202640
00:18:16 66133 8192000000 10937598496 11388768256 1993725504 19.573 100 42 86 2 2015297488 8774400 12797584
00:19:31 68357 8192000000 10917947120 11389784064 1981541552 19.477 99 15 30 2 1993928592 7934144 4452896
00:20:47 45316 8192000000 10901798320 11356848128 1884653280 18.703 94 30 60 1 1899835824 6668160 8514384
00:21:41 74226 8192000000 10940520544 11390517248 1930232592 19.069 97 26 52 2 1950041728 12064384 7744752
00:23:02 51194 8192000000 10935585792 11395186688 1981763824 19.479 99 47 94 1 2011472576 16031936 13676816
00:24:14 41794 8192000000 10911526336 11398098944 1968239008 19.371 99 28 56 0 1997874080 21793728 7841344
00:25:02 23605 8192000000 10903155824 11401842688 1979985168 19.465 100 17 34 0 1998906304 13996560 4924576
00:25:32 101118 8192000000 10864736720 11345539072 1860896912 18.511 94 6 12 0 1874991968 12419744 1675312
00:27:20 34996 8192000000 10871185584 11354820608 1948385088 19.214 100 11 22 1 1961950624 10248080 3317456
00:28:04 53723 8192000000 10883390656 11359670272 1927512032 19.047 98 13 26 0 1941883200 10586288 3784880
00:29:43 41806 8192000000 10898793168 11373780992 1953705488 19.256 99 13 26 0 1965182720 7913008 3564224
00:30:39 52524 8192000000 10893224784 11381133312 1970296864 19.388 100 13 26 1 1983458992 9822464 3339664
00:31:38 41398 8192000000 10851629696 11315761152 1796297328 17.984 91 17 34 1 1807053840 6317168 4439344
00:32:25 51382 8192000000 10878165264 11330117632 1855676048 18.468 95 31 61 2 1874573904 10648272 8249584
00:33:23 46152 8192000000 10848674080 11314622464 1875965008 18.633 97 20 40 1 1893120816 11302944 5852864
00:34:33 52364 8192000000 10881464320 11335045120 1869801072 18.583 97 15 30 0 1881932000 8149472 3981456
00:35:35 59236 8192000000 10884884400 11345768448 1923723056 19.017 99 47 92 1 1950058496 13485056 12850384
00:37:23 64130 8192000000 10845130688 11314688000 1866587872 18.557 97 14 28 0 1881963216 11043808 4331536
00:38:37 63874 8192000000 10866705872 11328622592 1894727920 18.784 98 23 45 5 1915830480 13722320 7380240
00:40:34 53698 8192000000 10860189296 11334270976 1886127904 18.715 98 13 26 0 1904386400 14843568 3414928
00:41:34 29786 8192000000 10855828832 11322142720 1893040688 18.770 98 7 12 0 1902799696 8268288 1490720
00:42:14 71532 8192000000 10864102112 11320782848 1862124416 18.521 96 30 58 2 1880076288 9849008 8102864
00:43:36 48252 8192000000 10866990768 11325247488 1888295040 18.732 97 45 90 1 1909862640 9828800 11738800
00:45:11 70066 8192000000 10847790368 11310542848 1853528368 18.451 96 27 54 1 1869034832 7764080 7742384
00:46:29 84599 8192000000 10807349232 11280486400 1846131104 18.391 96 25 50 1 1866745936 13452064 7162768
00:48:00 29412 8192000000 10859200736 11305476096 1896516096 18.798 99 33 66 1 1918854896 12771232 9567568
00:48:37 41472 8192000000 10853076384 11316322304 1925055392 19.027 100 34 67 2 1946997776 12353680 9588704
00:49:25 53529 8192000000 10849511872 11336638464 1928473664 19.055 100 15 30 1 1947553136 14460752 4618720
00:50:39 35292 8192000000 10875624480 11348008960 1942822480 19.169 100 17 34 1 1956873536 8576320 5474736
00:51:22 56928 8192000000 10880503248 11353907200 1948178048 19.212 100 17 34 0 1967450304 14495152 4777104
00:52:25 77389 8192000000 10868417344 11349139456 1932646480 19.088 99 11 22 0 1946466464 10269696 3550288
00:55:08 57191 8192000000 10862964064 11343577088 1941001712 19.155 99 20 40 1 1958051776 11554704 5495360
00:56:19 54103 8192000000 10870109856 11363299328 1933208640 19.093 99 9 18 0 1948623952 12784848 2630464
00:57:19 55836 8192000000 10882115840 11363794944 1919604256 18.984 98 16 32 0 1934909632 11499072 3806304
00:58:25 55542 8192000000 10896120048 11369017344 1946544144 19.199 99 22 44 0 1960341744 8168848 5628752
00:59:27 57919 8192000000 10896146864 11378143232 1953616960 19.255 99 13 26 0 1965811952 8587760 3607232
01:00:31 46034 8192000000 10903117872 11379314688 1957514208 19.286 99 15 30 0 1969670944 7961776 4194960
01:01:23 38993 8192000000 10888671328 11359563776 1917557536 18.967 97 18 36 0 1929858240 7487920 4812784
01:02:09 32126 8192000000 10910592544 11358330880 1916088144 18.955 97 45 90 4 1945103136 16042384 12972608
01:02:52 51536 8192000000 10904785904 11386712064 1967520752 19.366 100 40 80 1 1995861344 17390768 10949824
01:03:50 81182 8192000000 10914341712 11388329984 1945178064 19.188 99 15 30 1 1963719440 14472768 4068608
01:05:17 70563 8192000000 10890513536 11361046528 1902391776 18.846 96 17 34 0 1926479088 19370784 4716528
01:07:20 48658 8192000000 10898526416 11383382016 1950768944 19.233 100 9 18 0 1977990496 24909408 2312144
01:08:55 10808 8192000000 10899507968 11359469568 1962147152 19.323 100 33 66 3 1979990928 9053328 8790448
01:09:12 38801 8192000000 10903137968 11363688448 1910412704 18.910 97 31 62 4 1927958976 9066336 8479936
01:09:58 35687 8192000000 10905518960 11360092160 1942468608 19.166 99 31 62 0 1962629104 11388720 8771776
01:10:40 52974 8192000000 10909674496 11389161472 1971253408 19.395 100 45 90 1 2001349584 17072496 13023680
01:11:44 64577 8192000000 10900377664 11385225216 1951782544 19.241 99 6 12 0 1971542928 18063104 1697280
01:13:43 73717 8192000000 10893191808 11367862272 1939797440 19.145 98 24 48 5 1959802928 13131104 6874384
01:15:03 72116 8192000000 10868958464 11360108544 1907732656 18.888 97 13 24 1 1922313056 10453376 4127024
01:16:38 38332 8192000000 10867269776 11344297984 1941359744 19.158 99 12 24 1 1956753808 11672592 3721472
01:17:27 67328 8192000000 10860812752 11343663104 1912874928 18.930 98 12 24 0 1923879152 7539744 3464480
01:18:42 64160 8192000000 10838559616 11320455168 1842690672 18.363 95 11 22 0 1854638384 8964064 2983648
01:19:52 54341 8192000000 10870792464 11332882432 1931966256 19.083 100 26 51 1 1945963904 6713280 7284368
01:20:55 63632 8192000000 10866442944 11352436736 1948659280 19.216 100 30 60 0 1970240656 13177520 8403856
01:22:05 79606 8192000000 10858674832 11341844480 1839326480 18.335 94 13 26 1 1852083920 9054816 3702624
01:23:45 64666 8192000000 10850534320 11312517120 1801573584 18.027 92 28 56 0 1823490528 13352048 8564896
01:24:59 55878 8192000000 10878096976 11351224320 1917433792 18.966 99 30 60 1 1943829984 17373600 9022592
01:26:13 88840 8192000000 9645509872 9998327808 775051616 8.643 40 11 20 1 794456448 15754096 3650736

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 03-04-2021 01:29:14 to 03-04-2021 01:29:45.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 141 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 03-04-2021 01:29:46 to 03-04-2021 01:29:48.

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          241244
MON$OLDEST_ACTIVE               241245
MON$OLDEST_SNAPSHOT             241245
MON$NEXT_TRANSACTION            241245
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                       2046304
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.33431 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33431 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33431 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33431 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 ---
:33: 
:34: mscs-test-161.budzdorov.ru    Sat Apr  3 01:27:50 2021
:35:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:36: 
--- end of diff output ---

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

03.04.21 01:29:49. 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-04-03 01:29:51 No severe PSQL-related problems occured
03.04.21 01:29:53. End of report.