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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17383212 kB
MemAvailable 31471020 kB
Buffers 0 kB
Cached 14258084 kB
SwapCached 0 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-26 01:27:22
DTS_END                         2021-03-26 01:27:22.0760
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/51800
TRN_ID                          234978
ATT_ID                          647
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: 9540.63 18621 1144875
customer order: creation 168.42 386 20210
customer order: refuse 14.25 334 1710
order to supplier: creation 45.10 1403 5412
order to supplier: removal 3.56 98854 427
invoice (draft): creation 44.85 3636 5382
invoice (draft): removal 56.32 792 6758
invoice accept: apply 40.91 18406 4909
invoice accept: cancel 51.52 824 6182
customer reserve: creation 3776.73 181 453208
customer reserve: removal 5032.32 55 603878
realization accept: apply 82.45 191 9894
realization accept: cancel 97.35 103 11682
payment from customer: creation 57.99 115 6959
payment from customer: removal 5.61 90 673
payment to supplier: creation 48.28 137 5793
payment to supplier: removal 3.46 100 415
service: total inventory turnovers 4.83 1029 579
service: total monetary turnovers 5.96 26 715
service: aggregate perf. data 0.71 23837 85
service: refresh index statistics 0.03 221918 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 26-03-2021 01:28:05 to 26-03-2021 01:28:07.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5552
TEST_TIME 2 4425
TEST_TIME 3 3486
TEST_TIME 4 4538
TEST_TIME 5 4356
TEST_TIME 6 5008
TEST_TIME 7 5185
TEST_TIME 8 5451
TEST_TIME 9 6159
TEST_TIME 10 6234
TEST_TIME 11 6192
TEST_TIME 12 6606
TEST_TIME 13 6571
TEST_TIME 14 6980
TEST_TIME 15 7185
TEST_TIME 16 7383
TEST_TIME 17 7364
TEST_TIME 18 7785
TEST_TIME 19 8206
TEST_TIME 20 8334
TEST_TIME 21 9135
TEST_TIME 22 9012
TEST_TIME 23 9077
TEST_TIME 24 9108
TEST_TIME 25 9290
TEST_TIME 26 9419
TEST_TIME 27 9659
TEST_TIME 28 10950
TEST_TIME 29 10813
TEST_TIME 30 10725
TEST_TIME 31 10847
TEST_TIME 32 10688
TEST_TIME 33 10540
TEST_TIME 34 10423
TEST_TIME 35 10269
TEST_TIME 36 10274
TEST_TIME 37 10115
TEST_TIME 38 9990
TEST_TIME 39 9980
TEST_TIME 40 9996
TEST_TIME 41 10010
TEST_TIME 42 9914
TEST_TIME 43 9874
TEST_TIME 44 9820
TEST_TIME 45 9712
TEST_TIME 46 9826
TEST_TIME 47 10004
TEST_TIME 48 9932
TEST_TIME 49 9879
TEST_TIME 50 9881
TEST_TIME 51 9884
TEST_TIME 52 9907
TEST_TIME 53 9937
TEST_TIME 54 9916
TEST_TIME 55 9934
TEST_TIME 56 9992
TEST_TIME 57 9961
TEST_TIME 58 10021
TEST_TIME 59 9951
TEST_TIME 60 9795
TEST_TIME 61 9718
TEST_TIME 62 9666
TEST_TIME 63 9659
TEST_TIME 64 9617
TEST_TIME 65 9556
TEST_TIME 66 9496
TEST_TIME 67 9533
TEST_TIME 68 9500
TEST_TIME 69 9506
TEST_TIME 70 9543
TEST_TIME 71 9498
TEST_TIME 72 9476
TEST_TIME 73 9444
TEST_TIME 74 9625
TEST_TIME 75 9649
TEST_TIME 76 9658
TEST_TIME 77 9686
TEST_TIME 78 9731
TEST_TIME 79 9739
TEST_TIME 80 9659
TEST_TIME 81 9587
TEST_TIME 82 9536
TEST_TIME 83 9524
TEST_TIME 84 9433
TEST_TIME 85 9372
TEST_TIME 86 9417
TEST_TIME 87 9394
TEST_TIME 88 9442
TEST_TIME 89 9490
TEST_TIME 90 9495
TEST_TIME 91 9510
TEST_TIME 92 9499
TEST_TIME 93 9533
TEST_TIME 94 9597
TEST_TIME 95 9590
TEST_TIME 96 9620
TEST_TIME 97 9673
TEST_TIME 98 9644
TEST_TIME 99 9668
TEST_TIME 100 9634
TEST_TIME 101 9599
TEST_TIME 102 9578
TEST_TIME 103 9555
TEST_TIME 104 9547
TEST_TIME 105 9494
TEST_TIME 106 9452
TEST_TIME 107 9439
TEST_TIME 108 9397
TEST_TIME 109 9375
TEST_TIME 110 9480
TEST_TIME 111 9517
TEST_TIME 112 9514
TEST_TIME 113 9516
TEST_TIME 114 9508
TEST_TIME 115 9520
TEST_TIME 116 9540
TEST_TIME 117 9519
TEST_TIME 118 9550
TEST_TIME 119 9606
TEST_TIME 120 9547

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 26-03-2021 01:28:09 to 26-03-2021 01:28:12.

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 1565992 1565992 0 0.00 0 18657 6 0 0
doc_list_biud 1565992 1565992 0 0.00 0 38786 27 0 0
sp_add_invoice_to_stock 5002 4909 93 1.85 26 185310 18406 0 93
sp_cancel_adding_invoice 6182 6182 0 0.00 4 54357 824 0 0
sp_cancel_client_order 1710 1710 0 0.00 4 10879 334 0 0
sp_cancel_customer_reserve 603878 603878 0 0.00 1 38788 55 0 0
sp_cancel_pay_from_customer 673 673 0 0.00 2 6966 91 0 0
sp_cancel_pay_to_supplier 415 415 0 0.00 3 6953 101 0 0
sp_cancel_supplier_invoice 6763 6758 5 0.07 2 34063 792 0 5
sp_cancel_supplier_order 427 427 0 0.00 9 951444 98854 0 0
sp_cancel_write_off 11682 11682 0 0.00 1 17919 103 0 0
sp_client_order 20210 20210 0 0.00 3 22765 386 0 0
sp_customer_reserve 453208 453208 0 0.00 0 122673 182 0 0
sp_fill_shopping_cart 30980 30980 0 0.00 1 16762 37 0 0
sp_fill_shopping_cart_clo_res 453203 453203 0 0.00 0 17454 13 0 0
sp_get_clo_for_invoice 4901 4901 0 0.00 0 34934 349 0 0
sp_kill_cost_storno 18952 18952 0 0.00 0 7644 50 0 0
sp_kill_qstorno_ret_qs2qd 1226623 1226623 0 0.00 0 38784 30 0 0
sp_kill_qty_storno 645432 645432 0 0.00 0 38786 65 0 0
sp_lock_selected_doc 20493 20493 0 0.00 0 8214 6 0 0
sp_make_cost_storno 27547 27547 0 0.00 0 17823 59 0 0
sp_multiply_rows_for_pdistr 27547 27547 0 0.00 0 7144 27 0 0
sp_multiply_rows_for_qdistr 20210 20210 0 0.00 0 15860 168 0 0
sp_pay_from_customer 6959 6959 0 0.00 4 13638 115 0 0
sp_pay_to_supplier 5793 5793 0 0.00 5 12261 137 0 0
sp_payment_common 12752 12752 0 0.00 1 13634 32 0 0
sp_qd_handle_on_cancel_clo 1710 1710 0 0.00 0 10874 294 0 0
sp_qd_handle_on_invoice_upd_sts 11083 11083 0 0.00 0 20876 310 0 0
sp_qd_handle_on_reserve_upd_sts 9894 9894 0 0.00 0 18898 62 0 0
sp_reserve_write_off 9894 9894 0 0.00 6 18913 191 0 0
sp_supplier_invoice 5382 5382 0 0.00 7 99897 3637 0 0
sp_supplier_order 5412 5412 0 0.00 5 37807 1403 0 0
srv_aggregate_perf_data 86 85 1 1.16 3295 309101 23837 0 1
srv_fill_mon_cache_memory 154 154 0 0.00 816 126923 34380 0 0
srv_find_qd_qs_mism 1098805 1098805 0 0.00 0 15624 5 0 0
srv_make_invnt_saldo 579 579 0 0.00 34 92550 1030 0 0
srv_make_money_saldo 715 715 0 0.00 1 2074 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 141311 289562 221919 0 0
t$perf-abend:sp_add_invoice_to_stock 93 93 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 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 4910 4910 0 0.00 0 20660 182 0 0
t$perf-norm:sp_cancel_adding_invoice 432 432 0 0.00 0 9866 143 0 0
t$perf-norm:sp_cancel_client_order 1710 1710 0 0.00 0 7670 22 0 0
t$perf-norm:sp_cancel_customer_reserve 636 636 0 0.00 0 1538 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 673 673 0 0.00 0 2241 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 415 415 0 0.00 0 376 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 401 401 0 0.00 0 905 11 0 0
t$perf-norm:sp_cancel_supplier_order 427 427 0 0.00 0 31516 1551 0 0
t$perf-norm:sp_cancel_write_off 1005 1005 0 0.00 0 2245 9 0 0
t$perf-norm:sp_client_order 20210 20210 0 0.00 0 14198 18 0 0
t$perf-norm:sp_customer_reserve 964 964 0 0.00 0 8412 34 0 0
t$perf-norm:sp_pay_from_customer 6959 6959 0 0.00 0 5528 10 0 0
t$perf-norm:sp_pay_to_supplier 5793 5793 0 0.00 0 11850 14 0 0
t$perf-norm:sp_reserve_write_off 9894 9894 0 0.00 0 11834 12 0 0
t$perf-norm:sp_supplier_invoice 5382 5382 0 0.00 0 5529 21 0 0
t$perf-norm:sp_supplier_order 5413 5413 0 0.00 0 7508 15 0 0
t$perf-norm:srv_aggregate_perf_data 85 85 0 0.00 0 135 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 154 154 0 0.00 0 379 4 0 0
t$perf-norm:srv_make_invnt_saldo 579 579 0 0.00 0 4810 24 0 0
t$perf-norm:srv_make_money_saldo 715 715 0 0.00 0 6324 20 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 11 4 0 0
v_add_invoice_to_stock 9986 9800 186 1.86 0 5542 25 0 186
v_all_customers 36872 36872 0 0.00 0 121 1 0 0
v_all_suppliers 29994 29994 0 0.00 0 27 1 0 0
v_all_wares 40420 40420 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 864 864 0 0.00 0 3051 14 0 0
v_cancel_client_order 3420 3420 0 0.00 0 6808 9 0 0
v_cancel_customer_prepayment 1346 1346 0 0.00 0 3162 5 0 0
v_cancel_customer_reserve 1272 1272 0 0.00 0 3484 11 0 0
v_cancel_payment_to_supplier 830 830 0 0.00 0 6944 19 0 0
v_cancel_supplier_invoice 812 802 10 1.23 0 4586 19 0 10
v_cancel_supplier_order 854 854 0 0.00 0 1859 8 0 0
v_cancel_write_off 2010 2010 0 0.00 0 3094 16 0 0
v_max_id_clo_ord 5408 5408 0 0.00 0 257 1 0 0
v_max_id_clo_res 964 964 0 0.00 0 2862 12 0 0
v_max_id_ord_sup 5362 5362 0 0.00 0 4014 3 0 0
v_max_non_paid_invoice 1566 1566 0 0.00 0 1401 5 0 0
v_max_non_paid_realizn 3707 3707 0 0.00 0 2337 3 0 0
v_min_id_clo_ord 5408 5408 0 0.00 0 3408 7 0 0
v_min_id_clo_res 964 964 0 0.00 0 6662 16 0 0
v_min_id_ord_sup 5362 5362 0 0.00 0 6175 9 0 0
v_min_non_paid_invoice 5793 5793 0 0.00 0 4550 19 0 0
v_min_non_paid_realizn 6959 6959 0 0.00 0 13630 20 0 0
v_our_firm 10052 10052 0 0.00 0 121 1 0 0
v_reserve_write_off 19788 19788 0 0.00 0 7286 9 0 0
x_lock_depdocs_on_canc_invoice 12539 12539 0 0.00 0 9085 107 0 0
x_lock_depdocs_on_canc_sup_ord 427 427 0 0.00 0 12775 318 0 0
x_make_qstorno_1000_1200 5412 5412 0 0.00 1 37788 1317 0 0
x_make_qstorno_1200_2000 5382 5382 0 0.00 3 99882 3515 0 0
x_make_qstorno_2100_3300 453208 453208 0 0.00 0 122671 166 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 26-03-2021 01:28:13 to 26-03-2021 01:28:17.

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:25 8 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:32 6935 8192000000 10103916320 10391322624 777544976 8.668 63 51 102 0 797493104 2183584 17764544
22:57:47 23991 8192000000 10297719904 10609037312 1339555392 14.053 100 81 162 0 1370642784 4292000 26795392
22:58:19 21793 8192000000 10343668848 10658275328 1393630512 14.538 100 87 174 0 1427785104 5653904 28500688
22:58:52 18853 8192000000 10359679936 10680913920 1417938128 14.754 100 83 166 0 1453079360 6817088 28324144
22:59:23 27859 8192000000 10412320992 10737147904 1453586048 15.069 100 89 178 0 1490913024 7857600 29469376
23:00:01 8300 8192000000 10414303552 10743767040 1472280240 15.234 100 88 176 0 1509773824 8499200 28994384
23:00:21 17028 8192000000 10428200992 10760790016 1484432592 15.340 100 90 180 0 1522925776 8929296 29563888
23:00:51 20404 8192000000 10453878272 10789822464 1502820384 15.501 100 82 164 1 1537956736 8927504 26208848
23:01:26 15665 8192000000 10471019136 10813751296 1530502304 15.741 100 86 172 0 1567266240 9349920 27414016
23:01:52 11090 8192000000 10495536672 10840973312 1548993936 15.901 100 80 160 1 1583646256 9990832 24661488
23:02:16 12886 8192000000 10512412704 10865999872 1576455424 16.138 100 75 150 2 1609674512 10538416 22680672
23:02:47 16597 8192000000 10567404560 10920005632 1611902448 16.441 100 87 172 3 1648844976 11245920 25696608
23:03:17 10003 8192000000 10584907920 10945294336 1637961504 16.662 100 82 164 1 1674463696 12481632 24020560
23:03:36 10534 8192000000 10600109888 10963439616 1661795200 16.864 100 79 156 2 1697027360 12916848 22315312
23:03:53 9208 8192000000 10622619312 10987819008 1680815184 17.024 100 84 168 0 1718470992 13367856 24287952
23:04:13 6005 8192000000 10634919552 11004035072 1698214304 17.170 100 76 152 0 1733448640 13537216 21697120
23:04:26 6874 8192000000 10655609296 11025571840 1714092528 17.303 100 83 166 1 1751382080 13249472 24040080
23:04:40 8557 8192000000 10669860928 11041411072 1728283600 17.421 100 87 174 1 1767107488 13797600 25026288
23:04:56 7825 8192000000 10665009504 11045654528 1732853936 17.459 100 74 149 1 1766973456 13024176 21095344
23:05:14 6431 8192000000 10690772208 11067617280 1753638144 17.632 100 87 174 0 1790005824 11409888 24957792
23:05:27 6562 8192000000 10702431600 11081330688 1763958784 17.717 100 78 156 0 1798100656 12008368 22133504
23:05:41 4931 8192000000 10716036016 11096776704 1776040336 17.817 100 83 166 1 1811533824 12312576 23180912
23:05:54 2862 8192000000 10718747936 11101548544 1785582976 17.895 100 83 164 0 1821356384 12777904 22995504
23:06:03 4879 8192000000 10723927840 11107233792 1789277376 17.926 100 84 164 1 1824950384 12572944 23100064
23:06:15 3971 8192000000 10735214880 11118215168 1794707104 17.970 100 86 171 3 1831715936 13238192 23770640
23:06:27 3765 8192000000 10732507344 11114655744 1804759552 18.053 100 83 165 0 1842286704 14016960 23510192
23:06:37 4353 8192000000 10758536848 11142037504 1810148256 18.097 100 87 174 1 1848301824 13446112 24707456
23:06:48 3162 8192000000 10754538912 11139555328 1815222928 18.139 100 80 160 1 1850982320 12380816 23378576
23:06:58 5944 8192000000 10759050064 11147567104 1819141760 18.171 100 72 144 0 1851662192 12822944 19697488
23:07:12 4774 8192000000 10764981488 11150954496 1825157248 18.220 100 86 172 1 1862930800 13534112 24239440
23:07:23 2466 8192000000 10782674672 11166699520 1838270336 18.327 100 94 189 2 1878375824 13714960 26390528
23:07:32 2119 8192000000 10790433984 11171217408 1840094224 18.342 100 90 181 4 1879224960 13801120 25329616
23:07:41 1841 8192000000 10790342144 11175215104 1848132080 18.407 100 91 183 1 1888630944 14967536 25531328
23:07:49 2686 8192000000 10797732688 11183505408 1853634048 18.452 100 95 190 0 1895755008 15382464 26738496
23:07:58 1640 8192000000 10803637712 11187138560 1855765264 18.469 100 93 189 0 1895485296 13644880 26075152
23:08:06 1597 8192000000 10796889952 11188776960 1857432992 18.482 100 92 184 4 1896573584 12575360 26565232
23:08:14 2266 8192000000 10808688256 11197734912 1862134432 18.521 100 91 181 2 1901602688 12895472 26572784
23:08:23 3859 8192000000 10810563728 11195654144 1863806832 18.534 100 93 185 1 1903808000 13409696 26591472
23:08:33 2437 8192000000 10807679456 11196551168 1866084736 18.553 100 95 188 3 1906992752 13557872 27350144
23:08:42 3241 8192000000 10812636992 11203731456 1872177056 18.602 100 92 184 1 1910277728 11542432 26558240
23:08:52 1764 8192000000 10811330496 11204816896 1871382896 18.595 100 86 170 2 1906992576 11506528 24103152
23:09:00 29623 8192000000 10789420176 11205173248 1870914544 18.592 100 57 114 1 1898710224 11382048 16413632
23:09:36 14020 8192000000 10812617936 11209494528 1877941808 18.648 100 72 142 2 1905715552 8053968 19719776
23:09:57 1740 8192000000 10830393216 11224363008 1885042480 18.706 100 96 191 1 1922909872 9909328 27958064
23:10:05 2594 8192000000 10831638432 11223449600 1886620176 18.719 100 84 167 1 1920723392 11063712 23039504
23:10:14 7605 8192000000 10812540512 11224936448 1885160544 18.707 100 62 127 1 1913936352 11654208 17121600
23:10:29 5385 8192000000 10797632080 11216805888 1882599616 18.686 100 41 82 1 1903434016 8605984 12228416
23:10:40 4480 8192000000 10791634800 11218518016 1882529392 18.686 100 27 54 1 1897441776 7451136 7461248
23:10:53 4237 8192000000 10794023984 11221573632 1882294624 18.684 100 36 72 0 1900819104 8787312 9737168
23:11:04 9489 8192000000 10791454336 11220348928 1882274224 18.683 100 25 50 1 1896566144 6833040 7458880
23:11:26 4419 8192000000 10801107200 11227287552 1887594880 18.726 100 32 63 0 1903438832 6948240 8895712
23:11:40 6551 8192000000 10809966432 11230748672 1891770704 18.760 100 44 88 2 1911628608 7870336 11987568
23:11:57 3878 8192000000 10805739792 11232821248 1889950976 18.745 100 32 64 0 1906627840 7626736 9050128
23:12:08 9449 8192000000 10798408240 11229581312 1888588064 18.734 100 20 40 2 1900400288 6352816 5459408
23:12:24 5750 8192000000 10802688400 11232092160 1891399104 18.757 100 26 50 2 1906095760 7348480 7348176
23:12:39 9829 8192000000 10803686880 11232481280 1892666496 18.767 100 31 60 2 1907699152 6107936 8924720
23:12:58 7061 8192000000 10809754208 11230941184 1891588976 18.759 100 18 36 1 1902240704 5904192 4747536
23:13:16 12395 8192000000 10804901888 11236548608 1894713424 18.784 100 13 26 0 1904069936 5742624 3613888
23:13:35 73414 8192000000 10829385472 11254136832 1901761056 18.840 100 34 68 0 1921050784 9302816 9986912
23:14:55 5457 8192000000 10819660176 11251482624 1900695280 18.832 100 36 72 0 1919361344 8423792 10242272
23:15:08 5630 8192000000 10818480832 11250499584 1904500336 18.862 100 32 64 1 1920268944 6657744 9110864
23:15:23 6275 8192000000 10827546752 11260137472 1907146032 18.884 100 30 58 3 1922382464 6720608 8515824
23:15:36 4963 8192000000 10831607104 11263737856 1908279488 18.893 100 34 68 2 1928977312 11380848 9316976
23:15:50 7698 8192000000 10821987712 11258159104 1908278688 18.893 100 27 55 1 1922467616 6795904 7393024
23:16:03 5318 8192000000 10835435072 11261108224 1891498736 18.758 99 36 73 2 1907985152 5969056 10517360
23:16:15 4515 8192000000 10823966112 11256061952 1902047792 18.843 100 20 39 2 1913989376 6549696 5391888
23:16:26 4183 8192000000 10818258096 11248603136 1899718784 18.824 100 26 53 2 1913579952 6360848 7500320
23:16:37 8518 8192000000 10806475376 11238969344 1886307280 18.716 99 24 48 1 1899676160 6000000 7368880
23:16:52 9352 8192000000 10794622112 11234848768 1888996368 18.738 100 20 40 1 1901121872 6093872 6031632
23:17:08 8920 8192000000 10793791216 11223441408 1854346384 18.457 98 18 36 1 1865983792 6356928 5280480
23:17:25 6128 8192000000 10805178144 11234414592 1871287680 18.595 99 13 26 0 1880539664 5705536 3546448
23:17:39 14853 8192000000 10798540352 11228459008 1861410000 18.515 99 11 22 0 1874176608 9754080 3012528
23:18:06 11037 8192000000 10787007920 11213197312 1842205616 18.359 98 20 40 0 1853951312 6287760 5457936
23:18:28 61182 8192000000 10756062288 11183149056 1809999936 18.096 97 36 71 1 1825907536 5248336 10659264
23:19:39 12866 8192000000 10747488880 11170127872 1740494640 17.523 93 25 46 2 1753254528 5224768 7535120
23:20:02 4335 8192000000 10733107648 11142770688 1767858960 17.749 97 33 66 0 1783805120 6963744 8982416
23:20:12 6165 8192000000 10703805952 11113885696 1759864336 17.683 97 25 50 1 1772705552 5457904 7383312
23:20:25 5280 8192000000 10719872992 11141746688 1801161808 18.023 100 20 39 1 1813029808 6121856 5746144
23:20:38 6064 8192000000 10706255520 11105943552 1714781136 17.309 94 46 91 3 1734176096 6479600 12915360
23:20:51 6772 8192000000 10693587104 11108884480 1755055024 17.643 98 26 52 0 1768347520 5422224 7870272
23:21:06 7423 8192000000 10678702672 11098054656 1744723536 17.558 98 29 58 0 1758964880 5548544 8692800
23:21:20 6512 8192000000 10722800368 11129782272 1771352400 17.778 99 20 40 0 1782419728 5294096 5773232
23:21:32 9944 8192000000 10711132240 11128066048 1734131296 17.470 96 23 44 2 1746060368 5462064 6467008
23:21:49 12101 8192000000 10732150112 11143012352 1753205600 17.628 97 28 57 0 1767010912 5184944 8620368
23:22:14 11331 8192000000 10716179872 11129671680 1795111552 17.974 100 20 40 1 1806605952 5712800 5781600
23:22:35 7547 8192000000 10725022960 11145773056 1791794928 17.947 99 23 44 2 1803782944 5404144 6583872
23:22:49 8922 8192000000 10723703616 11148603392 1798959312 18.005 99 24 46 1 1811390752 6042176 6389264
23:23:07 77138 8192000000 10723988720 11150995456 1794203344 17.966 98 35 70 2 1808894704 4823104 9868256
23:24:30 14205 8192000000 10740444672 11169730560 1830942688 18.267 100 31 61 3 1845274816 5942576 8389552
23:24:52 6798 8192000000 10748667600 11177066496 1836542544 18.313 100 29 58 2 1851141024 6097552 8500928
23:25:05 5088 8192000000 10753465392 11178319872 1840473776 18.345 100 37 73 3 1857517248 6676384 10367088
23:25:17 6051 8192000000 10761614544 11185094656 1844949088 18.381 100 32 65 1 1859583088 5878960 8755040
23:25:29 10917 8192000000 10771993712 11188690944 1844836976 18.380 100 29 58 1 1858524592 5351808 8335808
23:25:46 6594 8192000000 10766942256 11189395456 1850394848 18.425 100 31 61 0 1866355328 6213824 9746656
23:26:01 7946 8192000000 10763665024 11191365632 1850574736 18.427 100 23 45 1 1862851856 5551936 6725184
23:26:15 9888 8192000000 10771967968 11194634240 1851196048 18.432 100 25 48 1 1863779104 5153584 7429472
23:26:35 6645 8192000000 10768380560 11197251584 1855858256 18.470 100 27 54 1 1869478544 5524528 8095760
23:26:50 5889 8192000000 10774110832 11200978944 1855684992 18.468 100 25 50 0 1870067936 7155056 7227888
23:27:02 13369 8192000000 10785152432 11215376384 1867306288 18.562 100 23 46 1 1879813424 5962928 6544208
23:27:21 43870 8192000000 10820597824 11239108608 1885885712 18.713 100 33 66 0 1901582368 5146144 10550512
23:28:22 10488 8192000000 10834342016 11256160256 1905900432 18.874 100 47 94 1 1926810688 7354160 13556096
23:28:46 3172 8192000000 10840917536 11262550016 1915529984 18.951 100 39 78 1 1933432928 6499328 11403616
23:28:56 25295 8192000000 10843076144 11267993600 1919946096 18.986 100 37 75 0 1939958752 7728240 12284416
23:29:36 126923 8192000000 10860630624 11298435072 1932931120 19.090 100 50 100 0 1959639920 12053472 14655328
23:31:50 13555 8192000000 10850647904 11293630464 1931240720 19.077 100 32 64 5 1954972784 14283456 9448608
23:32:26 44035 8192000000 10874832944 11313123328 1944697824 19.184 100 35 70 1 1971396512 16339360 10359328
23:33:17 11572 8192000000 10879638512 11313467392 1948416432 19.214 100 43 86 2 1976130064 14551920 13161712
23:33:39 17581 8192000000 10897511904 11326230528 1957414304 19.285 100 44 86 1 1984074192 13980160 12679728
23:34:04 8858 8192000000 10899350464 11331633152 1960225280 19.308 100 54 109 0 1991976736 16122336 15629120
23:34:24 23509 8192000000 10907372432 11339857920 1963056416 19.330 100 53 104 2 1995979056 17465472 15457168
23:34:56 19856 8192000000 10906751232 11335512064 1957414080 19.285 100 57 114 0 1992937488 18343648 17179760
23:35:35 9472 8192000000 10905294960 11341447168 1963251296 19.332 100 54 108 2 2000977408 20680496 17045616
23:35:54 7212 8192000000 10917500976 11351789568 1967835088 19.368 100 57 112 1 2007100768 20972912 18292768
23:36:16 15454 8192000000 10911670192 11340591104 1954090016 19.259 99 45 88 3 1987234656 19293520 13851120
23:36:40 15930 8192000000 10924186576 11361267712 1980185424 19.466 100 54 107 0 2012196416 15662928 16348064
23:37:10 10590 8192000000 10922969408 11365634048 1983240608 19.490 100 40 80 1 2014023264 17806240 12976416
23:37:29 2761 8192000000 10929412480 11369005056 1987595232 19.525 100 54 106 2 2017225120 13124704 16505184
23:37:40 17415 8192000000 10929384000 11368165376 1986531008 19.516 100 55 110 0 2020733056 17621232 16580816
23:38:12 16533 8192000000 10942506912 11379802112 1992242688 19.562 100 52 102 2 2029111760 20872080 15996992
23:38:38 6035 8192000000 10948795696 11385024512 1996665872 19.596 100 59 118 0 2035556224 21737952 17152400
23:38:52 2872 8192000000 10954490848 11384643584 1995711056 19.589 100 66 132 1 2037393824 22284448 19398320
23:39:03 9759 8192000000 10956727888 11389435904 2001006048 19.631 100 62 122 1 2041567888 21984384 18577456
23:39:19 4888 8192000000 10970285744 11396575232 2006964704 19.678 100 73 146 2 2052400256 22930576 22504976
23:39:33 4398 8192000000 10961271712 11388370944 2002818752 19.645 100 64 128 3 2044706800 22604064 19283984
23:39:45 1293 8192000000 10961557392 11377283072 1983189232 19.490 99 83 166 0 2032053088 23181408 25682448
23:39:53 6473 8192000000 10924798240 11350167552 1971040000 19.394 99 65 130 1 2010743184 20640608 19062576
23:40:06 4214 8192000000 10954657888 11371372544 1986952432 19.520 100 78 153 2 2031151552 21137952 23061168
23:40:19 6665 8192000000 10955412432 11377483776 1994570880 19.580 100 75 150 4 2040185328 23355376 22259072
23:40:37 5955 8192000000 10964599440 11393302528 2003076480 19.647 100 67 134 1 2047341968 24746144 19519344
23:40:51 2227 8192000000 10971743024 11394035712 2009575472 19.698 100 81 161 1 2059604176 25956096 24072608
23:41:00 2840 8192000000 10970268608 11397394432 2006266480 19.672 100 77 150 1 2059586368 29275584 24044304
23:41:10 816 8192000000 10980038784 11398828032 2011335216 19.712 100 81 162 1 2060225744 25106688 23783840
23:41:18 1512 8192000000 10956118656 11367350272 1981757456 19.479 99 90 178 1 2032000944 22479248 27764240
23:41:26 1579 8192000000 10973789936 11397672960 2002890576 19.646 100 79 158 1 2051234592 23710112 24633904
23:41:36 3045 8192000000 10983685024 11401191424 2011539872 19.714 100 80 159 2 2061170592 25440736 24189984
23:41:47 2105 8192000000 10983007728 11395493888 2006997072 19.678 100 89 179 2 2058293952 25066656 26230224
23:41:55 3757 8192000000 10976462304 11399688192 2006588112 19.675 100 82 165 1 2059606512 28861632 24156768
23:42:09 1344 8192000000 10974110240 11384918016 1993100528 19.568 99 92 184 0 2048893632 28089776 27703328
23:42:17 3238 8192000000 10986580080 11409158144 2010417104 19.705 100 84 168 0 2067540064 31184544 25938416
23:42:27 4189 8192000000 10989381552 11410571264 2013624368 19.730 100 82 164 1 2069706784 31641040 24441376
23:42:38 2289 8192000000 10973531600 11388493824 1984743168 19.502 99 86 170 2 2042488128 32213776 25531184
23:42:49 2441 8192000000 10960250960 11378159616 1981925408 19.480 99 81 163 2 2039069440 32001856 25142176
23:42:58 2703 8192000000 10968328816 11383996416 1988157456 19.529 100 80 157 0 2045713376 33149984 24405936
23:43:09 12872 8192000000 10964805472 11391201280 1993821584 19.574 100 72 144 0 2050386112 34469840 22094688
23:43:33 8070 8192000000 10955714656 11391426560 1990406896 19.547 100 55 110 0 2042033424 34377968 17248560
23:43:49 8417 8192000000 10977024208 11406499840 2006100688 19.671 100 77 152 2 2066829312 37298656 23429968
23:44:07 2535 8192000000 10985246080 11407355904 2006418896 19.673 100 83 167 1 2070768000 38755056 25594048
23:44:17 1998 8192000000 10978016032 11388796928 1983976736 19.496 99 86 173 1 2049918800 39429920 26512144
23:44:27 3503 8192000000 10973925488 11392311296 1987591312 19.525 100 87 173 1 2056210976 41316176 27303488
23:44:37 1431 8192000000 10971459168 11385356288 1985322928 19.507 100 86 173 0 2055241504 42233808 27684768
23:44:45 2960 8192000000 10975562928 11389669376 1972290880 19.404 99 88 175 0 2043800736 44224064 27285792
23:44:59 4238 8192000000 10981629872 11396444160 1989505472 19.540 100 85 171 1 2062990992 46230144 27255376
23:45:10 1598 8192000000 10986902784 11396734976 1985625024 19.509 100 86 171 1 2057986480 46076976 26284480
23:45:19 3199 8192000000 10962645664 11385434112 1976900752 19.440 100 75 150 0 2046798496 46203232 23694512
23:45:30 5444 8192000000 10962460496 11394228224 1984015744 19.496 100 55 108 0 2044679984 43355920 17308320
23:45:43 5616 8192000000 10937613824 11366322176 1949810464 19.225 99 56 112 2 2011777968 44507120 17460384
23:45:56 5977 8192000000 10946415728 11376324608 1965409920 19.349 100 60 119 1 2030936928 46288480 19238528
23:46:09 2980 8192000000 10978825056 11393679360 1978839152 19.456 100 77 151 3 2049272880 47292000 23141728
23:46:20 3026 8192000000 10973282688 11390894080 1962712864 19.328 99 80 160 2 2037545216 49664752 25167600
23:46:29 1896 8192000000 10971158400 11400331264 1983724112 19.494 100 72 144 1 2059577184 52748944 23104128
23:46:39 5212 8192000000 10966043344 11390775296 1976880576 19.440 100 69 138 3 2051507040 52301568 22324896
23:46:55 23180 8192000000 10931341056 11370008576 1930264576 19.069 98 32 64 0 1984706656 43150080 11292000
23:47:38 11721 8192000000 10938972192 11382120448 1945901072 19.194 99 41 82 3 2010309328 50378080 14030176
23:47:58 4659 8192000000 10924183600 11339653120 1923032976 19.011 98 68 136 2 1996118336 50453104 22632256
23:48:09 7265 8192000000 10927126048 11358838784 1926731328 19.041 99 53 107 2 1997152416 53464160 16956928
23:48:32 11892 8192000000 10917140288 11352297472 1908872064 18.898 98 39 79 1 1966166464 44517712 12776688
23:48:55 35314 8192000000 10935597760 11370868736 1952703584 19.248 100 50 98 3 2003222800 35709808 14809408
23:49:48 12188 8192000000 10929466944 11367460864 1960779520 19.312 100 47 94 0 2014080192 38532608 14768064
23:50:29 26001 8192000000 10915552192 11370893312 1925319712 19.029 98 28 56 1 1974997424 39985536 9692176
23:51:20 12795 8192000000 10920079696 11371651072 1949484512 19.222 100 30 58 2 2005832336 45844656 10503168
23:51:44 6654 8192000000 10928984800 11379318784 1957278096 19.284 100 33 66 1 2014428896 46342928 10807872
23:52:07 20340 8192000000 10906528448 11361275904 1935393024 19.110 99 23 46 2 1990587120 47089376 8104720
23:52:47 29141 8192000000 10919506528 11376062464 1944304496 19.181 100 23 46 1 1999337312 46756976 8275840
23:53:27 20312 8192000000 10897641664 11353370624 1903854032 18.857 99 23 46 0 1967592416 54355888 9382496
23:54:18 40489 8192000000 10894446000 11346694144 1877292080 18.643 98 20 40 0 1940155744 55291456 7572208
23:55:16 92270 8192000000 10871711952 11329593344 1881690976 18.679 98 6 12 0 1901284080 17983440 1609664
23:56:57 41579 8192000000 10863198304 11316965376 1899410928 18.822 98 40 80 2 1929920800 17637024 12872848
23:58:16 56229 8192000000 10886605024 11331952640 1935953152 19.114 99 37 69 1 1953473328 8229600 9290576
23:59:29 28133 8192000000 10908895296 11341365248 1915385632 18.950 98 34 66 0 1931333376 7408560 8539184
00:00:06 78868 8192000000 10857284512 11319091200 1902938816 18.850 97 34 66 6 1922997248 10860512 9197920
00:01:32 80225 8192000000 10894142544 11327275008 1914197728 18.940 98 53 104 2 1940557600 11056416 15303456
00:03:08 45729 8192000000 10873811200 11336503296 1909277904 18.901 98 50 99 2 1934068256 10301520 14488832
00:04:02 118855 8192000000 10913808080 11348340736 1921699680 19.000 98 36 72 2 1939455792 7939440 9816672
00:06:10 5179 8192000000 10908603056 11356348416 1965867488 19.353 100 55 110 0 1995271104 13761616 15642000
00:06:22 24680 8192000000 10917641216 11356459008 1950100768 19.227 99 58 112 1 1978564384 12794928 15668688
00:06:53 27234 8192000000 10905419600 11357663232 1967200448 19.363 100 45 89 1 1992799968 12308176 13291344
00:07:31 8606 8192000000 10919425344 11360874496 1973112368 19.410 100 68 137 0 2005057376 11720768 20224240
00:07:46 26876 8192000000 10907138848 11372208128 1975605136 19.430 100 30 60 2 1999250144 15002848 8642160
00:08:24 72044 8192000000 10893741136 11370463232 1934243904 19.101 98 15 30 1 1953457328 14762896 4450528
00:09:47 101655 8192000000 10887473584 11364839424 1907281264 18.885 97 15 30 3 1924927264 13432112 4213888
00:11:37 74515 8192000000 10899022720 11364753408 1963655440 19.335 100 14 27 0 1984068864 16322528 4090896
00:13:07 68516 8192000000 10901464976 11385282560 1949247312 19.220 99 22 44 1 1974811456 18975040 6589104
00:15:11 75131 8192000000 10911840288 11354931200 1927394864 19.046 98 30 62 1 1945474464 10206672 7872928
00:16:43 42602 8192000000 10903542256 11364888576 1973801728 19.416 100 35 70 0 1991619568 7847968 9969872
00:17:39 14502 8192000000 10908305568 11368165376 1977267920 19.443 100 33 67 0 1995682400 7636560 10777920
00:18:09 50608 8192000000 10903926144 11375067136 1962007728 19.322 99 27 54 0 1978290864 9224288 7058848
00:19:13 70564 8192000000 10900872144 11374555136 1959534096 19.302 99 10 18 2 1975262512 12588864 3139552
00:20:32 73548 8192000000 10922445728 11387547648 1960830976 19.313 99 17 34 0 1979544128 13762800 4950352
00:21:52 65240 8192000000 10921132368 11384942592 1963009344 19.330 99 21 42 0 1982908336 13902224 5996768
00:23:05 107818 8192000000 10903744224 11368259584 1905660208 18.872 96 11 22 0 1920357200 11429824 3267168
00:25:05 44249 8192000000 10907634368 11384938496 1978704432 19.454 100 23 46 2 1996801312 11882880 6214000
00:25:56 91645 8192000000 10899622064 11360378880 1918920160 18.978 97 15 30 1 1932615408 9724816 3970432
00:27:44 64561 8192000000 10899742192 11356905472 1912894416 18.930 97 36 72 0 1930872272 7742000 10235856
00:28:56 39597 8192000000 10892016976 11349614592 1951713312 19.240 99 39 76 5 1971115072 9015312 10386448
00:29:42 15263 8192000000 10870228400 11330310144 1904667840 18.864 97 31 62 0 1921690608 8744800 8277968
00:30:03 8371 8192000000 10905144672 11354308608 1965933568 19.353 100 59 117 3 1991222704 8532240 16756896
00:30:18 49347 8192000000 10892715472 11364896768 1971575600 19.398 100 38 75 2 1991786256 9130016 11080640
00:31:14 58100 8192000000 10879468128 11367391232 1968416096 19.373 100 13 26 0 1982383584 10053104 3914384
00:32:19 52615 8192000000 10874305104 11358023680 1932876576 19.090 98 11 22 0 1944827840 8901904 3049360
00:33:53 87273 8192000000 10853634896 11332739072 1847844464 18.405 94 18 35 2 1861010992 8159504 5007024
00:35:30 39149 8192000000 10872955040 11333230592 1890312512 18.748 97 24 47 1 1904660640 7306864 7041264
00:36:16 55168 8192000000 10879369296 11349114880 1895002064 18.786 97 19 38 0 1915440784 15158960 5279760
00:37:54 53456 8192000000 10843837664 11301175296 1819076912 18.170 94 30 60 1 1838332448 10652032 8603504
00:38:54 40582 8192000000 10851146080 11316883456 1920510608 18.991 100 24 48 2 1940842496 13538608 6793280
00:39:41 66867 8192000000 10857896048 11318128640 1857990992 18.487 96 19 39 1 1876396128 12750624 5654512
00:40:57 114354 8192000000 10851411872 11334447104 1858374848 18.490 97 11 22 2 1882843376 21352896 3115632
00:42:58 54824 8192000000 10827973440 11295674368 1832570528 18.280 96 11 22 1 1845023664 9415040 3038096
00:44:06 76582 8192000000 10814823632 11286319104 1804811168 18.053 95 11 22 0 1822262064 14885216 2565680
00:45:30 50754 8192000000 10835450816 11307450368 1887982112 18.730 99 15 30 0 1910066736 17235552 4849072
00:47:29 119935 8192000000 10826217552 11284930560 1862145408 18.521 97 20 40 1 1877210368 9364512 5700448
00:49:35 56747 8192000000 10846424912 11313360896 1896021920 18.794 99 18 37 1 1912844720 11784384 5038416
00:50:45 66536 8192000000 10859443760 11335585792 1929832976 19.066 100 13 26 2 1951280608 17775200 3672432
00:52:02 50388 8192000000 10868202000 11342032896 1939754528 19.145 100 15 30 0 1961675472 17208816 4712128
00:53:19 53286 8192000000 10861812320 11336982528 1913930048 18.938 99 14 28 0 1935295696 16968384 4397264
00:54:53 43402 8192000000 10851402416 11333844992 1917888608 18.970 99 18 36 0 1933187872 10164944 5134320
00:55:43 63672 8192000000 10863439984 11343577088 1914700880 18.944 99 13 26 1 1927879920 9948352 3230688
00:56:57 45847 8192000000 10891480176 11350585344 1931425616 19.078 99 23 46 1 1959407680 20861472 7120592
00:57:57 41799 8192000000 10847749184 11309162496 1850808512 18.429 95 14 28 0 1866600896 12461680 3330704
00:58:49 51352 8192000000 10888835536 11338084352 1924061520 19.019 99 24 48 0 1938393344 7494704 6837120
00:59:49 29907 8192000000 10881535712 11337740288 1917638832 18.968 98 31 61 1 1935731440 10042448 8050160
01:00:25 53094 8192000000 10874576624 11352969216 1910661184 18.912 98 13 26 0 1926221360 12367600 3192576
01:01:54 87495 8192000000 10898739360 11354931200 1918324032 18.973 98 21 42 0 1939105984 14477440 6304512
01:03:32 57314 8192000000 10909691344 11374039040 1950069200 19.227 99 16 30 1 1970240256 16382176 3788880
01:04:38 102750 8192000000 10918569664 11383889920 1976516816 19.437 100 14 28 0 1999610768 19373328 3720624
01:06:30 48158 8192000000 10921295248 11385061376 1942681488 19.168 98 23 46 0 1959200448 10406672 6112288
01:07:31 74372 8192000000 10914911376 11380187136 1979824176 19.463 100 33 64 2 2004440720 15975216 8641328
01:09:25 77530 8192000000 10917404368 11381350400 1964175168 19.339 99 34 68 2 1984403824 10362832 9865824
01:10:53 18640 8192000000 10923104048 11391479808 1987063328 19.521 100 33 66 1 2008522704 11226128 10233248
01:11:21 48840 8192000000 10872311696 11356160000 1930971568 19.075 98 30 61 3 1957388080 17536624 8879888
01:12:34 57936 8192000000 10867453472 11356397568 1939714032 19.144 99 8 16 0 1961008640 18705840 2588768
01:14:28 70364 8192000000 10895260800 11380838400 1948421872 19.214 99 18 36 0 1969370864 15408672 5540320
01:15:51 52133 8192000000 10900414288 11382923264 1945117280 19.188 99 15 31 0 1973360320 23368432 4874608
01:16:50 60858 8192000000 10885906592 11370127360 1942987024 19.171 99 14 28 1 1964922832 17684704 4251104
01:18:06 52164 8192000000 10892238048 11373867008 1960879552 19.313 100 23 46 0 1978915680 11489104 6547024
01:19:05 51120 8192000000 10886401072 11371003904 1951122592 19.235 99 11 22 1 1964381728 10300128 2959008
01:20:04 49038 8192000000 10878341568 11362967552 1929909744 19.066 98 11 22 0 1944709696 11333648 3466304
01:21:02 29846 8192000000 10893854336 11357626368 1909836976 18.905 97 34 66 0 1929643632 10667632 9139024
01:21:51 60922 8192000000 10886742592 11345342464 1912667360 18.928 98 31 61 0 1932091152 11140144 8283648
01:22:58 43252 8192000000 10881041968 11364409344 1936562656 19.119 99 22 44 0 1951104192 8833696 5707840
01:23:48 47893 8192000000 10904968240 11357810688 1888293888 18.732 96 36 71 0 1908472928 10207568 9971472
01:24:45 23897 8192000000 10888190544 11351461888 1935465312 19.111 99 31 62 0 1953667968 9573920 8628736
01:25:19 48797 8192000000 10886410096 11362480128 1946783248 19.201 99 27 54 0 1967600800 13285312 7532240
01:26:20 67428 8192000000 10186389424 10597384192 1232836512 13.080 64 6 12 0 1246306784 11686176 1784096

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 26-03-2021 01:28:19 to 26-03-2021 01:28:50.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 93 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 26-03-2021 01:28:51 to 26-03-2021 01:28:53.

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          234692
MON$OLDEST_ACTIVE               235204
MON$OLDEST_SNAPSHOT             235204
MON$NEXT_TRANSACTION            235204
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                       2027040
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.33428 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33428 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33428 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33428 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 ---
:300: 
:301: mscs-test-161.budzdorov.ru    Fri Mar 26 01:27:34 2021
:302:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:303: 
:304: 
:305: mscs-test-161.budzdorov.ru    Fri Mar 26 01:27:34 2021
:306:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:307: 
--- end of diff output ---

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

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