Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 18.02.2021 16:32
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 16866812 kB
MemAvailable 31131500 kB
Buffers 0 kB
Cached 14804596 kB
SwapCached 4064 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-02-18 16:31:16
DTS_END                         2021-02-18 16:31:16.2890
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/53082
TRN_ID                          247239
ATT_ID                          674
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: 9376.30 25596 1125156
customer order: creation 174.00 366 20880
customer order: refuse 14.55 339 1746
order to supplier: creation 47.28 1247 5673
order to supplier: removal 3.29 120487 395
invoice (draft): creation 46.08 3473 5529
invoice (draft): removal 52.37 893 6284
invoice accept: apply 42.88 18263 5145
invoice accept: cancel 47.68 819 5722
customer reserve: creation 3999.10 178 479892
customer reserve: removal 4652.20 66 558264
realization accept: apply 85.86 192 10303
realization accept: cancel 79.37 109 9524
payment from customer: creation 59.37 134 7124
payment from customer: removal 5.79 126 695
payment to supplier: creation 49.58 172 5950
payment to supplier: removal 3.76 136 451
service: total inventory turnovers 5.24 917 629
service: total monetary turnovers 7.01 28 841
service: aggregate perf. data 0.88 16943 105
service: refresh index statistics 0.03 347037 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 18-02-2021 16:32:33 to 18-02-2021 16:32:36.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4215
TEST_TIME 2 3842
TEST_TIME 3 3125
TEST_TIME 4 3372
TEST_TIME 5 5250
TEST_TIME 6 4998
TEST_TIME 7 5051
TEST_TIME 8 5482
TEST_TIME 9 5432
TEST_TIME 10 5394
TEST_TIME 11 5528
TEST_TIME 12 5880
TEST_TIME 13 6577
TEST_TIME 14 7100
TEST_TIME 15 7641
TEST_TIME 16 7754
TEST_TIME 17 7959
TEST_TIME 18 7937
TEST_TIME 19 8153
TEST_TIME 20 8481
TEST_TIME 21 8487
TEST_TIME 22 8362
TEST_TIME 23 8332
TEST_TIME 24 9250
TEST_TIME 25 9427
TEST_TIME 26 9585
TEST_TIME 27 10744
TEST_TIME 28 11261
TEST_TIME 29 12082
TEST_TIME 30 11801
TEST_TIME 31 11733
TEST_TIME 32 11672
TEST_TIME 33 11529
TEST_TIME 34 11540
TEST_TIME 35 11285
TEST_TIME 36 11036
TEST_TIME 37 10941
TEST_TIME 38 10908
TEST_TIME 39 10722
TEST_TIME 40 10658
TEST_TIME 41 10491
TEST_TIME 42 10488
TEST_TIME 43 10568
TEST_TIME 44 10413
TEST_TIME 45 10303
TEST_TIME 46 10202
TEST_TIME 47 10107
TEST_TIME 48 10040
TEST_TIME 49 9970
TEST_TIME 50 9946
TEST_TIME 51 10092
TEST_TIME 52 9964
TEST_TIME 53 9920
TEST_TIME 54 9979
TEST_TIME 55 9970
TEST_TIME 56 9957
TEST_TIME 57 9894
TEST_TIME 58 9883
TEST_TIME 59 9969
TEST_TIME 60 10040
TEST_TIME 61 10106
TEST_TIME 62 10074
TEST_TIME 63 10022
TEST_TIME 64 10156
TEST_TIME 65 10187
TEST_TIME 66 10141
TEST_TIME 67 10175
TEST_TIME 68 10151
TEST_TIME 69 10051
TEST_TIME 70 10008
TEST_TIME 71 9961
TEST_TIME 72 9928
TEST_TIME 73 9883
TEST_TIME 74 9885
TEST_TIME 75 9817
TEST_TIME 76 9781
TEST_TIME 77 9703
TEST_TIME 78 9660
TEST_TIME 79 9720
TEST_TIME 80 9700
TEST_TIME 81 9690
TEST_TIME 82 9723
TEST_TIME 83 9703
TEST_TIME 84 9690
TEST_TIME 85 9755
TEST_TIME 86 9737
TEST_TIME 87 9830
TEST_TIME 88 9821
TEST_TIME 89 9846
TEST_TIME 90 9791
TEST_TIME 91 9828
TEST_TIME 92 9771
TEST_TIME 93 9720
TEST_TIME 94 9653
TEST_TIME 95 9625
TEST_TIME 96 9604
TEST_TIME 97 9558
TEST_TIME 98 9561
TEST_TIME 99 9567
TEST_TIME 100 9536
TEST_TIME 101 9566
TEST_TIME 102 9534
TEST_TIME 103 9554
TEST_TIME 104 9549
TEST_TIME 105 9553
TEST_TIME 106 9551
TEST_TIME 107 9585
TEST_TIME 108 9583
TEST_TIME 109 9630
TEST_TIME 110 9598
TEST_TIME 111 9530
TEST_TIME 112 9510
TEST_TIME 113 9475
TEST_TIME 114 9472
TEST_TIME 115 9409
TEST_TIME 116 9408
TEST_TIME 117 9442
TEST_TIME 118 9466
TEST_TIME 119 9435
TEST_TIME 120 9376

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 18-02-2021 16:32:37 to 18-02-2021 16:32:40.

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 1569291 1569291 0 0.00 0 18804 6 0 0
doc_list_biud 1569290 1569290 0 0.00 0 27092 30 0 0
sp_add_invoice_to_stock 5328 5145 183 3.43 34 187968 18263 0 183
sp_cancel_adding_invoice 5722 5722 0 0.00 5 40375 820 0 0
sp_cancel_client_order 1746 1746 0 0.00 4 7543 340 0 0
sp_cancel_customer_reserve 558264 558264 0 0.00 1 20291 66 0 0
sp_cancel_pay_from_customer 695 695 0 0.00 2 18809 127 0 0
sp_cancel_pay_to_supplier 451 451 0 0.00 2 12883 136 0 0
sp_cancel_supplier_invoice 6299 6284 15 0.23 2 25892 893 0 15
sp_cancel_supplier_order 395 395 0 0.00 8 1295113 120487 0 0
sp_cancel_write_off 9524 9524 0 0.00 1 11587 110 0 0
sp_client_order 20880 20880 0 0.00 3 28699 367 0 0
sp_customer_reserve 479892 479892 0 0.00 0 116412 178 0 0
sp_fill_shopping_cart 32068 32068 0 0.00 1 36233 42 0 0
sp_fill_shopping_cart_clo_res 479892 479892 0 0.00 0 17268 14 0 0
sp_get_clo_for_invoice 5145 5145 0 0.00 0 33156 305 0 0
sp_kill_cost_storno 16392 16392 0 0.00 0 18802 63 0 0
sp_kill_qstorno_ret_qs2qd 1132731 1132731 0 0.00 0 25876 36 0 0
sp_kill_qty_storno 597383 597383 0 0.00 0 27091 77 0 0
sp_lock_selected_doc 21237 21237 0 0.00 0 8861 6 0 0
sp_make_cost_storno 28522 28522 0 0.00 0 14788 60 0 0
sp_multiply_rows_for_pdistr 28522 28522 0 0.00 0 9358 31 0 0
sp_multiply_rows_for_qdistr 20880 20880 0 0.00 0 13113 161 0 0
sp_pay_from_customer 7124 7124 0 0.00 4 13253 135 0 0
sp_pay_to_supplier 5950 5950 0 0.00 5 42819 173 0 0
sp_payment_common 13074 13074 0 0.00 1 42574 48 0 0
sp_qd_handle_on_cancel_clo 1746 1746 0 0.00 0 7537 296 0 0
sp_qd_handle_on_invoice_upd_sts 10867 10867 0 0.00 0 27090 365 0 0
sp_qd_handle_on_reserve_upd_sts 10303 10303 0 0.00 0 14622 55 0 0
sp_reserve_write_off 10303 10303 0 0.00 6 17508 192 0 0
sp_supplier_invoice 5529 5529 0 0.00 7 93783 3474 0 0
sp_supplier_order 5673 5673 0 0.00 5 26214 1248 0 0
srv_aggregate_perf_data 106 105 1 0.94 2594 140712 16944 0 1
srv_fill_mon_cache_memory 166 166 0 0.00 1096 229987 31768 0 0
srv_find_qd_qs_mism 1076234 1076234 0 0.00 0 7158 5 0 0
srv_make_invnt_saldo 629 629 0 0.00 33 40273 918 0 0
srv_make_money_saldo 841 841 0 0.00 0 659 28 0 0
srv_recalc_idx_stat 4 4 0 0.00 195498 543731 347037 0 0
t$perf-abend:sp_add_invoice_to_stock 183 183 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 15 15 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5145 5145 0 0.00 0 13379 174 0 0
t$perf-norm:sp_cancel_adding_invoice 406 406 0 0.00 0 2966 80 0 0
t$perf-norm:sp_cancel_client_order 1746 1746 0 0.00 0 2357 11 0 0
t$perf-norm:sp_cancel_customer_reserve 713 713 0 0.00 0 2731 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 695 695 0 0.00 0 426 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 451 451 0 0.00 0 4487 14 0 0
t$perf-norm:sp_cancel_supplier_invoice 385 385 0 0.00 0 3981 28 0 0
t$perf-norm:sp_cancel_supplier_order 395 395 0 0.00 0 27338 1706 0 0
t$perf-norm:sp_cancel_write_off 998 998 0 0.00 0 4210 15 0 0
t$perf-norm:sp_client_order 20880 20880 0 0.00 0 9404 18 0 0
t$perf-norm:sp_customer_reserve 1002 1002 0 0.00 0 3189 11 0 0
t$perf-norm:sp_pay_from_customer 7124 7124 0 0.00 0 4292 8 0 0
t$perf-norm:sp_pay_to_supplier 5950 5950 0 0.00 0 13390 14 0 0
t$perf-norm:sp_reserve_write_off 10303 10303 0 0.00 0 10220 15 0 0
t$perf-norm:sp_supplier_invoice 5529 5529 0 0.00 0 10325 18 0 0
t$perf-norm:sp_supplier_order 5673 5673 0 0.00 0 4047 15 0 0
t$perf-norm:srv_aggregate_perf_data 105 105 0 0.00 0 1287 18 0 0
t$perf-norm:srv_fill_mon_cache_memory 166 166 0 0.00 0 281 3 0 0
t$perf-norm:srv_make_invnt_saldo 629 629 0 0.00 0 2982 27 0 0
t$perf-norm:srv_make_money_saldo 841 841 0 0.00 0 596 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 6 3 0 0
v_add_invoice_to_stock 10656 10290 366 3.43 0 11428 20 0 366
v_all_customers 37814 37814 0 0.00 0 20 1 0 0
v_all_suppliers 31088 31088 0 0.00 0 23 1 0 0
v_all_wares 41760 41760 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 812 812 0 0.00 0 4394 11 0 0
v_cancel_client_order 3492 3492 0 0.00 0 6286 13 0 0
v_cancel_customer_prepayment 1390 1390 0 0.00 0 6068 11 0 0
v_cancel_customer_reserve 1426 1426 0 0.00 0 3491 7 0 0
v_cancel_payment_to_supplier 902 902 0 0.00 0 4417 17 0 0
v_cancel_supplier_invoice 800 770 30 3.75 0 862 15 0 30
v_cancel_supplier_order 790 790 0 0.00 0 8781 23 0 0
v_cancel_write_off 1996 1996 0 0.00 0 3612 16 0 0
v_max_id_clo_ord 5673 5673 0 0.00 0 3261 2 0 0
v_max_id_clo_res 1002 1002 0 0.00 0 4997 12 0 0
v_max_id_ord_sup 5515 5515 0 0.00 0 4489 7 0 0
v_max_non_paid_invoice 1594 1594 0 0.00 0 2994 5 0 0
v_max_non_paid_realizn 3840 3840 0 0.00 0 7049 8 0 0
v_min_id_clo_ord 5673 5673 0 0.00 0 9192 14 0 0
v_min_id_clo_res 1002 1002 0 0.00 0 1307 6 0 0
v_min_id_ord_sup 5515 5515 0 0.00 0 4828 6 0 0
v_min_non_paid_invoice 5950 5950 0 0.00 0 42559 47 0 0
v_min_non_paid_realizn 7124 7124 0 0.00 0 13224 27 0 0
v_our_firm 10514 10514 0 0.00 0 13 1 0 0
v_reserve_write_off 20606 20606 0 0.00 0 9125 10 0 0
x_lock_depdocs_on_canc_invoice 11621 11621 0 0.00 0 21033 132 0 0
x_lock_depdocs_on_canc_sup_ord 395 395 0 0.00 0 6072 388 0 0
x_make_qstorno_1000_1200 5673 5673 0 0.00 1 26202 1155 0 0
x_make_qstorno_1200_2000 5529 5529 0 0.00 4 93770 3328 0 0
x_make_qstorno_2100_3300 479892 479892 0 0.00 0 116411 162 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 18-02-2021 16:32:41 to 18-02-2021 16:32:45.

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
14:01:20 2 8192000000 8798851152 8809447424 5084640 0.062 1 1 2 0 5202688 55488 62560
14:01:26 15999 8192000000 10230693568 10542325760 828632080 9.185 67 50 101 0 848157056 2360176 17164800
14:01:53 38537 8192000000 10355888848 10674909184 1384982112 14.461 100 79 157 1 1415064416 5018656 25063648
14:02:41 16612 8192000000 10386336080 10707824640 1438998656 14.941 100 94 188 0 1477375232 7157472 31219104
14:03:05 20342 8192000000 10400464128 10725769216 1451058112 15.047 100 90 180 1 1488431952 7730256 29643584
14:03:39 27975 8192000000 10427194864 10755522560 1471548464 15.227 100 89 178 0 1509226912 8495008 29183440
14:04:18 23950 8192000000 10442512624 10776199168 1498778736 15.466 100 92 184 0 1537541648 9282176 29480736
14:04:59 19845 8192000000 10476630384 10814238720 1523821856 15.683 100 90 180 2 1562947072 10402720 28722496
14:05:28 19486 8192000000 10484356560 10833498112 1542180544 15.842 100 83 166 0 1579122544 11187664 25754336
14:06:02 7412 8192000000 10512483408 10865754112 1573783664 16.115 100 79 157 0 1608509712 10944624 23781424
14:06:19 13527 8192000000 10538505728 10897338368 1590899088 16.262 100 71 141 2 1623183632 10907232 21377312
14:06:42 5884 8192000000 10566040944 10924785664 1628064896 16.578 100 80 160 1 1664172192 11883232 24224064
14:06:59 9803 8192000000 10588448752 10947624960 1644187312 16.715 100 84 169 1 1681837696 12752640 24897744
14:07:17 9776 8192000000 10598774096 10957938688 1648313584 16.750 100 81 162 0 1684504272 12362496 23828192
14:07:36 8197 8192000000 10609124128 10975518720 1663726976 16.880 100 80 160 1 1700459168 12886992 23845200
14:07:52 7881 8192000000 10619414384 10988269568 1681579824 17.031 100 77 153 0 1716381840 12305984 22496032
14:08:06 8765 8192000000 10638372336 11009462272 1702835136 17.209 100 81 162 1 1739115264 12826304 23453824
14:08:23 7753 8192000000 10656740064 11033853952 1721498496 17.365 100 81 162 0 1756898288 12174592 23225200
14:08:38 7931 8192000000 10676580080 11053821952 1734674336 17.474 100 84 167 0 1770594560 11680400 24239824
14:08:54 6483 8192000000 10678875744 11062779904 1747016336 17.577 100 70 140 1 1778513440 11811408 19685696
14:09:09 4134 8192000000 10694488544 11079327744 1763471856 17.713 100 74 145 0 1795208928 11411760 20325312
14:09:20 3323 8192000000 10718095472 11099901952 1778887712 17.840 100 80 160 1 1813544240 11618928 23037600
14:09:30 3295 8192000000 10713500576 11096510464 1782509616 17.870 100 70 138 1 1813796704 11800864 19486224
14:09:40 2863 8192000000 10720623920 11108388864 1789934288 17.931 100 75 151 2 1822988880 12572304 20482288
14:09:49 3102 8192000000 10742409168 11123462144 1799254496 18.008 100 86 173 0 1836687312 13086784 24346032
14:09:59 3332 8192000000 10745204896 11129606144 1805980944 18.063 100 87 173 1 1843402624 13032320 24389360
14:10:09 3485 8192000000 10733750112 11124236288 1807737840 18.077 100 86 165 1 1842666080 12713360 22214880
14:10:20 3147 8192000000 10761057824 11147227136 1814726064 18.135 100 81 160 1 1849751328 12683984 22341280
14:10:30 2339 8192000000 10777181104 11163090944 1831721824 18.273 100 85 170 2 1868895376 13650528 23523024
14:10:39 1790 8192000000 10776102352 11164954624 1841648736 18.354 100 83 166 0 1877346160 12941376 22756048
14:10:47 2322 8192000000 10785526064 11173720064 1842534032 18.361 100 90 180 3 1879706544 12419680 24752832
14:10:56 2526 8192000000 10789002848 11174240256 1849058160 18.414 100 88 176 1 1886917104 13437152 24421792
14:11:06 1800 8192000000 10797455232 11185905664 1854069888 18.455 100 90 180 0 1893079408 13749504 25260016
14:11:14 1763 8192000000 10797225200 11186274304 1857155952 18.480 100 90 179 0 1895883744 14078192 24649600
14:11:22 1682 8192000000 10812960976 11200839680 1866547600 18.556 100 90 181 2 1905118672 13305648 25265424
14:11:30 1964 8192000000 10810143696 11198611456 1865810832 18.550 100 92 184 0 1905791952 14045600 25935520
14:11:38 1262 8192000000 10804651040 11199041536 1868713824 18.574 100 92 184 1 1908945984 13165120 27067040
14:11:45 3326 8192000000 10785685376 11192020992 1863888960 18.535 100 64 128 0 1892186272 10422160 17875152
14:11:59 3430 8192000000 10790440496 11199897600 1867813904 18.567 100 67 134 1 1897962160 10927888 19220368
14:12:11 3187 8192000000 10789191200 11201589248 1870707536 18.590 100 58 118 2 1896395104 9500784 16186784
14:12:21 3274 8192000000 10795566480 11207839744 1873200720 18.610 100 47 92 4 1896349408 10579456 12569232
14:12:31 3140 8192000000 10799665456 11215331328 1877765664 18.647 100 36 72 1 1896498864 9208016 9525184
14:12:41 1749 8192000000 10815707232 11219976192 1886926368 18.721 100 68 136 0 1916618384 9854416 19837600
14:12:50 6238 8192000000 10798458048 11217199104 1883111216 18.690 100 53 107 0 1908885712 10824272 14950224
14:13:03 14360 8192000000 10800810416 11218292736 1885673488 18.711 100 40 78 2 1903462560 5486800 12302272
14:13:24 9698 8192000000 10798594752 11224600576 1888190256 18.731 100 32 64 1 1905415728 8541360 8684112
14:13:42 51098 8192000000 10823247280 11235917824 1889313808 18.740 100 32 65 2 1904334176 4988896 10031472
14:14:40 2128 8192000000 10819690688 11242786816 1896805600 18.801 100 53 106 1 1922448688 10517232 15125856
14:14:55 7055 8192000000 10804020400 11236249600 1893261264 18.772 100 24 48 0 1905641952 5904592 6476096
14:15:09 3160 8192000000 10819689184 11244601344 1894415568 18.781 100 41 82 0 1917914688 11770080 11729040
14:15:18 7322 8192000000 10816125776 11241918464 1893408944 18.773 100 26 53 0 1907628000 6493504 7725552
14:15:32 4028 8192000000 10814914832 11243520000 1897268272 18.804 100 38 76 1 1915296480 6630880 11397328
14:15:49 8155 8192000000 10807844032 11243573248 1895222096 18.788 100 20 40 1 1907789776 5788512 6779168
14:16:05 4307 8192000000 10821647024 11250921472 1899039936 18.819 100 31 62 1 1915507328 6824272 9643120
14:16:19 9341 8192000000 10819118768 11255701504 1903740592 18.856 100 25 50 2 1920634064 10104688 6788784
14:16:36 11438 8192000000 10816195984 11251650560 1907564016 18.887 100 19 36 1 1918408512 5528336 5316160
14:16:54 3046 8192000000 10824018912 11257167872 1907967664 18.890 100 28 56 0 1923504432 7883648 7653120
14:17:03 7544 8192000000 10821537056 11260575744 1908972464 18.898 100 33 67 1 1925775776 7726224 9077088
14:17:19 7584 8192000000 10834219616 11265286144 1912161360 18.924 100 28 55 1 1926964768 6379184 8424224
14:17:33 6777 8192000000 10832019296 11261734912 1913500528 18.935 100 27 54 1 1927974768 7305680 7168560
14:17:50 52769 8192000000 10828667728 11260432384 1913522032 18.935 100 29 58 2 1927762816 6160048 8080736
14:18:50 22942 8192000000 10823383104 11259985920 1911556224 18.919 100 26 52 2 1925928608 6964624 7407760
14:19:19 11154 8192000000 10815660800 11252228096 1889746000 18.744 99 20 40 1 1901071584 5626048 5699536
14:19:39 8440 8192000000 10828211648 11255713792 1907860272 18.889 100 27 54 3 1922366240 6473392 8032576
14:19:55 7808 8192000000 10827369360 11261489152 1907899424 18.890 100 18 36 1 1919663584 6332176 5431984
14:20:11 7096 8192000000 10811010768 11247153152 1878662400 18.654 98 27 56 1 1892088304 5475616 7950288
14:20:25 9460 8192000000 10823882528 11250253824 1887822336 18.728 99 23 47 1 1899999184 5654080 6522768
14:20:44 5601 8192000000 10821680160 11250933760 1900836176 18.833 100 31 62 2 1916020272 6333152 8850944
14:21:01 10879 8192000000 10810940528 11243491328 1867399024 18.563 98 28 57 2 1881720320 6212544 8108752
14:21:22 5692 8192000000 10793704080 11223801856 1854882976 18.462 98 30 60 1 1869557056 5952368 8721712
14:21:34 11919 8192000000 10741795536 11165548544 1762830240 17.708 95 25 48 1 1776734848 5957392 7947216
14:21:52 11219 8192000000 10751748608 11176132608 1793516768 17.961 97 18 36 1 1804426848 5693072 5217008
14:22:10 7572 8192000000 10740913696 11156021248 1802807840 18.037 98 30 61 0 1817847808 5783568 9256400
14:22:26 73686 8192000000 10717851168 11133710336 1618241840 16.495 88 32 62 0 1631349152 4787936 8319376
14:23:49 3464 8192000000 10695665504 11117043712 1752274160 17.620 98 33 67 1 1769128352 6806368 10047824
14:23:59 8422 8192000000 10716859248 11128717312 1766488224 17.738 98 32 62 2 1782200848 5603760 10108864
14:24:15 3893 8192000000 10684182192 11096731648 1747346848 17.580 98 26 52 1 1760920768 6097760 7476160
14:24:27 5417 8192000000 10701007328 11109113856 1760387072 17.688 99 28 56 4 1773425600 5231280 7807248
14:24:39 5788 8192000000 10692271056 11100803072 1768193984 17.752 99 24 48 0 1780974928 5687808 7093136
14:24:52 4219 8192000000 10683367040 11096530944 1756016384 17.651 98 30 59 1 1771394576 6146736 9231456
14:25:03 8778 8192000000 10698827392 11108909056 1754205184 17.636 98 27 54 0 1768350080 6739872 7405024
14:25:19 10583 8192000000 10695043664 11117998080 1763556816 17.714 98 25 52 0 1776444368 5590320 7297232
14:25:36 8790 8192000000 10721691728 11138052096 1795411712 17.976 100 20 39 0 1805890368 4697856 5780800
14:25:51 9657 8192000000 10722368640 11146559488 1784460640 17.886 98 30 60 1 1799806656 6035552 9310464
14:26:10 5244 8192000000 10728236624 11147304960 1814514512 18.133 100 31 62 2 1829819760 5740096 9565152
14:26:22 4477 8192000000 10751211664 11163725824 1829961312 18.259 100 36 71 3 1846906784 5544512 11400960
14:26:35 10651 8192000000 10739499456 11162603520 1825621520 18.224 100 19 38 0 1836850000 5837760 5390720
14:26:52 22124 8192000000 10752003152 11179302912 1838703440 18.330 100 31 62 1 1854680992 6049648 9927904
14:27:43 45590 8192000000 10751772912 11186335744 1847862304 18.405 100 22 44 1 1860551872 6099648 6589920
14:28:35 15119 8192000000 10765003680 11188080640 1830658608 18.265 99 20 40 2 1842156480 5793536 5704336
14:28:57 5893 8192000000 10757969248 11185283072 1848821552 18.413 100 25 50 1 1863135120 7169456 7144112
14:29:10 5497 8192000000 10759990368 11188793344 1849520368 18.418 100 16 32 1 1859234560 5568656 4145536
14:29:23 6941 8192000000 10775029600 11196657664 1856175408 18.472 100 19 37 3 1867590320 5539936 5874976
14:29:36 7452 8192000000 10779450928 11203747840 1861996816 18.519 100 29 59 0 1880263376 9707168 8559392
14:29:50 7877 8192000000 10774382240 11201728512 1860592848 18.508 100 21 42 2 1872550912 6560688 5397376
14:30:04 8834 8192000000 10774090320 11207487488 1862801216 18.526 100 31 61 2 1877756928 6518272 8437440
14:30:23 8056 8192000000 10791565776 11210391552 1869694896 18.582 100 34 68 5 1886152400 5337792 11119712
14:30:39 10455 8192000000 10787352704 11215319040 1868781856 18.574 100 24 48 0 1881687744 5720368 7185520
14:30:57 10288 8192000000 10820837328 11232071680 1879257616 18.659 100 44 88 2 1898602688 5029872 14315200
14:31:14 30004 8192000000 10822193184 11242557440 1899662688 18.824 100 31 62 0 1913891072 4410544 9817840
14:31:58 10488 8192000000 10810218752 11229339648 1884850672 18.704 99 38 76 1 1901647328 5285728 11510928
14:32:21 13681 8192000000 10839016640 11256389632 1909704016 18.904 100 44 88 1 1930575952 6633904 14238032
14:32:43 5054 8192000000 10858616784 11273568256 1922064416 19.003 100 61 122 2 1948333904 8609536 17659952
14:32:58 25252 8192000000 10856103568 11278635008 1917697696 18.968 100 43 86 0 1938746000 9516784 11531520
14:33:32 77259 8192000000 10871358208 11296739328 1932067536 19.083 100 48 96 1 1962572400 16986416 13518448
14:34:57 59491 8192000000 10864681456 11303268352 1935734784 19.113 100 39 78 3 1963180976 15180752 12265440
14:36:04 25520 8192000000 10880065728 11308277760 1937782704 19.129 100 32 64 3 1962524496 15380160 9361632
14:36:41 19717 8192000000 10863321376 11286859776 1916436448 18.958 99 40 77 0 1942341824 14813888 11091488
14:37:13 17023 8192000000 10876961152 11309318144 1940609568 19.152 100 50 98 0 1971335984 15956144 14770272
14:37:37 14729 8192000000 10898040704 11321237504 1954462656 19.262 100 61 118 3 1989889744 18053616 17373472
14:38:04 9923 8192000000 10905866816 11327025152 1955250832 19.268 100 56 111 1 1992694032 20969424 16473776
14:38:22 16907 8192000000 10905842336 11334737920 1962094032 19.323 100 56 111 0 2000336672 22017056 16225584
14:38:49 2809 8192000000 10912214976 11337568256 1968643344 19.375 100 68 136 0 2008290352 20045664 19601344
14:39:00 10387 8192000000 10925863360 11348221952 1975404320 19.428 100 70 138 1 2017250864 21835808 20010736
14:39:18 5775 8192000000 10927721632 11351392256 1974007808 19.417 100 57 112 1 2012489456 22248368 16233280
14:39:32 2631 8192000000 10940068560 11353378816 1979594096 19.461 100 69 135 3 2019237072 20242784 19400192
14:39:42 3820 8192000000 10940895008 11362430976 1985178864 19.506 100 71 141 0 2027145664 21093040 20873760
14:39:55 8150 8192000000 10924889552 11355029504 1985787824 19.510 100 55 110 0 2022909744 21272272 15849648
14:40:19 5425 8192000000 10929926128 11356131328 1949359152 19.221 98 56 113 2 1989855824 23965408 16531264
14:40:31 7036 8192000000 10919505168 11350925312 1962844576 19.329 99 59 114 0 2004463680 23207920 18411184
14:40:53 7202 8192000000 10923032848 11354361856 1976751472 19.439 100 62 119 0 2017466160 23356704 17357984
14:41:07 6882 8192000000 10946973184 11370004480 1985172032 19.506 100 73 144 2 2035850528 28662000 22016496
14:41:26 12251 8192000000 10927303568 11354583040 1961876816 19.321 99 62 123 0 2006552864 26102784 18573264
14:41:47 3354 8192000000 10936755360 11363164160 1974069424 19.418 100 58 114 1 2019022704 28232768 16720512
14:41:59 7871 8192000000 10941872544 11366817792 1979607648 19.462 100 65 124 0 2027568432 29580576 18380208
14:42:18 2445 8192000000 10946724960 11367772160 1985085968 19.505 100 61 122 1 2035172576 31022912 19063696
14:42:30 7142 8192000000 10946470240 11373895680 1983357728 19.491 100 61 121 2 2035653328 33763888 18531712
14:42:58 2005 8192000000 10973452544 11387219968 1992942368 19.567 100 90 180 0 2057329264 35920000 28466896
14:43:06 2631 8192000000 10965074528 11382734848 1990652800 19.549 100 81 160 1 2051800400 36597936 24549664
14:43:19 11035 8192000000 10955114176 11372929024 1964427840 19.341 99 71 142 3 2024441024 38493792 21519392
14:43:41 1499 8192000000 10967441792 11387600896 1991565584 19.556 100 81 161 0 2059015984 42503456 24946944
14:43:49 2766 8192000000 10979756224 11400110080 1998706960 19.613 100 75 150 3 2066144960 43178144 24259856
14:44:00 4290 8192000000 10982394512 11408732160 2007536032 19.682 100 81 162 1 2074693024 41622560 25534432
14:44:11 4997 8192000000 10969928752 11390160896 1995693088 19.589 100 75 149 0 2055234080 37044912 22496080
14:44:23 2043 8192000000 10981449536 11391479808 1989700768 19.541 99 94 188 2 2055346160 37633632 28011760
14:44:34 2906 8192000000 10990745632 11405242368 2005048512 19.663 100 89 174 1 2071280736 39208800 27023424
14:44:44 1921 8192000000 10987425392 11404943360 2005654944 19.667 100 88 176 0 2071603552 39132752 26815856
14:44:52 2979 8192000000 10967856272 11391819776 1984696288 19.502 99 78 155 2 2049556752 40566464 24294000
14:45:03 4262 8192000000 10965562720 11389562880 1991943584 19.559 100 68 136 1 2052453216 39459568 21050064
14:45:17 1955 8192000000 10960805920 11374706688 1982891152 19.488 100 92 184 0 2051935872 39709728 29334992
14:45:25 3036 8192000000 10943091664 11354652672 1948008032 19.211 99 77 153 1 2012112352 40212208 23892112
14:45:35 3481 8192000000 10952604224 11366539264 1970667328 19.391 100 75 150 3 2034125856 40445328 23013200
14:45:46 3818 8192000000 10920034400 11346251776 1938397872 19.134 99 72 144 1 2002163104 40803984 22961248
14:45:57 1968 8192000000 10926133152 11346591744 1948279216 19.213 100 71 142 1 2011847088 41393056 22174816
14:46:06 4210 8192000000 10936122992 11359121408 1959485104 19.302 100 68 136 0 2021372192 40626480 21260608
14:46:20 3993 8192000000 10945010992 11360628736 1958029040 19.290 100 81 158 2 2026052640 43857440 24166160
14:46:32 1362 8192000000 10964987488 11374563328 1970683088 19.391 100 90 175 0 2043986704 45518064 27785552
14:46:40 2511 8192000000 10953893408 11371397120 1972184176 19.403 100 73 146 1 2038287440 42458464 23644800
14:46:50 8193 8192000000 10930945824 11357241344 1961011584 19.314 100 66 133 0 2021028048 39579296 20437168
14:47:09 4789 8192000000 10939900144 11353874432 1941777648 19.161 99 70 142 1 2003125024 38979152 22368224
14:47:21 2492 8192000000 10941367600 11359252480 1961994304 19.322 100 76 151 3 2026025536 39872160 24159072
14:47:30 2040 8192000000 10947783040 11355848704 1959437744 19.302 100 81 161 2 2025178912 40080400 25660768
14:47:39 4013 8192000000 10942225984 11359625216 1964742832 19.344 100 74 148 1 2026314128 38987792 22583504
14:47:51 1920 8192000000 10968324608 11384238080 1982492832 19.484 100 88 177 1 2050432128 40771008 27168288
14:48:00 4901 8192000000 10967420704 11379646464 1961570624 19.319 99 81 162 1 2029254048 42304704 25378720
14:48:14 1743 8192000000 10949089264 11362152448 1961642512 19.319 99 84 166 1 2031770896 44158528 25969856
14:48:25 2652 8192000000 10953421296 11356110848 1960056560 19.306 100 84 166 0 2028222640 41835440 26330640
14:48:38 1440 8192000000 10923019872 11328679936 1934146128 19.100 99 83 164 1 2002937360 42702560 26088672
14:48:48 3950 8192000000 10954605952 11362455552 1963890080 19.337 100 89 177 1 2037031840 46042800 27098960
14:49:02 4740 8192000000 10947038880 11356008448 1958780192 19.296 100 76 151 2 2025603920 42767088 24056640
14:49:19 6938 8192000000 10941595520 11365228544 1960249264 19.308 100 65 130 3 2024434576 43174448 21010864
14:49:36 3395 8192000000 10960973040 11377176576 1969971728 19.385 100 76 152 1 2041067056 46837344 24257984
14:49:46 2761 8192000000 10982479936 11388571648 1980055568 19.465 100 89 178 1 2056742400 49274208 27412624
14:49:56 2366 8192000000 10969098224 11378405376 1969806752 19.384 100 86 168 1 2046869408 49448032 27614624
14:50:05 1094 8192000000 10964857936 11374538752 1972422144 19.405 100 91 182 1 2050138400 49495920 28220336
14:50:13 2999 8192000000 10953525968 11360075776 1957688448 19.288 100 89 176 2 2035478672 50013616 27776608
14:50:23 1747 8192000000 10964648048 11370295296 1964362784 19.341 100 91 182 0 2045224224 52215552 28645888
14:50:31 5638 8192000000 10974523696 11380412416 1973419248 19.413 100 83 166 1 2051218208 50606960 27192000
14:50:45 1930 8192000000 10972342784 11385344000 1977820608 19.447 100 75 147 1 2052600864 50789952 23990304
14:50:56 1574 8192000000 10974949808 11383529472 1973147744 19.410 100 84 168 0 2052353040 52383712 26821584
14:51:04 4053 8192000000 10972857632 11389530112 1977741392 19.447 100 80 161 3 2056035664 53209312 25084960
14:51:16 3920 8192000000 10982277712 11401199616 1984408400 19.500 100 80 159 0 2063064896 53706224 24950272
14:51:28 12315 8192000000 10974494400 11403010048 1985427792 19.508 100 58 116 2 2059034112 54365264 19241056
14:51:47 17046 8192000000 10958586352 11392679936 1962463056 19.326 99 39 78 1 2025750304 49900528 13386720
14:52:12 7182 8192000000 10958747616 11399725056 1980784736 19.471 100 50 100 0 2050718832 52913344 17020752
14:52:26 7911 8192000000 10966555760 11397001216 1963824240 19.336 99 59 117 3 2035214112 52320432 19069440
14:52:43 2895 8192000000 10967174032 11395514368 1975737728 19.431 100 59 118 0 2051524224 55431280 20355216
14:53:04 11013 8192000000 10955565952 11391893504 1958367728 19.293 99 47 94 1 2030956336 56382624 16205984
14:53:23 1572 8192000000 10980759888 11405357056 1983211312 19.490 100 67 132 2 2063070064 58362752 21496000
14:53:34 6444 8192000000 10991249728 11405991936 1980253216 19.467 100 72 142 1 2065425200 62230272 22941712
14:53:48 5148 8192000000 10995314704 11415367680 1983221440 19.490 100 75 150 0 2071448912 63658368 24569104
14:54:01 2589 8192000000 11006640592 11417620480 1987167184 19.521 100 90 182 1 2082248944 65987232 29094528
14:54:09 3820 8192000000 11002258288 11421937664 1986952320 19.520 100 82 162 0 2083615616 69708016 26955280
14:54:21 2019 8192000000 10994625008 11409547264 1970783360 19.392 99 82 164 0 2069089936 71573440 26733136
14:54:30 3212 8192000000 11001261920 11419037696 1977353232 19.444 100 74 148 0 2075742144 73108784 25280128
14:54:46 4425 8192000000 10993366656 11423264768 1973555232 19.414 100 56 113 1 2074500192 81413680 19531280
14:55:07 9646 8192000000 11016508560 11444740096 1985823200 19.511 100 53 104 1 2088795920 84282320 18690400
14:55:29 20691 8192000000 10981738000 11426664448 1987947872 19.528 100 44 87 0 2062725472 59911696 14865904
14:55:57 23920 8192000000 10995959264 11439583232 1988954592 19.536 100 39 77 0 2072353616 69645472 13753552
14:56:39 17259 8192000000 10978689904 11435900928 1982570608 19.485 100 36 72 0 2061154016 65299440 13283968
14:57:03 15164 8192000000 10973155536 11434434560 1981208416 19.474 100 33 66 0 2055716000 62181360 12326224
14:57:55 16949 8192000000 10967640560 11428679680 1967280928 19.364 100 32 65 4 2052062224 72157856 12623440
14:58:27 12589 8192000000 10954919216 11426111488 1966639680 19.359 100 24 48 1 2040150080 64148736 9361664
14:59:01 28361 8192000000 10909013648 11383021568 1947914336 19.210 100 11 22 1 1994220848 42052192 4254320
15:00:10 63116 8192000000 10877296704 11335487488 1903529840 18.855 98 5 10 0 1921280480 16386112 1364528
15:01:20 229983 8192000000 10902614000 11374714880 1855336416 18.465 94 17 34 1 1874043520 14291296 4415808
15:05:17 29265 8192000000 10891558384 11349770240 1936830048 19.121 98 14 28 3 1949941616 9618112 3493456
15:05:52 63000 8192000000 10886525840 11353686016 1942705312 19.168 99 14 27 1 1955408080 8815376 3887392
15:07:27 45461 8192000000 10895206960 11351638016 1918294992 18.973 97 30 59 0 1933369840 6739744 8335104
15:08:27 77671 8192000000 10875349264 11360509952 1926852784 19.042 98 19 38 0 1946892032 14529360 5509888
15:09:59 37945 8192000000 10906953792 11357175808 1936099424 19.116 99 33 67 0 1957944208 11529344 10315440
15:10:44 2768 8192000000 10927865024 11364405248 1971421088 19.397 100 71 142 1 2003539600 11141712 20976800
15:11:01 43363 8192000000 10887385056 11341303808 1924617904 19.024 98 29 58 0 1944304912 10953536 8733472
15:11:53 27445 8192000000 10894600544 11355242496 1958453872 19.294 100 28 56 0 1977233696 10467888 8311936
15:12:37 54662 8192000000 10914807376 11367874560 1950663856 19.232 99 47 93 0 1982299296 18224624 13410816
15:13:41 52338 8192000000 10890338064 11377631232 1940873664 19.154 99 10 21 0 1964037968 20287536 2876768
15:14:40 46140 8192000000 10884759744 11371606016 1959981248 19.306 100 4 8 0 1980744704 19641984 1121472
15:15:34 40878 8192000000 10885349936 11360116736 1969371200 19.380 100 12 24 1 1984185904 11587072 3227632
15:16:21 42071 8192000000 10889643856 11365212160 1964100928 19.339 99 15 30 2 1980666864 12188912 4377024
15:17:10 156530 8192000000 10922845232 11391229952 1929242672 19.061 97 25 49 0 1958278176 21938096 7097408
15:20:18 93620 8192000000 10908632272 11387387904 1914316016 18.941 97 25 50 1 1951576048 28818272 8441760
15:22:08 74139 8192000000 10894951808 11379621888 1949924864 19.226 99 13 26 1 1977662288 24199520 3537904
15:23:29 54583 8192000000 10882039696 11352698880 1894530672 18.782 96 12 24 0 1914532608 16216432 3785504
15:24:41 68608 8192000000 10886985776 11370102784 1942664368 19.168 99 5 9 1 1956926656 13034864 1227424
15:26:03 33475 8192000000 10929344592 11379810304 1953117120 19.251 99 35 68 1 1970435616 7572272 9746224
15:26:47 26949 8192000000 10915581792 11384422400 1978252816 19.451 100 29 56 1 1999395568 13425136 7717616
15:27:58 58514 8192000000 10943094496 11393994752 1966072336 19.354 99 25 50 2 1984578304 11862688 6643280
15:29:03 65896 8192000000 10918809232 11397664768 1948947344 19.218 98 35 70 1 1985120224 26430112 9742768
15:30:52 96830 8192000000 10897877648 11372146688 1890288496 18.748 95 17 34 0 1909661200 15556240 3816464
15:32:41 74859 8192000000 10888092176 11349594112 1887745120 18.728 96 15 30 0 1900368672 8920368 3703184
15:34:02 42438 8192000000 10918545184 11378638848 1971244384 19.395 100 30 60 0 1990491152 10814288 8432480
15:35:41 77435 8192000000 10863399440 11336929280 1823696208 18.208 93 11 22 0 1839783312 12952288 3134816
15:37:06 28444 8192000000 10891851056 11340730368 1910000752 18.907 98 40 80 2 1940538864 19593168 10944944
15:37:40 73932 8192000000 10868248448 11322089472 1828381968 18.246 94 24 48 1 1844757088 10043552 6331568
15:39:01 43272 8192000000 10875489968 11317874688 1887435248 18.725 97 39 77 3 1911397920 12486128 11476544
15:39:58 93729 8192000000 10859603680 11331739648 1919988176 18.987 99 38 76 1 1939094544 7985248 11121120
15:41:37 53286 8192000000 10848115312 11311689728 1894295440 18.780 98 14 28 0 1905037008 7632368 3109200
15:42:38 61698 8192000000 10868678800 11335081984 1929346288 19.062 99 33 66 1 1949865856 11633136 8886432
15:43:47 41825 8192000000 10875823456 11345219584 1923839136 19.018 99 19 38 3 1940739568 9937904 6962528
15:44:40 51369 8192000000 10878515008 11357495296 1945158576 19.188 100 10 20 2 1961041024 12593808 3288640
15:45:57 35470 8192000000 10870721904 11355418624 1931483056 19.079 99 7 14 1 1945985616 12506512 1996048
15:46:47 39519 8192000000 10878071584 11336486912 1915214912 18.948 98 14 27 2 1929576704 9994480 4367312
15:47:33 68391 8192000000 10862491520 11336970240 1909666128 18.904 98 12 24 1 1926125040 12963392 3495520
15:48:48 86938 8192000000 10859585040 11338809344 1925782208 19.033 99 15 30 0 1947148608 16860368 4506032
15:50:23 71149 8192000000 10853007328 11330576384 1905488640 18.870 98 8 16 0 1920065232 12449136 2127456
15:51:41 56902 8192000000 10874486240 11345727488 1914339920 18.941 98 22 45 1 1933242256 12890912 6011424
15:52:46 121713 8192000000 10864429472 11327791104 1809194704 18.089 93 15 30 0 1822334096 9679824 3459568
15:54:56 61426 8192000000 10869971232 11344379904 1928689568 19.056 99 31 62 1 1947602704 10039872 8873264
15:56:04 114354 8192000000 10892503904 11368660992 1901729520 18.840 97 15 30 0 1928730880 21823808 5177552
15:58:21 79126 8192000000 10892205440 11357683712 1938984208 19.139 99 18 36 1 1957353584 13147040 5222336
15:59:52 71836 8192000000 10874956352 11352391680 1876744016 18.639 96 20 40 0 1893455904 11268784 5443104
16:01:28 61339 8192000000 10896698896 11377057792 1960748288 19.312 100 23 46 0 1980434592 13480240 6206064
16:02:39 105085 8192000000 10874154544 11346948096 1913390320 18.934 97 32 64 1 1936121520 14087328 8643872
16:04:42 69545 8192000000 10904087168 11369566208 1963230576 19.332 99 29 57 3 1977699920 6868752 7600592
16:06:44 50026 8192000000 10882146368 11374174208 1957522016 19.286 99 7 14 0 1970957120 12072880 1362224
16:07:41 31738 8192000000 10878720496 11361746944 1947334992 19.205 99 8 16 1 1956429680 7040368 2054320
16:08:19 38706 8192000000 10868835168 11345063936 1928349536 19.054 98 12 24 0 1939815712 8179504 3286672
16:09:06 72077 8192000000 10873446880 11360710656 1893623280 18.775 96 10 21 0 1903429536 7487600 2318656
16:10:31 47253 8192000000 10890377184 11353014272 1894152224 18.779 96 28 54 2 1909086752 7646688 7287840
16:11:28 40369 8192000000 10907644720 11364044800 1947474048 19.206 99 50 100 2 1972121104 10324848 14322208
16:12:17 54999 8192000000 10898254016 11356999680 1902671600 18.848 97 13 26 0 1913984864 7754288 3558976
16:13:31 41450 8192000000 10891277232 11372478464 1952558080 19.247 99 31 62 3 1970949024 9739296 8651648
16:14:38 82532 8192000000 10911429984 11391606784 1952124432 19.243 99 23 46 1 1973116480 14540480 6451568
16:16:08 87690 8192000000 10905322960 11377152000 1918641792 18.976 97 8 16 1 1938627056 17991008 1994256
16:17:41 75441 8192000000 10895016768 11362385920 1888447040 18.733 95 18 36 1 1902465280 8480016 5538224
16:19:10 54041 8192000000 10880822144 11350261760 1877652128 18.646 96 20 41 1 1893322272 10229296 5440848
16:20:13 63730 8192000000 10875508032 11358408704 1899849824 18.825 97 23 46 2 1925897600 19370048 6677728
16:21:40 124453 8192000000 10854973616 11338113024 1864446448 18.539 95 27 53 0 1883119120 10494832 8177840
16:23:51 55562 8192000000 10896983856 11371831296 1959947472 19.306 100 27 54 0 1980535168 12648944 7938752
16:26:10 57923 8192000000 10860329824 11338633216 1888464160 18.733 96 10 20 0 1903345536 11713584 3167792
16:27:15 57835 8192000000 10860000048 11351011328 1923459488 19.015 99 10 20 0 1940461744 13887328 3114928
16:28:19 53918 8192000000 10845884432 11321409536 1831401488 18.271 94 21 42 1 1847245392 9427104 6416800
16:29:19 49921 8192000000 10817738432 11299184640 1823193296 18.204 95 20 40 0 1841884512 12620272 6070944
16:30:15 38566 8192000000 10851536944 11319689216 1887112048 18.722 98 21 42 2 1904781952 11457264 6212640
16:31:00 23481 8192000000 9514015920 9831763968 651183600 7.363 34 7 14 0 658677952 5998352 1496000

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 18-02-2021 16:32:47 to 18-02-2021 16:33:19.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 18-02-2021 16:33:20 to 18-02-2021 16:33:22.

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          247853
MON$OLDEST_ACTIVE               247854
MON$OLDEST_SNAPSHOT             247854
MON$NEXT_TRANSACTION            247854
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                       2049312
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.33418 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33418 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33418 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33418 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
--- end of diff output ---

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

18.02.21 16:33:23. 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-02-18 16:33:26 No severe PSQL-related problems occured
18.02.21 16:33:27. End of report.