Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 11.12.2020 22: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 1920.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 17589676 kB
MemAvailable 31523448 kB
Buffers 0 kB
Cached 14074532 kB
SwapCached 3708 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-11 22:27:04
DTS_END                         2020-12-11 22:27:04.8470
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/32960
TRN_ID                          247539
ATT_ID                          623
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: 9274.02 17500 1112882
customer order: creation 177.47 315 21296
customer order: refuse 15.29 340 1835
order to supplier: creation 47.06 1130 5647
order to supplier: removal 3.46 76219 415
invoice (draft): creation 46.82 2721 5618
invoice (draft): removal 52.37 629 6284
invoice accept: apply 42.07 16099 5048
invoice accept: cancel 46.99 688 5639
customer reserve: creation 3893.98 160 467277
customer reserve: removal 4650.90 45 558108
realization accept: apply 86.87 165 10424
realization accept: cancel 79.63 98 9556
payment from customer: creation 60.73 118 7287
payment from customer: removal 6.13 74 736
payment to supplier: creation 48.71 121 5845
payment to supplier: removal 3.29 45 395
service: total inventory turnovers 4.87 983 584
service: total monetary turnovers 6.43 44 771
service: aggregate perf. data 0.94 16556 113
service: refresh index statistics 0.03 233453 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 11-12-2020 22:28:05 to 11-12-2020 22:28:07.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6021
TEST_TIME 2 5333
TEST_TIME 3 5861
TEST_TIME 4 5800
TEST_TIME 5 5594
TEST_TIME 6 5568
TEST_TIME 7 5633
TEST_TIME 8 6101
TEST_TIME 9 6510
TEST_TIME 10 6614
TEST_TIME 11 7058
TEST_TIME 12 7841
TEST_TIME 13 9513
TEST_TIME 14 9692
TEST_TIME 15 9702
TEST_TIME 16 10111
TEST_TIME 17 9922
TEST_TIME 18 9905
TEST_TIME 19 10142
TEST_TIME 20 10387
TEST_TIME 21 11037
TEST_TIME 22 11072
TEST_TIME 23 11449
TEST_TIME 24 11189
TEST_TIME 25 11006
TEST_TIME 26 11098
TEST_TIME 27 10797
TEST_TIME 28 10615
TEST_TIME 29 10354
TEST_TIME 30 10116
TEST_TIME 31 10036
TEST_TIME 32 10115
TEST_TIME 33 10035
TEST_TIME 34 9939
TEST_TIME 35 9934
TEST_TIME 36 9954
TEST_TIME 37 9910
TEST_TIME 38 9985
TEST_TIME 39 9883
TEST_TIME 40 9911
TEST_TIME 41 9749
TEST_TIME 42 9762
TEST_TIME 43 10008
TEST_TIME 44 10049
TEST_TIME 45 10061
TEST_TIME 46 10035
TEST_TIME 47 9974
TEST_TIME 48 9974
TEST_TIME 49 9940
TEST_TIME 50 9936
TEST_TIME 51 9925
TEST_TIME 52 9793
TEST_TIME 53 9724
TEST_TIME 54 9658
TEST_TIME 55 9597
TEST_TIME 56 9652
TEST_TIME 57 9599
TEST_TIME 58 9507
TEST_TIME 59 9460
TEST_TIME 60 9399
TEST_TIME 61 9396
TEST_TIME 62 9336
TEST_TIME 63 9458
TEST_TIME 64 9460
TEST_TIME 65 9413
TEST_TIME 66 9483
TEST_TIME 67 9474
TEST_TIME 68 9467
TEST_TIME 69 9500
TEST_TIME 70 9502
TEST_TIME 71 9493
TEST_TIME 72 9489
TEST_TIME 73 9647
TEST_TIME 74 9738
TEST_TIME 75 9682
TEST_TIME 76 9767
TEST_TIME 77 9783
TEST_TIME 78 9667
TEST_TIME 79 9627
TEST_TIME 80 9571
TEST_TIME 81 9572
TEST_TIME 82 9555
TEST_TIME 83 9527
TEST_TIME 84 9511
TEST_TIME 85 9492
TEST_TIME 86 9442
TEST_TIME 87 9393
TEST_TIME 88 9381
TEST_TIME 89 9349
TEST_TIME 90 9380
TEST_TIME 91 9347
TEST_TIME 92 9385
TEST_TIME 93 9414
TEST_TIME 94 9466
TEST_TIME 95 9447
TEST_TIME 96 9495
TEST_TIME 97 9465
TEST_TIME 98 9523
TEST_TIME 99 9485
TEST_TIME 100 9521
TEST_TIME 101 9524
TEST_TIME 102 9613
TEST_TIME 103 9643
TEST_TIME 104 9586
TEST_TIME 105 9512
TEST_TIME 106 9457
TEST_TIME 107 9451
TEST_TIME 108 9416
TEST_TIME 109 9355
TEST_TIME 110 9343
TEST_TIME 111 9368
TEST_TIME 112 9345
TEST_TIME 113 9305
TEST_TIME 114 9332
TEST_TIME 115 9304
TEST_TIME 116 9265
TEST_TIME 117 9250
TEST_TIME 118 9255
TEST_TIME 119 9351
TEST_TIME 120 9277

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 11-12-2020 22:28:09 to 11-12-2020 22:28:12.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1545792 1545792 0 0.00 0 19813 6 0 0
doc_list_biud 1545792 1545792 0 0.00 0 66434 21 0 0
sp_add_invoice_to_stock 5196 5048 148 2.84 32 186221 16099 0 148
sp_cancel_adding_invoice 5639 5639 0 0.00 5 56724 689 0 0
sp_cancel_client_order 1835 1835 0 0.00 3 16119 341 0 0
sp_cancel_customer_reserve 558108 558108 0 0.00 1 41159 45 0 0
sp_cancel_pay_from_customer 736 736 0 0.00 3 5624 75 0 0
sp_cancel_pay_to_supplier 395 395 0 0.00 3 746 45 0 0
sp_cancel_supplier_invoice 6296 6284 12 0.19 1 66446 630 0 12
sp_cancel_supplier_order 415 415 0 0.00 12 777767 76220 0 0
sp_cancel_write_off 9556 9556 0 0.00 1 15005 99 0 0
sp_client_order 21296 21296 0 0.00 3 42299 316 0 0
sp_customer_reserve 467277 467277 0 0.00 0 25029 160 0 0
sp_fill_shopping_cart 32560 32560 0 0.00 1 10206 37 0 0
sp_fill_shopping_cart_clo_res 467268 467268 0 0.00 0 13650 12 0 0
sp_get_clo_for_invoice 5039 5039 0 0.00 0 19308 301 0 0
sp_kill_cost_storno 16326 16326 0 0.00 0 12460 47 0 0
sp_kill_qstorno_ret_qs2qd 1132471 1132471 0 0.00 0 66427 25 0 0
sp_kill_qty_storno 597299 597299 0 0.00 0 66431 54 0 0
sp_lock_selected_doc 21441 21441 0 0.00 0 7514 6 0 0
sp_make_cost_storno 28594 28594 0 0.00 0 19474 46 0 0
sp_multiply_rows_for_pdistr 28594 28594 0 0.00 0 13009 24 0 0
sp_multiply_rows_for_qdistr 21296 21296 0 0.00 0 40406 148 0 0
sp_pay_from_customer 7287 7287 0 0.00 4 17907 118 0 0
sp_pay_to_supplier 5845 5845 0 0.00 5 19823 122 0 0
sp_payment_common 13132 13132 0 0.00 1 17901 36 0 0
sp_qd_handle_on_cancel_clo 1835 1835 0 0.00 0 16112 309 0 0
sp_qd_handle_on_invoice_upd_sts 10677 10677 0 0.00 0 22689 274 0 0
sp_qd_handle_on_reserve_upd_sts 10424 10424 0 0.00 0 17911 59 0 0
sp_reserve_write_off 10424 10424 0 0.00 6 17986 165 0 0
sp_supplier_invoice 5618 5618 0 0.00 6 73604 2722 0 0
sp_supplier_order 5647 5647 0 0.00 4 33566 1131 0 0
srv_aggregate_perf_data 114 113 1 0.87 2686 163321 16556 0 1
srv_fill_mon_cache_memory 141 141 0 0.00 1336 162634 39836 0 0
srv_find_qd_qs_mism 1064419 1064419 0 0.00 0 12386 5 0 0
srv_make_invnt_saldo 584 584 0 0.00 37 71435 984 0 0
srv_make_money_saldo 771 771 0 0.00 0 20894 45 0 0
srv_recalc_idx_stat 4 4 0 0.00 151270 335751 233453 0 0
t$perf-abend:sp_add_invoice_to_stock 148 148 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 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 5050 5050 0 0.00 0 14598 159 0 0
t$perf-norm:sp_cancel_adding_invoice 438 438 0 0.00 0 11697 139 0 0
t$perf-norm:sp_cancel_client_order 1835 1835 0 0.00 0 3180 10 0 0
t$perf-norm:sp_cancel_customer_reserve 688 688 0 0.00 0 806 6 0 0
t$perf-norm:sp_cancel_pay_from_customer 736 736 0 0.00 0 1721 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 395 395 0 0.00 0 2295 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 440 440 0 0.00 0 2430 13 0 0
t$perf-norm:sp_cancel_supplier_order 415 415 0 0.00 0 31729 1622 0 0
t$perf-norm:sp_cancel_write_off 1032 1032 0 0.00 0 479 4 0 0
t$perf-norm:sp_client_order 21296 21296 0 0.00 0 10964 16 0 0
t$perf-norm:sp_customer_reserve 1078 1078 0 0.00 0 2337 7 0 0
t$perf-norm:sp_pay_from_customer 7287 7287 0 0.00 0 16125 13 0 0
t$perf-norm:sp_pay_to_supplier 5845 5845 0 0.00 0 5521 11 0 0
t$perf-norm:sp_reserve_write_off 10424 10424 0 0.00 0 10559 15 0 0
t$perf-norm:sp_supplier_invoice 5618 5618 0 0.00 0 7591 14 0 0
t$perf-norm:sp_supplier_order 5647 5647 0 0.00 0 12967 15 0 0
t$perf-norm:srv_aggregate_perf_data 113 113 0 0.00 0 312 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 141 141 0 0.00 0 532 6 0 0
t$perf-norm:srv_make_invnt_saldo 584 584 0 0.00 0 1717 18 0 0
t$perf-norm:srv_make_money_saldo 771 771 0 0.00 0 6936 26 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 10372 10076 296 2.85 0 12619 22 0 296
v_all_customers 38346 38346 0 0.00 0 11 0 0 0
v_all_suppliers 30896 30896 0 0.00 0 12 1 0 0
v_all_wares 42592 42592 0 0.00 0 44 1 0 0
v_cancel_adding_invoice 876 876 0 0.00 0 3999 12 0 0
v_cancel_client_order 3670 3670 0 0.00 0 4132 5 0 0
v_cancel_customer_prepayment 1472 1472 0 0.00 0 3373 9 0 0
v_cancel_customer_reserve 1376 1376 0 0.00 0 5152 10 0 0
v_cancel_payment_to_supplier 790 790 0 0.00 0 707 4 0 0
v_cancel_supplier_invoice 904 880 24 2.65 0 1525 14 0 24
v_cancel_supplier_order 830 830 0 0.00 0 779 3 0 0
v_cancel_write_off 2064 2064 0 0.00 0 5593 15 0 0
v_max_id_clo_ord 5647 5647 0 0.00 0 427 1 0 0
v_max_id_clo_res 1078 1078 0 0.00 0 3035 15 0 0
v_max_id_ord_sup 5617 5617 0 0.00 0 3495 5 0 0
v_max_non_paid_invoice 1661 1661 0 0.00 0 493 3 0 0
v_max_non_paid_realizn 4068 4068 0 0.00 0 6681 6 0 0
v_min_id_clo_ord 5647 5647 0 0.00 0 6898 7 0 0
v_min_id_clo_res 1078 1078 0 0.00 0 7459 20 0 0
v_min_id_ord_sup 5617 5617 0 0.00 0 4369 7 0 0
v_min_non_paid_invoice 5845 5845 0 0.00 0 6660 22 0 0
v_min_non_paid_realizn 7287 7287 0 0.00 0 17897 27 0 0
v_our_firm 10684 10684 0 0.00 0 12 1 0 0
v_reserve_write_off 20848 20848 0 0.00 0 5793 7 0 0
x_lock_depdocs_on_canc_invoice 11483 11483 0 0.00 0 12305 95 0 0
x_lock_depdocs_on_canc_sup_ord 415 415 0 0.00 0 4235 243 0 0
x_make_qstorno_1000_1200 5647 5647 0 0.00 2 33555 1064 0 0
x_make_qstorno_1200_2000 5618 5618 0 0.00 2 73595 2583 0 0
x_make_qstorno_2100_3300 467277 467277 0 0.00 0 25011 147 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 11-12-2020 22:28:13 to 11-12-2020 22:28:17.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:08 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:14 17442 8192000000 10227607472 10531446784 1131216464 12.133 89 73 146 1 1159698288 3391072 25090752
19:57:40 21233 8192000000 10341929488 10654851072 1363583616 14.270 100 84 168 0 1395750752 4557696 27609440
19:58:12 27570 8192000000 10373140992 10696986624 1427094000 14.836 100 84 169 0 1460434528 5906608 27433920
19:58:49 17459 8192000000 10408200224 10734600192 1464131488 15.162 100 90 180 0 1500076912 6874400 29071024
19:59:17 17189 8192000000 10429343584 10757832704 1482290960 15.321 100 90 179 2 1518293056 7577536 28424560
19:59:46 20685 8192000000 10443143456 10778918912 1496537040 15.446 100 87 174 0 1532652272 8292832 27822400
20:00:19 14320 8192000000 10462715872 10796998656 1517502384 15.629 100 84 168 0 1552601488 8686416 26412688
20:00:50 17635 8192000000 10479655440 10822529024 1536784896 15.796 100 87 174 0 1573663424 9409008 27469520
20:01:17 20740 8192000000 10509627520 10853810176 1559502576 15.992 100 84 168 0 1595141776 9738016 25901184
20:01:49 15230 8192000000 10530173904 10886770688 1582119856 16.186 100 73 144 1 1613322144 9609456 21592832
20:02:12 15386 8192000000 10563319552 10924519424 1624942784 16.552 100 81 162 2 1659562976 10840000 23780192
20:02:34 8660 8192000000 10589714656 10950066176 1646698032 16.736 100 78 155 1 1680449696 11221280 22530384
20:02:53 11446 8192000000 10601615040 10967912448 1663407952 16.878 100 78 156 0 1698600272 11773808 23418512
20:03:16 8000 8192000000 10623760544 10992177152 1683590048 17.047 100 82 163 2 1719424816 12285984 23548784
20:03:31 8531 8192000000 10643825072 11013189632 1702709424 17.208 100 84 166 4 1739227520 12022496 24495600
20:03:48 5114 8192000000 10659021664 11030962176 1719126864 17.345 100 78 156 1 1752454960 11644016 21684080
20:04:01 6046 8192000000 10686601536 11057065984 1739710016 17.516 100 83 166 1 1775056800 11599312 23747472
20:04:15 5519 8192000000 10682940288 11060453376 1745076944 17.561 100 74 148 1 1777728144 11991600 20659600
20:04:29 3215 8192000000 10704450368 11079864320 1760787984 17.691 100 81 161 1 1795301536 12297168 22216384
20:04:39 4457 8192000000 10702342848 11080585216 1765093136 17.726 100 79 158 1 1800242768 13459392 21690240
20:04:51 4741 8192000000 10716234432 11095474176 1774781584 17.806 100 85 171 0 1812341344 13782016 23777744
20:05:03 3275 8192000000 10721355360 11101999104 1784206784 17.884 100 88 175 0 1821973840 13514080 24252976
20:05:13 3036 8192000000 10728449040 11105497088 1789642016 17.929 100 84 170 0 1826370240 13087168 23641056
20:05:23 2524 8192000000 10728967328 11111903232 1790645168 17.937 100 92 178 3 1828956752 13377392 24934192
20:05:32 1602 8192000000 10733867248 11116490752 1798326480 18.000 100 90 180 2 1836567584 13688400 24552704
20:05:40 3150 8192000000 10747022192 11125993472 1806124864 18.064 100 90 177 0 1844220960 13092336 25003760
20:05:50 4039 8192000000 10742450000 11125903360 1807456144 18.075 100 84 169 0 1842839536 13164464 22218928
20:06:01 2950 8192000000 10754481936 11140685824 1812665376 18.118 100 88 172 2 1850451280 13806176 23979728
20:06:10 2434 8192000000 10766127024 11152379904 1826430784 18.230 100 87 170 2 1865063424 14800656 23831984
20:06:19 1946 8192000000 10771585808 11155742720 1830394448 18.263 100 95 189 2 1870526928 13762720 26369760
20:06:27 1616 8192000000 10778149856 11162140672 1835490000 18.304 100 96 192 2 1877118160 14217472 27410688
20:06:35 1555 8192000000 10778858272 11167977472 1838685568 18.330 100 88 169 3 1876289360 13477808 24125984
20:06:43 1667 8192000000 10787772944 11176603648 1849108112 18.415 100 85 170 1 1885886800 13330816 23447872
20:06:51 1409 8192000000 10797331440 11184480256 1856757680 18.477 100 96 190 2 1899245552 14683104 27804768
20:06:59 1361 8192000000 10797959968 11184533504 1860080960 18.504 100 91 185 1 1898246384 12209232 25956192
20:07:06 15811 8192000000 10797721408 11193171968 1856700592 18.477 100 68 137 1 1887928432 12904112 18323728
20:07:28 8626 8192000000 10762304880 11183710208 1854310480 18.457 100 50 98 0 1878118544 10449824 13358240
20:07:43 4334 8192000000 10768460480 11189256192 1857478128 18.483 100 29 58 0 1873041760 7079248 8484384
20:07:55 3265 8192000000 10790716880 11195580416 1866039472 18.552 100 67 135 2 1893815184 8181280 19594432
20:08:05 3665 8192000000 10783500896 11198361600 1864265136 18.538 100 43 86 3 1885626688 8973440 12388112
20:08:15 7874 8192000000 10765061248 11194802176 1862818560 18.526 100 22 44 1 1875832800 6841488 6172752
20:08:29 8131 8192000000 10780112592 11200790528 1865141376 18.545 100 24 48 1 1878839696 7045120 6653200
20:08:47 5082 8192000000 10782729136 11201675264 1868974640 18.576 100 21 43 1 1881469840 6450224 6044976
20:09:00 5729 8192000000 10776172464 11204538368 1871500832 18.596 100 32 65 1 1888401792 7485408 9415552
20:09:12 8486 8192000000 10780648256 11210801152 1873640240 18.614 100 22 44 1 1886121776 6381936 6099600
20:09:30 11297 8192000000 10781288768 11211685888 1874703168 18.622 100 16 32 0 1885106080 6081280 4321632
20:09:50 14601 8192000000 10779407120 11216551936 1881167632 18.675 100 17 34 0 1891339056 5803904 4367520
20:10:14 54880 8192000000 10804111120 11234168832 1891497008 18.758 100 19 38 1 1902325328 5381504 5446816
20:11:25 31517 8192000000 10818853072 11251650560 1894866240 18.785 100 30 60 3 1917337376 14248688 8222448
20:12:03 7338 8192000000 10825686160 11249065984 1896874304 18.801 100 25 49 1 1909707088 5835360 6997424
20:12:19 5622 8192000000 10830186288 11256127488 1903429488 18.854 100 22 45 0 1915895296 6271488 6194320
20:12:31 7253 8192000000 10823258128 11252916224 1906045824 18.875 100 23 47 1 1917809728 5186512 6577392
20:12:48 6039 8192000000 10832193616 11259002880 1909291392 18.901 100 30 60 1 1924638128 6201472 9145264
20:13:03 12567 8192000000 10832780512 11264774144 1911634384 18.920 100 35 71 2 1927840752 5727632 10478736
20:13:22 7897 8192000000 10826430736 11261587456 1908975984 18.898 100 21 42 2 1921094960 6333328 5785648
20:13:36 7093 8192000000 10822554880 11260821504 1914681200 18.944 100 25 49 1 1927294656 4974128 7639328
20:13:51 7012 8192000000 10846449152 11269943296 1914838928 18.945 100 29 58 3 1929482144 6543600 8099616
20:14:05 10105 8192000000 10822004416 11257180160 1906422352 18.878 100 15 28 1 1915531392 5124672 3984368
20:14:25 6791 8192000000 10815927168 11244642304 1867935424 18.568 98 21 42 1 1881111936 6578272 6598240
20:14:39 6740 8192000000 10814287904 11250262016 1900772208 18.833 100 25 50 1 1914333968 6547424 7014336
20:14:58 7150 8192000000 10823275024 11250167808 1906365968 18.877 100 20 40 3 1916631936 5270592 4995376
20:15:13 58064 8192000000 10831203968 11263766528 1912727488 18.929 100 39 78 1 1930675792 6730048 11218256
20:16:21 9963 8192000000 10805414976 11239632896 1869589456 18.581 98 26 52 5 1882063536 5663088 6810992
20:16:38 4980 8192000000 10785795776 11214716928 1858464048 18.491 99 33 66 1 1874837088 7222384 9150656
20:16:50 7980 8192000000 10761696192 11184201728 1771539024 17.780 94 22 43 1 1782878768 5160720 6179024
20:17:06 5647 8192000000 10763405472 11190403072 1845777296 18.388 100 28 56 4 1860918272 6852112 8288864
20:17:18 7449 8192000000 10766614384 11195654144 1852417664 18.442 100 29 57 2 1867518064 6436560 8663840
20:17:32 6752 8192000000 10770075584 11180732416 1834749552 18.298 99 29 57 4 1849128640 5259632 9119456
20:17:45 11623 8192000000 10739790864 11165405184 1743471984 17.547 94 22 44 0 1755977920 6587856 5918080
20:18:03 8768 8192000000 10712693392 11123773440 1651136448 16.774 90 33 65 2 1671004000 9951440 9916112
20:18:19 5446 8192000000 10726705360 11129167872 1760712464 17.690 98 39 78 2 1776722592 4947568 11062560
20:18:33 5705 8192000000 10702927584 11110838272 1729777328 17.434 97 22 44 1 1746273824 10274864 6221632
20:18:45 11733 8192000000 10695274016 11110891520 1734101408 17.470 97 16 32 1 1744808032 5591216 5115408
20:19:04 8197 8192000000 10702419248 11114786816 1733590352 17.465 96 36 71 0 1754425024 9335248 11499424
20:19:18 17283 8192000000 10684124000 11083964416 1717404592 17.331 96 20 40 2 1727759040 5109632 5244816
20:19:48 64771 8192000000 10707423392 11120955392 1712181712 17.287 95 36 74 0 1727844592 4387984 11274896
20:21:15 13726 8192000000 10729301136 11143024640 1796131280 17.982 99 39 80 1 1813609664 6223184 11255200
20:21:35 8860 8192000000 10729402272 11149123584 1799313120 18.008 99 28 56 1 1814524896 6059552 9152224
20:21:50 7916 8192000000 10740205600 11155234816 1824324848 18.213 100 39 79 0 1842385824 7149552 10911424
20:22:05 9164 8192000000 10755283904 11171028992 1827691104 18.240 100 31 62 1 1846308560 9581680 9035776
20:22:20 11732 8192000000 10757534864 11170877440 1834848448 18.299 100 26 52 1 1848066672 5323664 7894560
20:22:38 5363 8192000000 10752217984 11179757568 1842280128 18.359 100 24 48 0 1855807632 6835552 6691952
20:22:51 7625 8192000000 10756346464 11185283072 1846524576 18.394 100 33 66 2 1863111376 6612720 9974080
20:23:07 4706 8192000000 10769356400 11188965376 1850299792 18.425 100 37 74 4 1865368512 4726512 10342208
20:23:17 6610 8192000000 10756176880 11186106368 1847671072 18.403 100 24 49 0 1859951200 5564640 6715488
20:23:30 10988 8192000000 10764874448 11191300096 1849428496 18.417 100 25 50 2 1861441760 4417248 7596016
20:23:47 12192 8192000000 10776162048 11198533632 1850491744 18.426 100 14 28 0 1859983904 5032032 4460128
20:24:06 12266 8192000000 10770139424 11201175552 1850550704 18.427 100 16 32 1 1864997216 9896208 4550304
20:24:25 13553 8192000000 10762034528 11197378560 1854471552 18.458 100 14 27 1 1863811824 5933712 3406560
20:24:47 22868 8192000000 10787642544 11209916416 1865494112 18.548 100 29 58 1 1879693008 6382048 7816848
20:25:16 63251 8192000000 10774046960 11212677120 1866543840 18.556 100 20 40 0 1877621680 5065664 6012176
20:26:26 9860 8192000000 10779245312 11211968512 1871066784 18.593 100 25 48 0 1884105648 6336784 6702080
20:26:43 9061 8192000000 10801035760 11224084480 1878195520 18.651 100 38 76 4 1896079360 6985392 10898448
20:26:58 29156 8192000000 10821374064 11238830080 1882438752 18.685 100 25 49 2 1898749136 9821584 6488800
20:27:40 25797 8192000000 10839434048 11261976576 1910008992 18.907 100 51 100 2 1932259952 8255152 13995808
20:28:14 13865 8192000000 10851269664 11275055104 1922543760 19.007 100 52 104 0 1947995168 9723392 15728016
20:28:35 19250 8192000000 10853162880 11282030592 1924358496 19.022 100 37 74 0 1945769744 11186896 10224352
20:29:04 39899 8192000000 10872914016 11302543360 1938213936 19.133 100 34 68 0 1960202896 12573552 9415408
20:29:51 19382 8192000000 10891103136 11316121600 1950661952 19.232 100 39 78 0 1975206528 13716896 10827680
20:30:21 6166 8192000000 10891439984 11320320000 1959070032 19.299 100 48 93 4 1989046848 16154640 13822176
20:30:35 5542 8192000000 10899707920 11328090112 1962695072 19.327 100 52 103 1 1993859968 16233664 14931232
20:30:56 2943 8192000000 10908190224 11336347648 1971039424 19.394 100 57 113 1 2003754032 16003072 16711536
20:31:07 7353 8192000000 10909199680 11339726848 1973466096 19.413 100 54 108 0 2005421632 16587872 15367664
20:31:23 23934 8192000000 10892345392 11326947328 1949591120 19.223 99 51 102 3 1983076592 18409664 15075808
20:32:30 44094 8192000000 10900799632 11345690624 1973442512 19.413 100 39 78 1 2008169216 23361936 11364768
20:33:22 4926 8192000000 10904922112 11346984960 1970051424 19.386 100 31 62 1 1996505488 17344032 9110032
20:33:35 16523 8192000000 10917786432 11355762688 1978102560 19.450 100 39 78 5 2011966768 22056464 11807744
20:33:59 18660 8192000000 10915704608 11345264640 1959576320 19.303 99 40 80 3 1990987840 19180912 12230608
20:34:24 5244 8192000000 10920115408 11357605888 1980558112 19.469 100 50 100 0 2017982720 21773616 15650992
20:34:36 8609 8192000000 10938401168 11365728256 1983283856 19.491 100 47 95 1 2015388688 18145120 13959712
20:34:52 4622 8192000000 10943183152 11367424000 1990544384 19.548 100 58 116 0 2027318480 20163680 16610416
20:35:06 2803 8192000000 10917282336 11339132928 1961232656 19.316 99 73 146 0 2007114176 24323200 21558320
20:35:17 16090 8192000000 10932293008 11354071040 1959167568 19.299 99 75 151 0 2007736528 26499552 22069408
20:35:45 3659 8192000000 10930960208 11354394624 1971004096 19.393 100 63 125 1 2017288704 27498688 18785920
20:36:00 11488 8192000000 10942916528 11369119744 1985227680 19.506 100 54 109 1 2028150048 26243664 16678704
20:36:19 7680 8192000000 10945014528 11370684416 1984753136 19.502 100 61 121 4 2032245568 29073728 18418704
20:36:34 5687 8192000000 10917348416 11341496320 1927747792 19.049 97 59 118 2 1973209008 27699344 17761872
20:36:47 2645 8192000000 10922509264 11345915904 1952244160 19.244 99 64 124 1 2000404208 28151536 20008512
20:36:56 3829 8192000000 10922037040 11346132992 1949422912 19.222 99 62 124 0 1997363056 28582368 19357776
20:37:07 3695 8192000000 10938508208 11361587200 1971115152 19.394 100 66 130 1 2020644320 29909296 19619872
20:37:18 6446 8192000000 10938687152 11361169408 1970540624 19.390 100 72 144 1 2023181232 30677248 21963360
20:37:32 2052 8192000000 10957846912 11370373120 1977768640 19.447 100 85 171 1 2036656064 32811904 26075520
20:37:41 3210 8192000000 10944564464 11365634048 1959867968 19.305 99 78 156 1 2019004000 34701984 24434048
20:37:52 7143 8192000000 10921893472 11343982592 1938253552 19.133 99 62 124 0 1993118896 35538976 19326368
20:38:08 4650 8192000000 10936934960 11358052352 1963342720 19.333 100 81 162 1 2027486688 39749040 24394928
20:38:22 1510 8192000000 10950703968 11356598272 1962008832 19.322 100 88 175 1 2023666192 34711616 26945744
20:38:31 2149 8192000000 10943365792 11357409280 1962956176 19.330 100 75 146 2 2021328144 36178880 22193088
20:38:42 2955 8192000000 10943162032 11356446720 1945759216 19.193 99 79 157 5 2008721264 38294816 24667232
20:38:53 1334 8192000000 10941173040 11351502848 1952007680 19.242 99 86 169 3 2017970560 39345856 26617024
20:39:01 4488 8192000000 10946933872 11370795008 1968914016 19.377 100 78 156 1 2034337488 40152368 25271104
20:39:12 5511 8192000000 10955284512 11369951232 1965260992 19.348 100 83 166 2 2035002384 43319136 26422256
20:39:24 3690 8192000000 10925783600 11346640896 1951171664 19.236 100 71 143 3 2013679648 39533360 22974624
20:39:37 10503 8192000000 10925701280 11346460672 1936788272 19.121 99 55 108 0 1994025296 39416432 17820592
20:39:55 6216 8192000000 10942167856 11366580224 1962310496 19.324 100 73 145 0 2026197520 40429440 23457584
20:40:12 2819 8192000000 10935369264 11354738688 1948695888 19.216 99 76 152 2 2012804016 39755040 24353088
20:40:25 1691 8192000000 10956158832 11370594304 1976348560 19.436 100 83 167 1 2033452976 32162928 24941488
20:40:33 1644 8192000000 10936666288 11358281728 1966068736 19.354 100 75 150 0 2020374032 31013536 23291760
20:40:42 13269 8192000000 10917191984 11363340288 1965136144 19.347 100 34 68 0 2002833472 26403168 11294160
20:41:03 15582 8192000000 10911775360 11357675520 1951488400 19.238 99 30 59 1 1987273760 26049168 9736192
20:41:25 10385 8192000000 10924339824 11358449664 1948209680 19.212 99 46 91 3 1986378560 24352432 13816448
20:41:44 20882 8192000000 10903274960 11341402112 1946331824 19.197 100 36 69 2 1981353056 23829280 11191952
20:42:11 9195 8192000000 10864495328 11309326336 1891225696 18.756 98 30 60 1 1923318176 22617152 9475328
20:42:29 10864 8192000000 10879537936 11318722560 1917295904 18.965 99 47 94 1 1958054880 26094064 14664912
20:42:51 5732 8192000000 10893403056 11326754816 1931967248 19.083 100 50 100 1 1976334864 29174960 15192656
20:43:05 10819 8192000000 10895946496 11337699328 1943684240 19.176 100 34 68 2 1982527632 29054032 9789360
20:43:28 15230 8192000000 10886460080 11332141056 1934030000 19.099 100 34 68 2 1977106400 32249712 10826688
20:43:54 21376 8192000000 10882166304 11331010560 1918158864 18.972 99 26 53 0 1956289584 30153568 7977152
20:44:26 18810 8192000000 10878330880 11317329920 1908149424 18.892 99 18 36 0 1944282640 29146576 6986640
20:44:52 10796 8192000000 10856417584 11301527552 1881043568 18.674 98 22 44 3 1919775856 31836976 6895312
20:45:23 24651 8192000000 10832606752 11266826240 1858594368 18.492 97 24 48 1 1894382256 27839792 7948096
20:45:55 11294 8192000000 10838118464 11277115392 1886806576 18.720 100 25 50 0 1927078272 31802080 8469616
20:46:16 27512 8192000000 10849248864 11285872640 1866453808 18.556 98 23 46 1 1904943824 30315600 8174416
20:46:57 25450 8192000000 10847065056 11298721792 1887782320 18.728 99 19 38 0 1923399568 28555952 7061296
20:47:47 41868 8192000000 10868843824 11323330560 1890977440 18.754 98 19 38 0 1925298384 28029728 6291216
20:49:10 33968 8192000000 10849658352 11307585536 1899622160 18.823 99 17 34 1 1927907728 21913648 6371920
20:50:11 16406 8192000000 10857690288 11290865664 1894564496 18.783 99 34 68 1 1928629056 23098256 10966304
20:50:42 42526 8192000000 10832018720 11268923392 1881056144 18.674 99 37 74 1 1903600304 11266832 11277328
20:51:59 30998 8192000000 10845442544 11278508032 1905042752 18.867 100 50 97 2 1930359472 11209936 14106784
20:52:40 55875 8192000000 10824543936 11286970368 1877399664 18.644 98 38 76 1 1902253312 14134688 10718960
20:53:44 38354 8192000000 10836667232 11300155392 1907001824 18.883 100 5 10 0 1921816256 13468224 1346208
20:54:29 12805 8192000000 10839957376 11305709568 1914143552 18.940 100 7 14 2 1930061568 13894672 2023344
20:54:48 25115 8192000000 10845726048 11314167808 1917076544 18.963 100 6 12 1 1932038640 13258928 1703168
20:55:20 47528 8192000000 10849722896 11312345088 1925637456 19.032 100 22 46 0 1942508464 10585248 6285760
20:56:14 85516 8192000000 10900641072 11346558976 1944492688 19.183 100 25 46 2 1958610144 8027792 6089664
20:57:49 56931 8192000000 10893063920 11350786048 1951553680 19.239 99 45 90 1 1976078848 11713472 12811696
20:58:53 30433 8192000000 10898564464 11355144192 1945852304 19.193 99 19 38 0 1968726992 17270960 5603728
20:59:29 71289 8192000000 10915090864 11365797888 1959413792 19.301 99 21 42 0 1980075184 14707616 5953776
21:00:48 32781 8192000000 10910025904 11367419904 1978180576 19.450 100 11 22 1 1995037872 13840160 3017136
21:01:27 44222 8192000000 10899510544 11366920192 1970778608 19.392 100 17 34 0 1995297616 19475696 5043312
21:02:19 45291 8192000000 10905612288 11376635904 1971305648 19.396 100 11 22 1 1998279456 23338096 3635712
21:03:10 60092 8192000000 10898862432 11385659392 1950685024 19.232 99 15 30 0 1980457776 24912576 4860176
21:04:35 98535 8192000000 10898718544 11368755200 1949978096 19.226 99 14 28 0 1969368592 15621056 3769440
21:06:29 44588 8192000000 10909557200 11373170688 1979682176 19.462 100 30 60 0 1999487264 11579696 8225392
21:07:19 73906 8192000000 10928454304 11391688704 1984552384 19.501 100 9 18 0 1998992384 11946288 2493712
21:08:48 88304 8192000000 10931733664 11395895296 1958725424 19.296 98 24 48 0 1987839024 21922976 7190624
21:10:29 54336 8192000000 10930503792 11408584704 1984168464 19.498 100 10 20 1 2010064496 22962720 2933312
21:11:29 101553 8192000000 10906616000 11379314688 1943998064 19.179 98 6 12 0 1959736032 14008480 1729488
21:13:17 80031 8192000000 10935013456 11383304192 1953093968 19.251 98 19 38 2 1968596800 10147808 5355024
21:14:48 23934 8192000000 10920120016 11374874624 1958359792 19.293 98 42 84 2 1981221984 10846320 12015872
21:15:18 44781 8192000000 10939722768 11397541888 1992525952 19.564 100 44 89 1 2016763312 12256368 11980992
21:16:09 35244 8192000000 10944256496 11396362240 2000469696 19.626 100 40 80 2 2023183296 12237152 10476448
21:16:55 27081 8192000000 10940310608 11392630784 1965009408 19.346 98 33 66 0 1984748080 11021104 8717568
21:17:28 29352 8192000000 10937779920 11395211264 1963537984 19.334 98 32 64 1 1984134208 11539968 9056256
21:18:06 41352 8192000000 10901210448 11360403456 1925689232 19.032 97 30 60 0 1945237056 10841888 8705936
21:18:54 78805 8192000000 10935521616 11376082944 1983212992 19.490 100 48 96 1 2004444384 6900032 14331360
21:20:28 53244 8192000000 10911081200 11371986944 1929971600 19.067 97 24 48 4 1943502192 6929088 6601504
21:21:47 45974 8192000000 10889012928 11351789568 1943972432 19.178 98 30 60 1 1963187024 10463184 8751408
21:22:39 35277 8192000000 10891551520 11359166464 1940098848 19.148 98 17 34 1 1953962512 8244896 5618768
21:24:13 51542 8192000000 10882309744 11366846464 1950835120 19.233 99 7 14 0 1959357520 6490160 2032240
21:25:11 46803 8192000000 10860633952 11325861888 1854825456 18.461 94 10 19 0 1864017344 6793360 2398528
21:26:04 61882 8192000000 10840585168 11315400704 1889569200 18.742 97 14 28 0 1911857232 18504896 3783136
21:27:23 70600 8192000000 10836955824 11314794496 1841848576 18.356 95 11 20 2 1856930608 12355856 2726176
21:28:41 66904 8192000000 10837392784 11305938944 1798902880 18.005 93 10 18 2 1811236448 9746080 2587488
21:30:03 45454 8192000000 10854108672 11317604352 1916191984 18.956 99 18 36 3 1930851712 9567856 5091872
21:30:56 115393 8192000000 10837088432 11299307520 1730486784 17.440 89 8 16 1 1743587104 10857744 2242576
21:32:58 81346 8192000000 10843201104 11289858048 1778388304 17.836 93 22 43 0 1794017520 10165280 5463936
21:34:26 52320 8192000000 10845462416 11294679040 1882501600 18.685 98 34 69 1 1902689120 10286304 9901216
21:35:25 17250 8192000000 10808081728 11247661056 1808916912 18.087 95 38 76 1 1828509648 9122480 10470256
21:35:51 58135 8192000000 10833879888 11288645632 1874680560 18.622 99 27 54 0 1893487072 11353344 7453168
21:36:59 97505 8192000000 10866582304 11319545856 1874689472 18.622 98 20 40 1 1896581024 16337168 5554384
21:38:43 86232 8192000000 10865203232 11332689920 1871461904 18.596 97 22 44 0 1897674336 20297248 5915184
21:40:15 66447 8192000000 10852367632 11324334080 1883987136 18.697 98 10 20 0 1904938272 17978176 2972960
21:41:37 152741 8192000000 10873755168 11357081600 1888667264 18.735 98 16 32 1 1917056224 23754448 4634512
21:44:16 128724 8192000000 10874589872 11335516160 1940935728 19.154 100 17 34 1 1964770944 19147248 4687968
21:47:06 38018 8192000000 10881021616 11336626176 1938804816 19.137 99 35 68 1 1960022336 11839504 9378016
21:47:51 33773 8192000000 10889670736 11353620480 1954503424 19.262 100 36 72 0 1977055360 12140608 10411328
21:48:45 72957 8192000000 10871085344 11359145984 1937247280 19.125 99 10 20 1 1956950880 17296384 2407216
21:50:12 23524 8192000000 10847709040 11334631424 1925635792 19.032 99 6 12 0 1943546176 16404912 1505472
21:50:42 46792 8192000000 10878079584 11351408640 1956859424 19.281 100 19 37 2 1971900240 9486640 5554176
21:51:34 67388 8192000000 10863224032 11335409664 1897780608 18.808 97 16 31 0 1909823536 7828960 4213968
21:52:48 61263 8192000000 10866598608 11333836800 1914002640 18.939 98 19 38 1 1928767248 8276704 6487904
21:53:56 56859 8192000000 10853898640 11333107712 1927006928 19.043 99 15 30 0 1939613168 8318656 4287584
21:55:18 60882 8192000000 10852205504 11333947392 1938355728 19.134 100 18 36 1 1949427504 6170832 4900944
21:56:30 69657 8192000000 10879686480 11358486528 1950654640 19.232 100 9 18 0 1960215328 7260864 2299824
21:57:48 36150 8192000000 10885350096 11349090304 1908473424 18.894 97 14 27 1 1921809680 9567440 3768816
21:58:33 62263 8192000000 10877396272 11352723456 1913499424 18.935 97 13 26 0 1926734864 9880240 3355200
21:59:52 160439 8192000000 10912388992 11380932608 1946451200 19.198 98 14 28 0 1962501424 12035440 4014784
22:03:16 48718 8192000000 10917310208 11392761856 1964289792 19.340 99 14 28 0 1985633440 17866304 3477344
22:04:11 141914 8192000000 10923480800 11392401408 1914097248 18.940 96 23 44 0 1930135552 10162912 5875392
22:06:42 67322 8192000000 10910478480 11379757056 1933482736 19.095 97 35 70 0 1954159168 10656688 10019744
22:07:56 50151 8192000000 10929164128 11396767744 1988250288 19.530 100 24 47 3 2009288800 13940432 7098080
22:08:55 83337 8192000000 10920615552 11407286272 1938470848 19.135 97 12 24 0 1959403168 18013280 2919040
22:10:25 162634 8192000000 10881971904 11366096896 1868933952 18.576 94 11 22 0 1889751856 17603616 3214288
22:13:14 63139 8192000000 10906306720 11369799680 1931400064 19.078 97 29 58 1 1950820576 11270720 8149792
22:15:24 76644 8192000000 10854047872 11322429440 1875189040 18.626 96 9 18 0 1886571792 8756096 2626656
22:16:47 72975 8192000000 10840085680 11308961792 1827934976 18.242 94 12 24 0 1842805264 10853824 4016464
22:18:06 61459 8192000000 10846998272 11324420096 1892977888 18.770 98 18 36 0 1910895920 12507568 5410464
22:19:16 89943 8192000000 10816936208 11281592320 1797812896 17.996 93 24 48 1 1816335744 11498496 7024352
22:20:53 71736 8192000000 10817342000 11302404096 1815783040 18.143 95 7 14 1 1836456928 19081056 1592832
22:22:18 61522 8192000000 10835740144 11308216320 1861349088 18.514 97 8 16 0 1869724368 6587040 1788240
22:23:47 53065 8192000000 10861851360 11336671232 1895066000 18.787 98 12 24 0 1913398000 14669632 3662368
22:24:46 58138 8192000000 10843504112 11310137344 1852816448 18.445 96 23 47 1 1875752576 16110880 6825248
22:25:58 56778 8192000000 10807713024 11289980928 1802662352 18.036 94 13 26 2 1825692400 19058736 3971312
22:27:04 6199 8192000000 9043011056 9263124480 203385328 2.422 11 2 4 0 207009600 3499648 124624

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:29, from 11-12-2020 22:28:19 to 11-12-2020 22:28:48.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 148 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 11-12-2020 22:28:49 to 11-12-2020 22:28:51.

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          247878
MON$OLDEST_ACTIVE               247879
MON$OLDEST_SNAPSHOT             247879
MON$NEXT_TRANSACTION            247879
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                       2012032
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.33400 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33400 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33400 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33400 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'

11.12.20 22:28:52. 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-11 22:28:55 No severe PSQL-related problems occured
11.12.20 22:28:56. End of report.