Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 04.12.2020 16: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 e0e7b46250ba4f9795ceb55e0face73f
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 2020-09-25 13:42
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.00
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 17635052 kB
MemAvailable 31552016 kB
Buffers 0 kB
Cached 14022456 kB
SwapCached 1972 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 2020-12-04 16:27:03
DTS_END                         2020-12-04 16:27:03.5570
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_AGGREGATE_PERF_DATA(83:5) ==> TMP_AGGREGATE_PERF_DATA_AUTOGEN(151:13) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/59642
TRN_ID                          241227
ATT_ID                          711
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: 9280.33 24712 1113640
customer order: creation 173.03 348 20764
customer order: refuse 13.98 345 1677
order to supplier: creation 45.94 1272 5513
order to supplier: removal 3.38 97147 405
invoice (draft): creation 45.93 3475 5512
invoice (draft): removal 52.76 695 6331
invoice accept: apply 42.00 17662 5040
invoice accept: cancel 47.64 732 5717
customer reserve: creation 3847.73 176 461728
customer reserve: removal 4705.86 55 564703
realization accept: apply 82.13 163 9855
realization accept: cancel 90.30 109 10836
payment from customer: creation 60.19 108 7223
payment from customer: removal 5.54 90 665
payment to supplier: creation 48.74 122 5849
payment to supplier: removal 3.28 83 393
service: total inventory turnovers 4.56 1067 547
service: total monetary turnovers 6.48 31 778
service: aggregate perf. data 0.83 18331 100
service: refresh index statistics 0.03 352230 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 04-12-2020 16:27:48 to 04-12-2020 16:27:51.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4118
TEST_TIME 2 3919
TEST_TIME 3 3323
TEST_TIME 4 3826
TEST_TIME 5 4299
TEST_TIME 6 5418
TEST_TIME 7 5277
TEST_TIME 8 5203
TEST_TIME 9 5669
TEST_TIME 10 5636
TEST_TIME 11 6416
TEST_TIME 12 6378
TEST_TIME 13 6462
TEST_TIME 14 6494
TEST_TIME 15 6534
TEST_TIME 16 6861
TEST_TIME 17 7001
TEST_TIME 18 7216
TEST_TIME 19 7762
TEST_TIME 20 7974
TEST_TIME 21 8227
TEST_TIME 22 8558
TEST_TIME 23 8419
TEST_TIME 24 8858
TEST_TIME 25 9442
TEST_TIME 26 10761
TEST_TIME 27 10655
TEST_TIME 28 10398
TEST_TIME 29 10243
TEST_TIME 30 10240
TEST_TIME 31 10294
TEST_TIME 32 10260
TEST_TIME 33 10250
TEST_TIME 34 10133
TEST_TIME 35 9975
TEST_TIME 36 9760
TEST_TIME 37 9702
TEST_TIME 38 9562
TEST_TIME 39 9432
TEST_TIME 40 9535
TEST_TIME 41 9623
TEST_TIME 42 9511
TEST_TIME 43 9514
TEST_TIME 44 9569
TEST_TIME 45 9558
TEST_TIME 46 9465
TEST_TIME 47 9479
TEST_TIME 48 9486
TEST_TIME 49 9656
TEST_TIME 50 9583
TEST_TIME 51 9594
TEST_TIME 52 9687
TEST_TIME 53 9661
TEST_TIME 54 9755
TEST_TIME 55 9642
TEST_TIME 56 9503
TEST_TIME 57 9589
TEST_TIME 58 9470
TEST_TIME 59 9445
TEST_TIME 60 9405
TEST_TIME 61 9318
TEST_TIME 62 9245
TEST_TIME 63 9267
TEST_TIME 64 9281
TEST_TIME 65 9239
TEST_TIME 66 9348
TEST_TIME 67 9369
TEST_TIME 68 9357
TEST_TIME 69 9394
TEST_TIME 70 9427
TEST_TIME 71 9398
TEST_TIME 72 9406
TEST_TIME 73 9408
TEST_TIME 74 9384
TEST_TIME 75 9528
TEST_TIME 76 9523
TEST_TIME 77 9542
TEST_TIME 78 9425
TEST_TIME 79 9422
TEST_TIME 80 9368
TEST_TIME 81 9349
TEST_TIME 82 9367
TEST_TIME 83 9329
TEST_TIME 84 9354
TEST_TIME 85 9292
TEST_TIME 86 9312
TEST_TIME 87 9375
TEST_TIME 88 9354
TEST_TIME 89 9359
TEST_TIME 90 9338
TEST_TIME 91 9327
TEST_TIME 92 9463
TEST_TIME 93 9498
TEST_TIME 94 9516
TEST_TIME 95 9492
TEST_TIME 96 9517
TEST_TIME 97 9517
TEST_TIME 98 9518
TEST_TIME 99 9533
TEST_TIME 100 9570
TEST_TIME 101 9496
TEST_TIME 102 9488
TEST_TIME 103 9456
TEST_TIME 104 9407
TEST_TIME 105 9344
TEST_TIME 106 9316
TEST_TIME 107 9307
TEST_TIME 108 9300
TEST_TIME 109 9302
TEST_TIME 110 9265
TEST_TIME 111 9279
TEST_TIME 112 9256
TEST_TIME 113 9262
TEST_TIME 114 9234
TEST_TIME 115 9311
TEST_TIME 116 9300
TEST_TIME 117 9307
TEST_TIME 118 9321
TEST_TIME 119 9361
TEST_TIME 120 9287

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 04-12-2020 16:27:52 to 04-12-2020 16:27:55.

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 1542383 1542383 0 0.00 0 43847 6 0 0
doc_list_biud 1542382 1542382 0 0.00 0 46360 25 0 0
sp_add_invoice_to_stock 5159 5040 119 2.30 44 167705 17662 0 119
sp_cancel_adding_invoice 5717 5717 0 0.00 5 67666 732 0 0
sp_cancel_client_order 1677 1677 0 0.00 4 12540 345 0 0
sp_cancel_customer_reserve 564703 564703 0 0.00 1 23582 56 0 0
sp_cancel_pay_from_customer 665 665 0 0.00 3 5384 91 0 0
sp_cancel_pay_to_supplier 393 393 0 0.00 3 4497 84 0 0
sp_cancel_supplier_invoice 6337 6331 6 0.09 2 46377 695 0 6
sp_cancel_supplier_order 405 405 0 0.00 10 1055209 97148 0 0
sp_cancel_write_off 10836 10836 0 0.00 1 12942 110 0 0
sp_client_order 20764 20764 0 0.00 3 55122 349 0 0
sp_customer_reserve 461728 461728 0 0.00 0 89324 177 0 0
sp_fill_shopping_cart 31776 31776 0 0.00 1 17250 42 0 0
sp_fill_shopping_cart_clo_res 461722 461722 0 0.00 0 27531 14 0 0
sp_get_clo_for_invoice 5028 5028 0 0.00 0 41924 309 0 0
sp_kill_cost_storno 17611 17611 0 0.00 0 15423 52 0 0
sp_kill_qstorno_ret_qs2qd 1146978 1146978 0 0.00 0 46355 30 0 0
sp_kill_qty_storno 604552 604552 0 0.00 0 46358 64 0 0
sp_lock_selected_doc 20511 20511 0 0.00 0 7484 6 0 0
sp_make_cost_storno 27955 27955 0 0.00 0 12425 49 0 0
sp_multiply_rows_for_pdistr 27955 27955 0 0.00 0 6033 25 0 0
sp_multiply_rows_for_qdistr 20764 20764 0 0.00 0 55110 161 0 0
sp_pay_from_customer 7223 7223 0 0.00 4 28068 109 0 0
sp_pay_to_supplier 5849 5849 0 0.00 4 11787 122 0 0
sp_payment_common 13072 13072 0 0.00 1 27985 32 0 0
sp_qd_handle_on_cancel_clo 1677 1677 0 0.00 0 12532 310 0 0
sp_qd_handle_on_invoice_upd_sts 10745 10745 0 0.00 0 24224 299 0 0
sp_qd_handle_on_reserve_upd_sts 9855 9855 0 0.00 0 18516 55 0 0
sp_reserve_write_off 9855 9855 0 0.00 6 19003 164 0 0
sp_supplier_invoice 5512 5512 0 0.00 6 79422 3475 0 0
sp_supplier_order 5513 5513 0 0.00 5 39261 1273 0 0
srv_aggregate_perf_data 101 100 1 0.99 2551 184533 18332 0 1
srv_fill_mon_cache_memory 156 156 0 0.00 801 123237 32502 0 0
srv_find_qd_qs_mism 1066407 1066407 0 0.00 0 43829 5 0 0
srv_make_invnt_saldo 547 547 0 0.00 22 51110 1067 0 0
srv_make_money_saldo 778 778 0 0.00 1 8977 32 0 0
srv_recalc_idx_stat 4 4 0 0.00 222459 542771 352230 0 0
t$perf-abend:sp_add_invoice_to_stock 119 119 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 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 5040 5040 0 0.00 0 11149 150 0 0
t$perf-norm:sp_cancel_adding_invoice 418 418 0 0.00 0 8684 122 0 0
t$perf-norm:sp_cancel_client_order 1677 1677 0 0.00 0 8331 23 0 0
t$perf-norm:sp_cancel_customer_reserve 672 672 0 0.00 0 4147 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 665 665 0 0.00 0 4884 13 0 0
t$perf-norm:sp_cancel_pay_to_supplier 393 393 0 0.00 0 7817 21 0 0
t$perf-norm:sp_cancel_supplier_invoice 399 399 0 0.00 0 1231 17 0 0
t$perf-norm:sp_cancel_supplier_order 405 405 0 0.00 0 18469 1516 0 0
t$perf-norm:sp_cancel_write_off 999 999 0 0.00 0 618 5 0 0
t$perf-norm:sp_client_order 20764 20764 0 0.00 0 8851 18 0 0
t$perf-norm:sp_customer_reserve 988 988 0 0.00 0 1623 6 0 0
t$perf-norm:sp_pay_from_customer 7223 7223 0 0.00 0 4327 8 0 0
t$perf-norm:sp_pay_to_supplier 5849 5849 0 0.00 0 8334 8 0 0
t$perf-norm:sp_reserve_write_off 9855 9855 0 0.00 0 20441 13 0 0
t$perf-norm:sp_supplier_invoice 5512 5512 0 0.00 0 8732 23 0 0
t$perf-norm:sp_supplier_order 5513 5513 0 0.00 0 9620 17 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 165 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 156 156 0 0.00 0 70 1 0 0
t$perf-norm:srv_make_invnt_saldo 547 547 0 0.00 0 1688 29 0 0
t$perf-norm:srv_make_money_saldo 778 778 0 0.00 0 6771 28 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 10294 10056 238 2.31 0 6029 17 0 238
v_all_customers 38482 38482 0 0.00 0 82 1 0 0
v_all_suppliers 30354 30354 0 0.00 0 15 1 0 0
v_all_wares 41528 41528 0 0.00 0 38 1 0 0
v_cancel_adding_invoice 836 836 0 0.00 0 3701 15 0 0
v_cancel_client_order 3354 3354 0 0.00 0 2211 5 0 0
v_cancel_customer_prepayment 1330 1330 0 0.00 0 2340 8 0 0
v_cancel_customer_reserve 1344 1344 0 0.00 0 1905 6 0 0
v_cancel_payment_to_supplier 786 786 0 0.00 0 3699 10 0 0
v_cancel_supplier_invoice 810 798 12 1.48 0 4568 22 0 12
v_cancel_supplier_order 810 810 0 0.00 0 653 4 0 0
v_cancel_write_off 1998 1998 0 0.00 0 3483 14 0 0
v_max_id_clo_ord 5507 5507 0 0.00 0 3805 2 0 0
v_max_id_clo_res 988 988 0 0.00 0 5234 24 0 0
v_max_id_ord_sup 5503 5503 0 0.00 0 3927 3 0 0
v_max_non_paid_invoice 1682 1682 0 0.00 0 680 3 0 0
v_max_non_paid_realizn 3596 3596 0 0.00 0 952 3 0 0
v_min_id_clo_ord 5507 5507 0 0.00 0 3127 6 0 0
v_min_id_clo_res 988 988 0 0.00 0 7750 43 0 0
v_min_id_ord_sup 5503 5503 0 0.00 0 6554 10 0 0
v_min_non_paid_invoice 5849 5849 0 0.00 0 10370 18 0 0
v_min_non_paid_realizn 7223 7223 0 0.00 0 19324 20 0 0
v_our_firm 10300 10300 0 0.00 0 30 1 0 0
v_reserve_write_off 19710 19710 0 0.00 0 15350 7 0 0
x_lock_depdocs_on_canc_invoice 11649 11649 0 0.00 0 19908 115 0 0
x_lock_depdocs_on_canc_sup_ord 405 405 0 0.00 0 15526 456 0 0
x_make_qstorno_1000_1200 5513 5513 0 0.00 1 39241 1196 0 0
x_make_qstorno_1200_2000 5512 5512 0 0.00 3 79415 3312 0 0
x_make_qstorno_2100_3300 461728 461728 0 0.00 0 89323 161 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 04-12-2020 16:27:56 to 04-12-2020 16:28:00.

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
13:57:07 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:13 12517 8192000000 10198627728 10491445248 782999728 8.724 64 51 100 0 803054528 2214720 17840080
13:57:34 27025 8192000000 10308698944 10616221696 1359691136 14.235 100 86 172 0 1392205936 4635280 27879520
13:58:14 23615 8192000000 10351478608 10668408832 1399402400 14.590 100 90 180 0 1435267760 6288496 29576864
13:58:45 27140 8192000000 10365973968 10687119360 1417657584 14.752 100 84 168 1 1452581392 7090864 27832944
13:59:24 28778 8192000000 10402476976 10730516480 1451305968 15.049 100 90 180 0 1488936336 8148048 29482320
14:00:03 18005 8192000000 10417803232 10745159680 1471214352 15.224 100 90 180 0 1509122144 8945296 28962496
14:00:30 21700 8192000000 10445641536 10781466624 1497345888 15.453 100 85 169 0 1533824720 9474640 27004192
14:01:07 10303 8192000000 10463399488 10804150272 1523300928 15.679 100 83 166 1 1559381856 10016400 26064528
14:01:31 16199 8192000000 10509169312 10857738240 1551202000 15.920 100 80 160 1 1586267648 10350512 24715136
14:01:59 26058 8192000000 10548512224 10902290432 1586679264 16.225 100 77 154 3 1620531824 10268464 23584096
14:02:34 10861 8192000000 10564560448 10921377792 1620609968 16.515 100 82 164 0 1656866048 11435296 24820784
14:02:51 10218 8192000000 10575990608 10936328192 1633851120 16.628 100 78 156 1 1668972800 11630304 23491376
14:03:14 10053 8192000000 10606085552 10970722304 1663083472 16.875 100 87 172 1 1700309808 11664816 25561520
14:03:34 7841 8192000000 10610789104 10978750464 1678573872 17.005 100 79 158 0 1714734416 12717680 23442864
14:03:49 5973 8192000000 10639943968 11010826240 1697969024 17.168 100 82 164 1 1734929952 13238624 23722304
14:04:03 7992 8192000000 10657491584 11032141824 1716881888 17.326 100 77 155 0 1751389744 12333712 22174144
14:04:18 8900 8192000000 10673472784 11048214528 1733136352 17.462 100 90 182 2 1772508592 13339424 26032816
14:04:33 7593 8192000000 10683040112 11058077696 1743694688 17.549 100 89 179 1 1781908656 13454640 24759328
14:04:48 5161 8192000000 10688021088 11062190080 1751160928 17.611 100 87 174 1 1789483072 13680176 24641968
14:05:01 6725 8192000000 10705282320 11080544256 1763914784 17.717 100 82 164 0 1800613408 14411664 22286960
14:05:16 4157 8192000000 10712650160 11089272832 1770171776 17.768 100 86 168 0 1808386928 14612640 23602512
14:05:27 3872 8192000000 10710860608 11089321984 1773541680 17.796 100 88 177 2 1812808592 15095552 24171360
14:05:38 4315 8192000000 10721119440 11099189248 1780478272 17.853 100 85 166 2 1817572048 13651856 23441920
14:05:50 3307 8192000000 10734432240 11110174720 1788475424 17.919 100 93 186 0 1829505072 14934048 26095600
14:06:00 2350 8192000000 10740306768 11118374912 1797375872 17.992 100 92 181 2 1836160416 13954256 24830288
14:06:08 2832 8192000000 10748495728 11126857728 1804793616 18.053 100 93 187 0 1844883520 14371952 25717952
14:06:18 2987 8192000000 10751290432 11133984768 1807529360 18.076 100 83 166 3 1844087248 14078368 22479520
14:06:27 2647 8192000000 10757572944 11139674112 1815975888 18.145 100 89 178 0 1854657056 14600784 24080384
14:06:36 2274 8192000000 10766098176 11147993088 1822015968 18.194 100 92 182 0 1860695328 14267776 24411584
14:06:45 4711 8192000000 10770494832 11154411520 1826801360 18.233 100 84 168 1 1863983632 14186016 22996256
14:06:57 5204 8192000000 10767190896 11151941632 1830171072 18.261 100 86 171 0 1867484000 13882240 23430688
14:07:09 1918 8192000000 10788295664 11174178816 1843524864 18.369 100 90 180 1 1882496720 13598656 25373200
14:07:17 1979 8192000000 10790591696 11175886848 1850579008 18.427 100 83 164 0 1885966080 12168000 23219072
14:07:25 2499 8192000000 10792016144 11179528192 1853107728 18.447 100 90 181 1 1891050048 12756816 25185504
14:07:34 1046 8192000000 10797905456 11183943680 1857680704 18.484 100 91 182 0 1896175984 13601952 24893328
14:07:42 1934 8192000000 10803555312 11189944320 1862898880 18.527 100 91 182 1 1901793552 13425552 25469120
14:07:50 1602 8192000000 10808844352 11195170816 1862250256 18.522 100 91 182 2 1902662160 13788176 26623728
14:07:58 1714 8192000000 10815157984 11202830336 1869471792 18.580 100 90 179 4 1906808784 12152752 25184240
14:08:06 2523 8192000000 10802588288 11203276800 1868010880 18.568 100 76 152 0 1901693312 11952144 21730288
14:08:15 28514 8192000000 10806087552 11198689280 1868989072 18.576 100 71 139 2 1898900624 9806672 20104880
14:08:50 18455 8192000000 10819042320 11211665408 1873722368 18.614 100 75 150 3 1904903728 9068896 22112464
14:09:15 1522 8192000000 10824671840 11216498688 1877207984 18.643 100 82 165 0 1912473456 12047968 23217504
14:09:24 2515 8192000000 10807481584 11211661312 1877157312 18.642 100 74 147 2 1910131888 12517696 20456880
14:09:33 1354 8192000000 10819957136 11218395136 1879588128 18.662 100 87 173 5 1916707648 12649328 24470192
14:09:41 3699 8192000000 10804268704 11215904768 1874906224 18.624 100 59 118 0 1902422912 11557456 15959232
14:09:52 2807 8192000000 10809061008 11216924672 1874528432 18.621 100 58 113 1 1905987968 15578848 15880688
14:10:02 1990 8192000000 10808293776 11215245312 1877416720 18.644 100 57 113 0 1905241808 12166976 15658112
14:10:11 3678 8192000000 10802144432 11223138304 1878741216 18.655 100 49 98 1 1905569040 12441232 14386592
14:10:20 5442 8192000000 10800868384 11217461248 1880458464 18.669 100 45 92 2 1901468320 8752384 12257472
14:10:33 3533 8192000000 10801707808 11221114880 1881500272 18.677 100 36 72 2 1900202976 8889216 9813488
14:10:44 5125 8192000000 10796127712 11220975616 1881545680 18.678 100 34 68 0 1898581984 7824048 9212256
14:10:57 8850 8192000000 10810611072 11228479488 1889693680 18.743 100 20 41 1 1901172656 5822672 5656304
14:11:12 3516 8192000000 10814511552 11233984512 1894317776 18.781 100 41 82 2 1915105664 8558640 12229248
14:11:22 4699 8192000000 10803796880 11235434496 1896561920 18.799 100 42 84 2 1916718896 8854912 11302064
14:11:33 6539 8192000000 10803420192 11234369536 1894759104 18.784 100 24 47 2 1907910384 6643232 6508048
14:11:46 17628 8192000000 10801322208 11237957632 1895961840 18.794 100 11 21 1 1905783504 6915952 2905712
14:12:14 47943 8192000000 10821883536 11246264320 1900960064 18.834 100 19 36 2 1911461600 5128272 5373264
14:13:08 19381 8192000000 10816670864 11252129792 1904713184 18.864 100 20 40 1 1916101696 6063104 5325408
14:13:36 5672 8192000000 10816309872 11250667520 1905156384 18.868 100 21 42 0 1917857872 7141744 5559744
14:13:48 4483 8192000000 10830580992 11258671104 1910968272 18.914 100 44 87 1 1931342496 8024480 12349744
14:14:02 5952 8192000000 10819277200 11255255040 1907498560 18.887 100 19 38 1 1918574240 5523392 5552288
14:14:16 4494 8192000000 10837578128 11261759488 1913075632 18.931 100 42 82 1 1931375888 6633856 11666400
14:14:31 4025 8192000000 10830812944 11259461632 1912229888 18.925 100 37 72 1 1928958576 5968544 10760144
14:14:42 7134 8192000000 10813270560 11257294848 1910162480 18.908 100 25 50 0 1924096192 6706192 7227520
14:14:58 7099 8192000000 10827692576 11258982400 1910033744 18.907 100 24 48 3 1922807648 6258688 6515216
14:15:12 10873 8192000000 10829348112 11261382656 1911063984 18.915 100 21 43 1 1923522896 5821552 6637360
14:15:29 5753 8192000000 10824937472 11255566336 1908263488 18.893 100 32 64 3 1928022544 10701440 9057616
14:15:43 8776 8192000000 10812631936 11254349824 1905696528 18.872 100 17 34 1 1915719600 5477056 4546016
14:15:58 3236 8192000000 10827428256 11258499072 1893812720 18.776 99 30 60 2 1908594144 6107104 8674320
14:16:07 8419 8192000000 10822893568 11250855936 1890834640 18.753 99 27 54 1 1905015840 6130768 8050432
14:16:26 8160 8192000000 10822337536 11260911616 1911474176 18.918 100 25 49 2 1925340832 6585808 7280848
14:16:43 68633 8192000000 10793541120 11227557888 1817675824 18.159 95 16 30 1 1827412208 5139472 4596912
14:17:58 10396 8192000000 10771061184 11201196032 1774059600 17.801 94 15 29 1 1783495152 5070448 4365104
14:18:15 8521 8192000000 10770477600 11189493760 1789015088 17.924 96 20 40 1 1800166320 5431248 5719984
14:18:34 7253 8192000000 10746387520 11168968704 1785193808 17.892 96 33 66 2 1799974272 5863136 8917328
14:18:48 6645 8192000000 10733900656 11155673088 1766890992 17.741 96 23 46 4 1778734768 4497648 7346128
14:19:02 4962 8192000000 10739496768 11160588288 1806272896 18.065 99 37 74 0 1823818560 6628640 10917024
14:19:13 5144 8192000000 10765083312 11180011520 1833112688 18.285 100 28 54 2 1851206048 10528560 7564800
14:19:25 4890 8192000000 10722314256 11137740800 1751052544 17.610 96 28 55 2 1765188528 5832128 8303856
14:19:38 6738 8192000000 10722342752 11136921600 1759875776 17.683 97 21 40 1 1775646224 9743024 6027424
14:19:52 6494 8192000000 10711877856 11113816064 1741155920 17.528 97 33 66 2 1756235280 4984752 10094608
14:20:10 7335 8192000000 10718329808 11128655872 1777867872 17.832 99 31 62 3 1797289392 10183408 9238112
14:20:24 8282 8192000000 10684404928 11101429760 1725266512 17.396 96 19 38 2 1735809136 5454016 5088608
14:20:39 5901 8192000000 10695623728 11108687872 1775569440 17.813 100 28 54 0 1789426464 6445152 7411872
14:20:52 8160 8192000000 10685552592 11093839872 1740094608 17.519 98 18 36 0 1750582704 5061200 5426896
14:21:07 9739 8192000000 10733395248 11149676544 1785490960 17.895 99 15 30 0 1803408240 14040096 3877184
14:21:25 9844 8192000000 10734900704 11158986752 1795477792 17.977 98 19 37 2 1806009424 5529520 5002112
14:21:41 67601 8192000000 10740679696 11158118400 1779012816 17.841 97 26 52 1 1792000800 5371760 7616224
14:22:56 17241 8192000000 10756792304 11169337344 1813725776 18.126 99 24 48 1 1826260880 5580096 6955008
14:23:20 6344 8192000000 10758458368 11182063616 1840532848 18.345 100 28 56 1 1855530592 6688752 8308992
14:23:33 9237 8192000000 10756956320 11181551616 1842343008 18.360 100 21 42 1 1853630880 5539744 5748128
14:23:49 8103 8192000000 10771195248 11194392576 1852027104 18.439 100 37 74 2 1870025872 7536560 10462208
14:24:05 7290 8192000000 10769113136 11197169664 1854069760 18.455 100 34 69 2 1875041536 11635504 9336272
14:24:21 7545 8192000000 10783022592 11201531904 1856753120 18.477 100 23 46 1 1869017440 5271344 6992976
14:24:37 6346 8192000000 10788157936 11206078464 1867073552 18.561 100 52 104 0 1887048608 4601296 15373760
14:24:54 6339 8192000000 10777703232 11204964352 1866269344 18.554 100 36 72 1 1883322192 6137472 10915376
14:25:07 6195 8192000000 10781159392 11208507392 1868167760 18.569 100 38 76 3 1885938032 6850736 10919536
14:25:20 5905 8192000000 10783081744 11211313152 1867785584 18.566 100 32 64 2 1883028160 5697920 9544656
14:25:35 12358 8192000000 10783001056 11212623872 1868255456 18.570 100 23 46 6 1884966512 10146176 6564880
14:25:56 10377 8192000000 10783355280 11214245888 1871238464 18.594 100 23 46 4 1884194608 5638368 7317776
14:26:16 12032 8192000000 10782700928 11217588224 1870002816 18.584 100 9 18 0 1877481968 5161008 2318144
14:26:34 10375 8192000000 10795382544 11222659072 1877456352 18.645 100 26 51 1 1891122192 5643984 8021856
14:26:50 105581 8192000000 10826229824 11250135040 1886410784 18.717 100 28 54 1 1898950160 5011584 7527792
14:28:56 23740 8192000000 10848851232 11273023488 1922567344 19.007 100 43 84 0 1943017520 8177344 12272832
14:29:30 23643 8192000000 10860016496 11282034688 1923421184 19.014 100 37 74 1 1941403504 7358160 10624160
14:30:05 39552 8192000000 10879245616 11305148416 1935943200 19.114 100 37 74 0 1958210256 11651584 10615472
14:30:53 19917 8192000000 10889079424 11313737728 1951741216 19.240 100 53 103 2 1980718288 14612912 14364160
14:31:23 18019 8192000000 10890185280 11317673984 1956397184 19.277 100 52 103 0 1987145056 15785232 14962640
14:32:04 4251 8192000000 10910671024 11329536000 1965436096 19.349 100 68 132 2 2000032704 15405712 19190896
14:32:16 7973 8192000000 10915910176 11336388608 1968829152 19.376 100 58 111 3 2002290832 16622432 16839248
14:32:31 6807 8192000000 10906159744 11330473984 1951962560 19.242 99 54 106 2 1984290416 16751168 15576688
14:32:47 8693 8192000000 10912278208 11336327168 1967220320 19.363 100 55 110 0 2001311200 17974800 16116080
14:33:04 3821 8192000000 10915941760 11344146432 1971244592 19.395 100 56 108 2 2007119648 19080288 16794768
14:33:18 9482 8192000000 10925920784 11346849792 1973405952 19.412 100 57 114 0 2011252384 20804384 17042048
14:33:35 8498 8192000000 10910875824 11344121856 1975963952 19.433 100 51 102 0 2009910160 18886928 15059280
14:33:55 2882 8192000000 10915180864 11346665472 1974347216 19.420 100 48 95 2 2005365728 16777264 14241248
14:34:12 12139 8192000000 10921198736 11351257088 1982303536 19.483 100 60 119 2 2016931040 17301232 17326272
14:34:46 10055 8192000000 10931541216 11360325632 1984460048 19.500 100 44 88 0 2015777152 17910464 13406640
14:35:10 10050 8192000000 10923339296 11362320384 1984659840 19.502 100 38 76 1 2015515568 18986000 11869728
14:35:30 5289 8192000000 10931128512 11354980352 1981575376 19.477 100 53 104 3 2015856944 18999920 15281648
14:35:54 7253 8192000000 10931786416 11374911488 1992133376 19.561 100 48 96 2 2030823376 24833712 13856288
14:36:11 12242 8192000000 10939378384 11378548736 1997880240 19.606 100 53 107 2 2038165856 23079264 17206352
14:36:33 6651 8192000000 10950906496 11385135104 2001962544 19.638 100 51 101 1 2040665184 23094112 15608528
14:36:46 4538 8192000000 10967064224 11394453504 2006168816 19.671 100 62 121 2 2049824464 24814320 18841328
14:37:02 12996 8192000000 10969345248 11401170944 2012061232 19.718 100 53 104 0 2057502688 29433008 16008448
14:37:26 6966 8192000000 10972370448 11403816960 2010991472 19.709 100 61 121 0 2060260224 30979696 18289056
14:37:41 3113 8192000000 10976764416 11400912896 1995122448 19.584 99 68 134 1 2048643936 32817504 20703984
14:37:53 4094 8192000000 10961979120 11394785280 1999455232 19.618 100 56 111 2 2052419872 36070064 16894576
14:38:05 4049 8192000000 10968366096 11397238784 2005469952 19.666 100 68 136 0 2063234240 37503664 20260624
14:38:34 10986 8192000000 10950284304 11392004096 1979179280 19.458 99 49 98 0 2033451664 39328080 14944304
14:38:53 3699 8192000000 10943584496 11376242688 1973777040 19.415 99 53 106 1 2021344800 31952576 15615184
14:39:07 4688 8192000000 10963296352 11392057344 2001693072 19.636 100 74 146 0 2057681504 33195680 22792752
14:39:19 8858 8192000000 10931036016 11356213248 1934919328 19.106 97 51 102 0 1984265200 33471760 15874112
14:39:35 10733 8192000000 10950300352 11370602496 1963097088 19.331 99 54 107 1 2015080368 35397744 16585536
14:39:54 8514 8192000000 10943001264 11376128000 1967293024 19.364 99 60 120 1 2022367248 36501168 18573056
14:40:11 15658 8192000000 10955412544 11387834368 1983196832 19.490 100 51 102 1 2035574000 36943280 15433888
14:40:45 8181 8192000000 10951665696 11387772928 1988711504 19.534 100 42 85 1 2038369376 36413152 13244720
14:41:00 3778 8192000000 10983821696 11401732096 2003939872 19.654 100 89 177 2 2069697856 37704080 28053904
14:41:13 3330 8192000000 10972257936 11393822720 1980077584 19.465 99 70 138 1 2040975344 39255504 21642256
14:41:24 4362 8192000000 10963614752 11397021696 1991490240 19.556 100 61 122 1 2054112336 42894992 19727104
14:41:35 5855 8192000000 10958468688 11386994688 1961055504 19.314 98 67 133 0 2023420784 41542320 20822960
14:41:48 3009 8192000000 10974637408 11393937408 1978785568 19.455 99 72 141 1 2043604064 42117376 22701120
14:41:58 4229 8192000000 10992359520 11410726912 2003598688 19.651 100 89 177 1 2075270176 44481680 27189808
14:42:09 8158 8192000000 10986287440 11409088512 1997405232 19.602 100 77 154 2 2067528032 46477776 23645024
14:42:27 3911 8192000000 10994433648 11418144768 2007493680 19.682 100 69 138 1 2077815360 47526784 22794896
14:42:38 2505 8192000000 11000175840 11413311488 2001791104 19.637 100 82 164 0 2076310288 48774400 25744784
14:42:48 4310 8192000000 10999274576 11421532160 2008366304 19.689 100 78 157 1 2083585472 50710048 24509120
14:43:02 4537 8192000000 11001240320 11417600000 2003745760 19.652 100 73 146 2 2076618432 49960144 22912528
14:43:13 3370 8192000000 11005898864 11420413952 2007017072 19.678 100 85 169 0 2085222928 51388272 26817584
14:43:22 6497 8192000000 10996660000 11415752704 2001274464 19.633 100 78 154 2 2077138144 52213264 23650416
14:43:37 2199 8192000000 10987189408 11402739712 1986616752 19.517 99 86 173 1 2067105584 52822336 27666496
14:43:48 2848 8192000000 10997848000 11414667264 1998611824 19.612 100 82 164 2 2078506880 54489616 25405440
14:44:00 2668 8192000000 10991404128 11403952128 1994490464 19.579 100 89 176 1 2069948160 48841248 26616448
14:44:11 3114 8192000000 10988431888 11404853248 1996593760 19.596 100 86 172 1 2072417056 48956864 26866432
14:44:23 7312 8192000000 10982665120 11403083776 1991613872 19.557 100 82 164 0 2069022000 50656096 26752032
14:44:39 2328 8192000000 10983030976 11398520832 1991229808 19.554 100 88 176 1 2074243104 54638992 28374304
14:44:49 2842 8192000000 10987160208 11400302592 1987062880 19.521 100 82 164 0 2065856832 53581920 25212032
14:45:01 3307 8192000000 10984889568 11403153408 1989478048 19.540 100 89 178 0 2071953968 54872544 27603376
14:45:11 6866 8192000000 10992885648 11408916480 1995190704 19.585 100 81 161 2 2072296864 52283184 24822976
14:45:24 2255 8192000000 10998532080 11406712832 1993090144 19.568 100 84 168 1 2072075616 53134320 25851152
14:45:35 1702 8192000000 10986151488 11401375744 1986452032 19.516 100 80 159 0 2070965840 59788960 24724848
14:45:43 2969 8192000000 10990519792 11398639616 1981529264 19.477 100 92 184 0 2066962272 57148784 28284224
14:45:53 5338 8192000000 10990213024 11407265792 1990903344 19.551 100 90 179 1 2077075984 58126816 28045824
14:46:08 1721 8192000000 10979335248 11392724992 1971911440 19.401 100 79 158 0 2057794368 60657584 25225344
14:46:16 2846 8192000000 10969656240 11387412480 1975095376 19.426 100 69 138 1 2051755520 55095664 21564480
14:46:25 6673 8192000000 10960025248 11384020992 1969801824 19.384 100 62 124 1 2045619760 55400048 20417888
14:46:44 7910 8192000000 10947876880 11383808000 1961673616 19.319 100 47 94 3 2033690496 56948832 15068048
14:47:02 7743 8192000000 10928745968 11360927744 1933543024 19.095 99 41 81 2 2000236880 53047968 13645888
14:47:17 10939 8192000000 10938551088 11364536320 1949384080 19.222 100 51 100 1 2021355744 56315696 15655968
14:47:40 6144 8192000000 10945348416 11378356224 1961452176 19.318 100 53 106 3 2034222560 56356144 16414240
14:47:55 8814 8192000000 10940108576 11369598976 1949803744 19.225 99 43 86 1 2014593808 51030512 13759552
14:48:13 14624 8192000000 10935814688 11382824960 1962762688 19.328 100 29 58 1 2026848384 54551632 9534064
14:48:37 15739 8192000000 10942292432 11394486272 1967963984 19.369 100 27 54 2 2032792944 55491680 9337280
14:49:06 18506 8192000000 10944668224 11393273856 1967150672 19.363 100 29 58 1 2031829728 54969792 9709264
14:49:32 22277 8192000000 10937597104 11398557696 1969894352 19.385 100 26 52 1 2034095728 55655680 8545696
14:50:03 25792 8192000000 10934671056 11379490816 1927388496 19.046 98 23 46 1 1983830528 48517168 7924864
14:50:54 32377 8192000000 10917912320 11368431616 1921573888 18.999 98 24 46 3 1988896448 58319552 9003008
14:51:37 31046 8192000000 10902516528 11348389888 1875434800 18.628 97 23 46 0 1940520064 56803888 8281376
14:52:23 20495 8192000000 10884296448 11336261632 1897704048 18.808 99 18 36 0 1951205888 46660720 6841120
14:52:50 9014 8192000000 10868065632 11324465152 1871193360 18.594 98 14 28 0 1929063776 52224608 5645808
14:53:13 28740 8192000000 10825322368 11279499264 1860253360 18.505 98 16 32 0 1904800672 39280928 5266384
14:53:48 48961 8192000000 10855011424 11296964608 1914633680 18.944 100 30 61 2 1932207776 8726832 8847264
14:55:21 22680 8192000000 10845078912 11292680192 1877099808 18.642 98 16 32 0 1894056832 12494512 4462512
14:55:50 38156 8192000000 10861620960 11300401152 1893963680 18.778 99 14 28 0 1905090320 7502752 3623888
14:56:34 29951 8192000000 10875771728 11301646336 1887919952 18.729 98 49 98 6 1917278752 14289856 15068944
14:57:14 60474 8192000000 10867425920 11317690368 1931017136 19.075 100 13 26 1 1955284544 20645680 3621728
14:59:31 68711 8192000000 10857727168 11323080704 1923159568 19.012 99 6 12 0 1934278640 9746944 1372128
15:00:46 7132 8192000000 10855637728 11322978304 1937992192 19.131 100 6 12 0 1948708864 9537264 1179408
15:01:01 798 8192000000 10866550928 11315769344 1936465584 19.119 100 34 65 2 1953626576 8168048 8992944
15:01:09 9270 8192000000 10869477872 11324727296 1939772064 19.145 100 16 32 2 1956107104 11408128 4926912
15:01:26 52847 8192000000 10875984960 11338997760 1951338176 19.237 100 8 16 0 1962428864 9174752 1915936
15:02:34 103823 8192000000 10891640320 11351592960 1948065968 19.211 99 20 38 3 1964971296 10958576 5946752
15:04:37 54330 8192000000 10878532768 11311607808 1919105440 18.980 98 42 84 0 1940744368 8942608 12696320
15:05:39 6436 8192000000 10883998832 11341090816 1955968160 19.274 100 36 72 0 1974199104 8628144 9602800
15:06:01 34550 8192000000 10893262448 11349045248 1964679040 19.343 100 28 57 0 1984879504 12093248 8107216
15:06:53 89232 8192000000 10890283664 11371266048 1967016368 19.362 100 17 33 2 1984662576 13580048 4066160
15:08:35 45821 8192000000 10893371392 11355258880 1930107680 19.068 98 7 14 1 1940624368 8725328 1791360
15:09:27 54142 8192000000 10919817984 11368771584 1961459088 19.318 99 35 70 0 1981559248 9580192 10519968
15:10:27 45248 8192000000 10904596000 11375284224 1980165328 19.466 100 24 48 2 1998354720 11537696 6651696
15:11:23 96251 8192000000 10912563392 11380277248 1966143440 19.355 99 28 56 1 1988510944 14335088 8032416
15:13:05 83242 8192000000 10928602320 11387650048 1945923232 19.194 98 21 42 1 1969519728 17447328 6149168
15:15:27 84220 8192000000 10881836976 11356061696 1923114112 19.012 97 17 34 1 1946865136 17893008 5858016
15:16:58 49804 8192000000 10909543152 11364405248 1939752224 19.145 98 22 44 0 1954211008 8239392 6219392
15:17:54 42774 8192000000 10921768336 11378200576 1967241120 19.364 99 42 83 0 1994924112 15969872 11713120
15:18:43 70544 8192000000 10919395600 11394236416 1980786496 19.471 100 15 30 0 1995927136 11029136 4111504
15:20:00 78282 8192000000 10917871248 11391442944 1948158080 19.212 98 11 22 0 1963544976 12777616 2609280
15:21:37 54950 8192000000 10906997872 11362000896 1891760352 18.760 95 14 29 0 1906813136 10873856 4178928
15:22:50 73272 8192000000 10918053760 11377643520 1977040400 19.441 100 24 48 0 1997519376 12832576 7646400
15:24:55 62259 8192000000 10898128704 11356594176 1949031136 19.219 99 33 66 1 1965592592 7897904 8663552
15:26:08 20006 8192000000 10908981376 11355324416 1953017552 19.251 99 46 92 0 1976141952 10388944 12735456
15:26:35 45670 8192000000 10826059456 11279421440 1836421424 18.312 94 36 72 0 1854864736 8660496 9782816
15:27:30 45692 8192000000 10832437552 11300409344 1920303856 18.989 100 14 28 2 1930690288 6688688 3697744
15:28:29 55376 8192000000 10825972912 11295457280 1882574144 18.686 98 7 14 0 1890960416 6591888 1794384
15:29:36 15254 8192000000 10840934336 11315187712 1928627408 19.056 100 8 16 0 1936314768 6114816 1572544
15:29:58 17198 8192000000 10838470352 11304407040 1917124224 18.964 99 8 16 0 1925255984 6106752 2025008
15:30:23 52424 8192000000 10820373760 11290488832 1861700560 18.517 96 13 26 0 1873761568 8272416 3788592
15:31:24 39566 8192000000 10852605680 11319074816 1853189376 18.448 96 19 38 0 1867875472 9010528 5675568
15:32:15 67664 8192000000 10869107136 11331883008 1900121696 18.827 98 18 36 0 1922198416 16918208 5158512
15:33:32 23991 8192000000 10863140864 11326783488 1905360784 18.869 98 29 58 0 1931485888 17503920 8621184
15:34:03 63995 8192000000 10873622656 11336937472 1922030720 19.003 99 18 34 4 1942094928 15189120 4875088
15:35:14 51760 8192000000 10901298704 11359670272 1955137408 19.267 100 31 62 1 1973903712 9701408 9064896
15:36:11 55557 8192000000 10879779360 11349831680 1921051440 18.995 98 15 30 0 1939007472 13693088 4262944
15:37:14 37648 8192000000 10852374672 11315560448 1873153824 18.610 96 9 18 0 1886660352 10465408 3041120
15:38:05 27422 8192000000 10887998336 11320008704 1868483856 18.572 96 35 68 1 1886268768 8538928 9245984
15:38:40 36973 8192000000 10876745312 11321610240 1914134064 18.940 99 40 78 1 1936221920 10825088 11262768
15:39:24 35419 8192000000 10871606112 11327692800 1916773408 18.961 99 39 78 0 1942074176 14410096 10890672
15:40:10 53297 8192000000 10865958992 11329998848 1891072672 18.754 98 22 44 1 1912854544 15753840 6028032
15:42:50 48629 8192000000 10856223328 11313299456 1904595504 18.863 99 17 34 0 1920855040 11223728 5035808
15:43:49 71305 8192000000 10835784032 11304448000 1850104128 18.423 96 9 18 2 1864078976 11325824 2649024
15:45:53 107220 8192000000 10851331984 11314180096 1849482496 18.418 96 22 44 1 1865497408 8999360 7015552
15:47:47 27489 8192000000 10836277328 11299454976 1866860176 18.559 97 12 24 0 1888536368 18149792 3526400
15:48:45 66105 8192000000 10846212656 11327672320 1896935936 18.802 99 10 20 1 1920802320 20617536 3248848
15:51:05 81414 8192000000 10864315792 11339599872 1931972480 19.083 100 9 18 0 1946888288 12459264 2456544
15:52:36 67765 8192000000 10859818016 11334684672 1914273888 18.941 99 8 16 0 1929900160 13002416 2623856
15:53:50 80363 8192000000 10853039248 11314176000 1879969376 18.665 97 22 44 0 1902536736 15561408 7005952
15:55:16 38002 8192000000 10869572400 11332218880 1941446000 19.158 100 29 58 0 1957378720 8282288 7650432
15:56:10 34099 8192000000 10874444848 11342282752 1932138688 19.084 99 29 58 2 1950958704 10275136 8544880
15:56:50 83986 8192000000 10913790528 11376726016 1966181600 19.355 100 23 46 1 1985504000 12720320 6602080
15:58:31 24593 8192000000 10924628688 11389825024 1982474352 19.484 100 24 48 1 2009760928 20259472 7027104
15:59:02 123236 8192000000 10888459952 11354738688 1886026640 18.714 95 11 22 1 1911638896 23000832 2611424
16:01:28 67801 8192000000 10900400752 11363803136 1929329664 19.062 98 15 30 1 1947971584 14713360 3928560
16:02:42 45302 8192000000 10885863648 11340226560 1888216048 18.731 96 17 34 1 1903759328 10989856 4553424
16:03:37 40813 8192000000 10892213408 11352625152 1940023008 19.147 99 21 42 1 1957144160 11485312 5635840
16:04:27 37265 8192000000 10904133840 11365838848 1961166176 19.315 100 32 64 2 1979900976 9656544 9078256
16:05:16 93062 8192000000 10925259424 11391197184 1980422432 19.468 100 25 50 0 2004841744 17183584 7235728
16:06:58 90390 8192000000 10899435936 11364098048 1942808496 19.169 98 18 36 0 1961432784 12866384 5757904
16:09:30 81191 8192000000 10877431456 11354497024 1895965792 18.794 96 21 42 0 1913660768 11626944 6068032
16:10:57 26692 8192000000 10885037648 11360944128 1955599408 19.271 100 6 12 0 1968515360 11177712 1738240
16:11:41 66107 8192000000 10879394672 11354984448 1944055392 19.179 99 8 16 0 1956880704 10528496 2296816
16:13:02 78125 8192000000 10886734800 11367780352 1955217120 19.268 99 13 26 2 1971735104 12833184 3684800
16:14:33 85336 8192000000 10903825344 11372351488 1935168608 19.108 98 12 24 0 1955237168 16299744 3768816
16:17:06 74628 8192000000 10846676592 11323658240 1848123344 18.407 94 8 16 0 1858621888 8130352 2368192
16:18:37 71069 8192000000 10875291840 11348680704 1939314112 19.141 99 19 38 1 1952924544 8949184 4661248
16:19:58 53401 8192000000 10884886176 11350007808 1927594384 19.048 98 24 48 1 1946038576 10994144 7450048
16:21:02 60817 8192000000 10866976400 11327619072 1858735776 18.493 95 25 51 2 1878711712 12945296 7030640
16:22:25 88116 8192000000 10859958240 11321737216 1852707632 18.444 96 17 34 0 1872915680 15811920 4396128
16:25:07 53779 8192000000 10861169040 11302313984 1837271648 18.319 95 22 44 0 1852038160 8401696 6364816
16:26:12 60393 8192000000 9528497552 9840005120 668175472 7.541 36 12 24 0 676838960 5150592 3512896

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 04-12-2020 16:28:02 to 04-12-2020 16:28:34.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 119 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 04-12-2020 16:28:35 to 04-12-2020 16:28:36.

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          241537
MON$OLDEST_ACTIVE               241538
MON$OLDEST_SNAPSHOT             241538
MON$NEXT_TRANSACTION            241538
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                       2013760
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.33396 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33396 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33396 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33396 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 ---
:34: 
:35: mscs-test-161.budzdorov.ru    Fri Dec  4 16:27:15 2020
:36:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:37: 
--- end of diff output ---

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

04.12.20 16:28:37. 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
2020-12-04 16:28:40 No severe PSQL-related problems occured
04.12.20 16:28:41. End of report.