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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID df9f488d08424df294c459d6c283e9c3
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-03-04 16:07
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.26
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17298068 kB
MemAvailable 31505796 kB
Buffers 0 kB
Cached 14350144 kB
SwapCached 0 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-23 19:27:26
DTS_END                         2021-03-23 19:27:26.3890
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/46436
TRN_ID                          235540
ATT_ID                          612
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: 9484.97 21535 1138196
customer order: creation 170.94 384 20513
customer order: refuse 14.86 354 1783
order to supplier: creation 44.68 1416 5361
order to supplier: removal 3.60 108526 432
invoice (draft): creation 45.88 3459 5506
invoice (draft): removal 55.43 839 6651
invoice accept: apply 41.00 19391 4920
invoice accept: cancel 49.73 718 5967
customer reserve: creation 3877.83 187 465339
customer reserve: removal 4884.36 62 586123
realization accept: apply 84.26 217 10111
realization accept: cancel 86.08 124 10330
payment from customer: creation 57.87 154 6944
payment from customer: removal 5.61 130 673
payment to supplier: creation 47.86 156 5743
payment to supplier: removal 3.44 132 413
service: total inventory turnovers 4.78 954 574
service: total monetary turnovers 6.01 24 721
service: aggregate perf. data 0.73 23431 88
service: refresh index statistics 0.03 270047 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 23-03-2021 19:28:35 to 23-03-2021 19:28:38.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3846
TEST_TIME 2 3160
TEST_TIME 3 2707
TEST_TIME 4 4176
TEST_TIME 5 3998
TEST_TIME 6 3727
TEST_TIME 7 3980
TEST_TIME 8 4061
TEST_TIME 9 4314
TEST_TIME 10 5151
TEST_TIME 11 5455
TEST_TIME 12 5647
TEST_TIME 13 5625
TEST_TIME 14 5797
TEST_TIME 15 5793
TEST_TIME 16 6274
TEST_TIME 17 6687
TEST_TIME 18 6663
TEST_TIME 19 6705
TEST_TIME 20 6916
TEST_TIME 21 7347
TEST_TIME 22 7814
TEST_TIME 23 7672
TEST_TIME 24 8150
TEST_TIME 25 8666
TEST_TIME 26 8754
TEST_TIME 27 9435
TEST_TIME 28 10488
TEST_TIME 29 10273
TEST_TIME 30 10102
TEST_TIME 31 9934
TEST_TIME 32 9967
TEST_TIME 33 9967
TEST_TIME 34 9977
TEST_TIME 35 9911
TEST_TIME 36 9753
TEST_TIME 37 9724
TEST_TIME 38 9801
TEST_TIME 39 9827
TEST_TIME 40 9825
TEST_TIME 41 9771
TEST_TIME 42 9627
TEST_TIME 43 9639
TEST_TIME 44 9519
TEST_TIME 45 9353
TEST_TIME 46 9453
TEST_TIME 47 9397
TEST_TIME 48 9447
TEST_TIME 49 9563
TEST_TIME 50 9534
TEST_TIME 51 9509
TEST_TIME 52 9490
TEST_TIME 53 9559
TEST_TIME 54 9597
TEST_TIME 55 9636
TEST_TIME 56 9782
TEST_TIME 57 9821
TEST_TIME 58 9809
TEST_TIME 59 9734
TEST_TIME 60 9636
TEST_TIME 61 9550
TEST_TIME 62 9506
TEST_TIME 63 9478
TEST_TIME 64 9428
TEST_TIME 65 9391
TEST_TIME 66 9411
TEST_TIME 67 9459
TEST_TIME 68 9435
TEST_TIME 69 9469
TEST_TIME 70 9444
TEST_TIME 71 9553
TEST_TIME 72 9576
TEST_TIME 73 9536
TEST_TIME 74 9573
TEST_TIME 75 9626
TEST_TIME 76 9617
TEST_TIME 77 9720
TEST_TIME 78 9731
TEST_TIME 79 9707
TEST_TIME 80 9613
TEST_TIME 81 9590
TEST_TIME 82 9574
TEST_TIME 83 9539
TEST_TIME 84 9520
TEST_TIME 85 9517
TEST_TIME 86 9530
TEST_TIME 87 9542
TEST_TIME 88 9525
TEST_TIME 89 9559
TEST_TIME 90 9540
TEST_TIME 91 9542
TEST_TIME 92 9625
TEST_TIME 93 9629
TEST_TIME 94 9640
TEST_TIME 95 9680
TEST_TIME 96 9704
TEST_TIME 97 9672
TEST_TIME 98 9729
TEST_TIME 99 9744
TEST_TIME 100 9674
TEST_TIME 101 9600
TEST_TIME 102 9551
TEST_TIME 103 9540
TEST_TIME 104 9541
TEST_TIME 105 9546
TEST_TIME 106 9490
TEST_TIME 107 9493
TEST_TIME 108 9456
TEST_TIME 109 9474
TEST_TIME 110 9450
TEST_TIME 111 9468
TEST_TIME 112 9501
TEST_TIME 113 9517
TEST_TIME 114 9494
TEST_TIME 115 9537
TEST_TIME 116 9540
TEST_TIME 117 9523
TEST_TIME 118 9541
TEST_TIME 119 9543
TEST_TIME 120 9486

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 23-03-2021 19:28:39 to 23-03-2021 19:28:42.

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 1570493 1570493 0 0.00 0 32221 7 0 0
doc_list_biud 1570493 1570493 0 0.00 0 25180 29 0 0
sp_add_invoice_to_stock 5037 4920 117 2.32 44 237183 19391 0 117
sp_cancel_adding_invoice 5967 5967 0 0.00 4 71564 718 0 0
sp_cancel_client_order 1783 1783 0 0.00 4 11560 354 0 0
sp_cancel_customer_reserve 586123 586123 0 0.00 1 25183 63 0 0
sp_cancel_pay_from_customer 673 673 0 0.00 3 14154 131 0 0
sp_cancel_pay_to_supplier 413 413 0 0.00 2 7482 133 0 0
sp_cancel_supplier_invoice 6660 6651 9 0.13 2 17791 839 0 9
sp_cancel_supplier_order 432 432 0 0.00 5 1193726 108526 0 0
sp_cancel_write_off 10330 10330 0 0.00 1 20227 125 0 0
sp_client_order 20513 20513 0 0.00 3 36894 385 0 0
sp_customer_reserve 465339 465339 0 0.00 0 105990 188 0 0
sp_fill_shopping_cart 31374 31374 0 0.00 1 21869 39 0 0
sp_fill_shopping_cart_clo_res 465338 465338 0 0.00 0 15227 15 0 0
sp_get_clo_for_invoice 4918 4918 0 0.00 0 32296 336 0 0
sp_kill_cost_storno 17383 17383 0 0.00 0 15093 60 0 0
sp_kill_qstorno_ret_qs2qd 1189659 1189659 0 0.00 0 25091 34 0 0
sp_kill_qty_storno 626315 626315 0 0.00 0 25179 73 0 0
sp_lock_selected_doc 20706 20706 0 0.00 0 7218 5 0 0
sp_make_cost_storno 27716 27716 0 0.00 0 29794 79 0 0
sp_multiply_rows_for_pdistr 27716 27716 0 0.00 0 16478 32 0 0
sp_multiply_rows_for_qdistr 20513 20513 0 0.00 0 35066 200 0 0
sp_pay_from_customer 6944 6944 0 0.00 4 30551 154 0 0
sp_pay_to_supplier 5743 5743 0 0.00 4 32384 156 0 0
sp_payment_common 12687 12687 0 0.00 1 16962 51 0 0
sp_qd_handle_on_cancel_clo 1783 1783 0 0.00 0 11552 332 0 0
sp_qd_handle_on_invoice_upd_sts 10885 10885 0 0.00 0 22190 313 0 0
sp_qd_handle_on_reserve_upd_sts 10111 10111 0 0.00 0 20835 71 0 0
sp_reserve_write_off 10111 10111 0 0.00 6 32260 217 0 0
sp_supplier_invoice 5506 5506 0 0.00 6 77522 3459 0 0
sp_supplier_order 5361 5361 0 0.00 5 29967 1417 0 0
srv_aggregate_perf_data 89 88 1 1.12 2644 363153 23431 0 1
srv_fill_mon_cache_memory 163 163 0 0.00 1544 158103 32064 0 0
srv_find_qd_qs_mism 1091521 1091521 0 0.00 0 27324 6 0 0
srv_make_invnt_saldo 574 574 0 0.00 30 39444 954 0 0
srv_make_money_saldo 721 721 0 0.00 1 960 25 0 0
srv_recalc_idx_stat 4 4 0 0.00 183471 429905 270047 0 0
t$perf-abend:sp_add_invoice_to_stock 117 117 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 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 4920 4920 0 0.00 0 12934 161 0 0
t$perf-norm:sp_cancel_adding_invoice 379 379 0 0.00 1 4111 109 0 0
t$perf-norm:sp_cancel_client_order 1783 1783 0 0.00 0 2069 15 0 0
t$perf-norm:sp_cancel_customer_reserve 624 624 0 0.00 0 2171 17 0 0
t$perf-norm:sp_cancel_pay_from_customer 673 673 0 0.00 0 5576 15 0 0
t$perf-norm:sp_cancel_pay_to_supplier 413 413 0 0.00 0 396 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 382 382 0 0.00 0 1964 15 0 0
t$perf-norm:sp_cancel_supplier_order 432 432 0 0.00 0 19516 1560 0 0
t$perf-norm:sp_cancel_write_off 991 991 0 0.00 0 342 3 0 0
t$perf-norm:sp_client_order 20513 20513 0 0.00 0 7491 18 0 0
t$perf-norm:sp_customer_reserve 1040 1040 0 0.00 0 2043 6 0 0
t$perf-norm:sp_pay_from_customer 6944 6944 0 0.00 0 3934 9 0 0
t$perf-norm:sp_pay_to_supplier 5743 5743 0 0.00 0 11375 13 0 0
t$perf-norm:sp_reserve_write_off 10111 10111 0 0.00 0 8239 12 0 0
t$perf-norm:sp_supplier_invoice 5506 5506 0 0.00 0 4479 13 0 0
t$perf-norm:sp_supplier_order 5361 5361 0 0.00 0 3571 14 0 0
t$perf-norm:srv_aggregate_perf_data 88 88 0 0.00 0 287 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 163 163 0 0.00 0 308 7 0 0
t$perf-norm:srv_make_invnt_saldo 574 574 0 0.00 0 1824 22 0 0
t$perf-norm:srv_make_money_saldo 721 721 0 0.00 0 3267 26 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 7 3 0 0
v_add_invoice_to_stock 10070 9836 234 2.32 0 10863 19 0 234
v_all_customers 37052 37052 0 0.00 0 33 1 0 0
v_all_suppliers 29998 29998 0 0.00 0 63 1 0 0
v_all_wares 41026 41026 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 758 758 0 0.00 0 306 5 0 0
v_cancel_client_order 3566 3566 0 0.00 0 3468 4 0 0
v_cancel_customer_prepayment 1346 1346 0 0.00 0 2086 4 0 0
v_cancel_customer_reserve 1248 1248 0 0.00 0 569 3 0 0
v_cancel_payment_to_supplier 826 826 0 0.00 0 4641 18 0 0
v_cancel_supplier_invoice 782 764 18 2.30 0 1735 17 0 18
v_cancel_supplier_order 864 864 0 0.00 0 487 4 0 0
v_cancel_write_off 1982 1982 0 0.00 0 3345 14 0 0
v_max_id_clo_ord 5361 5361 0 0.00 0 788 1 0 0
v_max_id_clo_res 1040 1040 0 0.00 0 2239 14 0 0
v_max_id_ord_sup 5498 5498 0 0.00 0 6418 4 0 0
v_max_non_paid_invoice 1603 1603 0 0.00 0 4814 5 0 0
v_max_non_paid_realizn 3842 3842 0 0.00 0 2476 4 0 0
v_min_id_clo_ord 5361 5361 0 0.00 0 4679 9 0 0
v_min_id_clo_res 1040 1040 0 0.00 0 990 4 0 0
v_min_id_ord_sup 5498 5498 0 0.00 0 9269 9 0 0
v_min_non_paid_invoice 5743 5743 0 0.00 0 12568 32 0 0
v_min_non_paid_realizn 6944 6944 0 0.00 0 16244 46 0 0
v_our_firm 10178 10178 0 0.00 0 13 1 0 0
v_reserve_write_off 20222 20222 0 0.00 0 4620 4 0 0
x_lock_depdocs_on_canc_invoice 12236 12236 0 0.00 0 18099 110 0 0
x_lock_depdocs_on_canc_sup_ord 432 432 0 0.00 0 12799 367 0 0
x_make_qstorno_1000_1200 5361 5361 0 0.00 1 29943 1334 0 0
x_make_qstorno_1200_2000 5506 5506 0 0.00 3 77514 3318 0 0
x_make_qstorno_2100_3300 465339 465339 0 0.00 0 105988 171 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 23-03-2021 19:28:43 to 23-03-2021 19:28:47.

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
16:57:30 7 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:36 19588 8192000000 10262872784 10567057408 928750608 10.182 74 62 126 1 952205920 2589184 20866128
16:58:06 36847 8192000000 10346297152 10664726528 1393822256 14.540 100 82 164 0 1425224368 5118512 26283600
16:58:54 11745 8192000000 10369304160 10691637248 1432712720 14.885 100 92 184 0 1473535456 11272768 29549968
16:59:19 17807 8192000000 10393421040 10717888512 1448274624 15.023 100 87 174 0 1484245792 7719840 28251328
16:59:50 9047 8192000000 10408921168 10735763456 1463655376 15.158 100 94 188 0 1502995296 8413744 30926176
17:00:13 22691 8192000000 10434614160 10767937536 1488909392 15.379 100 91 182 0 1526640304 9076944 28653968
17:00:44 22240 8192000000 10453809056 10788397056 1506975904 15.537 100 91 182 1 1545677440 10046144 28655392
17:01:16 15398 8192000000 10473983440 10809962496 1526785392 15.709 100 91 180 1 1565351664 10314448 28251824
17:01:47 7671 8192000000 10477052064 10816978944 1537619488 15.803 100 87 174 0 1575784096 10390400 27774208
17:02:02 7277 8192000000 10487389296 10835329024 1551103600 15.920 100 83 166 0 1587080752 10385904 25591248
17:02:22 16511 8192000000 10532843360 10884694016 1585739424 16.217 100 83 166 1 1622335088 11048304 25547360
17:02:47 6798 8192000000 10546599488 10898890752 1603714496 16.371 100 76 152 0 1637535952 10994208 22827248
17:03:02 14932 8192000000 10579531168 10936389632 1625764432 16.559 100 80 160 1 1661800176 11943744 24092000
17:03:29 13602 8192000000 10594790544 10960379904 1655236784 16.809 100 80 160 3 1692519680 13313296 23969600
17:03:51 8487 8192000000 10614144640 10978013184 1669886144 16.932 100 80 160 0 1706044800 12844912 23313744
17:04:07 9816 8192000000 10620705920 10993266688 1687806416 17.083 100 77 154 1 1722337744 12566448 21964880
17:04:24 9797 8192000000 10645846528 11016904704 1701184880 17.195 100 75 150 0 1736063968 12540864 22338224
17:04:41 7683 8192000000 10647236240 11027046400 1721639024 17.366 100 79 158 3 1756280624 12379872 22261728
17:04:58 5029 8192000000 10666825616 11045031936 1738447328 17.506 100 82 163 1 1774879552 12674560 23757664
17:05:10 5763 8192000000 10683419824 11060961280 1749743024 17.599 100 74 148 0 1782466976 12607616 20116336
17:05:24 4099 8192000000 10704065440 11079012352 1762984112 17.709 100 82 162 2 1798180960 12390240 22806608
17:05:36 4045 8192000000 10705438896 11085660160 1765892336 17.733 100 81 159 1 1800652288 12927488 21832464
17:05:46 3364 8192000000 10708627040 11094429696 1775967008 17.816 100 89 172 3 1814060816 13993520 24100288
17:05:56 4149 8192000000 10722890592 11100770304 1783931760 17.882 100 82 163 0 1820472752 13658544 22882448
17:06:08 4134 8192000000 10724784944 11101765632 1787048096 17.908 100 83 166 0 1824753552 14566352 23139104
17:06:19 9268 8192000000 10720477536 11109572608 1789012880 17.924 100 78 156 0 1825323920 13903840 22407200
17:06:34 5493 8192000000 10727232224 11113484288 1792302448 17.951 100 79 156 1 1827059184 12634272 22122464
17:06:47 2843 8192000000 10749030848 11131322368 1812164128 18.114 100 87 174 1 1850279680 13508560 24606992
17:06:56 2956 8192000000 10760861968 11144208384 1820264576 18.180 100 90 180 1 1859769664 13634400 25870688
17:07:06 2448 8192000000 10767399872 11153534976 1824306576 18.213 100 83 168 1 1860637968 12478096 23853296
17:07:16 1812 8192000000 10774158736 11155550208 1833199712 18.285 100 92 185 0 1871584496 11991200 26393584
17:07:24 3534 8192000000 10767052432 11157680128 1834011712 18.292 100 83 165 2 1869847952 12211792 23624448
17:07:34 2153 8192000000 10780691888 11165593600 1837793616 18.323 100 92 183 1 1876817024 13614000 25409408
17:07:43 2392 8192000000 10781921120 11166547968 1844920832 18.381 100 91 182 3 1882547872 12292848 25334192
17:07:52 3008 8192000000 10800602928 11188137984 1853362080 18.449 100 96 192 0 1894162768 13214912 27585776
17:08:02 1242 8192000000 10798313968 11189882880 1858032128 18.487 100 92 183 1 1897307024 11788240 27486656
17:08:10 1628 8192000000 10816049792 11202113536 1864236288 18.538 100 93 187 3 1903188752 12433968 26518496
17:08:18 1697 8192000000 10809037024 11199393792 1864938064 18.543 100 83 166 0 1901915760 12750096 24227600
17:08:26 5328 8192000000 10785831840 11195502592 1863461408 18.531 100 54 109 0 1888329296 9804656 15063232
17:08:37 40038 8192000000 10807593632 11202404352 1869131616 18.577 100 59 118 1 1894111600 7804544 17175440
17:09:24 3557 8192000000 10804041824 11209506816 1879520240 18.661 100 91 183 2 1917882832 11617952 26744640
17:09:41 3064 8192000000 10791174704 11208093696 1871675856 18.598 100 46 92 0 1894468608 10250256 12542496
17:09:54 4278 8192000000 10788526400 11209342976 1874671696 18.622 100 41 82 0 1893994224 7792864 11529664
17:10:07 6511 8192000000 10789119872 11217383424 1877923360 18.648 100 33 66 1 1899042704 12184672 8934672
17:10:20 3178 8192000000 10787564224 11214725120 1877996880 18.649 100 31 62 0 1893992736 7591344 8404512
17:10:32 8522 8192000000 10796041968 11223453696 1887834272 18.728 100 25 50 1 1902528992 7781840 6912880
17:10:46 10149 8192000000 10804230384 11229454336 1888884448 18.737 100 26 51 3 1901826464 5841344 7100672
17:11:04 6565 8192000000 10795642160 11222806528 1889524384 18.742 100 29 56 3 1904065456 6478432 8062640
17:11:20 4705 8192000000 10799851600 11230720000 1893311024 18.772 100 30 60 3 1909239376 7829488 8098864
17:11:35 9861 8192000000 10804930928 11233308672 1893346416 18.773 100 29 59 0 1908365776 6277952 8741408
17:11:52 14907 8192000000 10815516736 11239985152 1896247584 18.796 100 22 44 2 1909322096 6882576 6191936
17:12:13 11641 8192000000 10806881296 11242455040 1901620224 18.839 100 22 44 0 1914347504 6782816 5944464
17:12:31 11586 8192000000 10807961344 11244101632 1900815664 18.833 100 10 20 0 1909257888 5562080 2880144
17:12:49 9203 8192000000 10811902912 11242180608 1901135776 18.835 100 11 22 1 1909810912 5220352 3454784
17:13:04 14850 8192000000 10817490192 11245596672 1905996144 18.874 100 23 46 0 1918972816 5570784 7405888
17:13:25 76231 8192000000 10820092304 11253903360 1889542784 18.742 99 33 66 1 1905010528 6050192 9417552
17:14:48 11379 8192000000 10830391648 11261231104 1907496672 18.887 100 24 47 2 1920575632 6142256 6936704
17:15:11 5990 8192000000 10817794192 11260100608 1910679216 18.912 100 32 64 2 1926623008 6566784 9377008
17:15:25 4733 8192000000 10827404816 11261837312 1913124224 18.932 100 35 70 3 1929750784 6482512 10144048
17:15:40 5553 8192000000 10833261408 11266605056 1915750496 18.953 100 25 50 2 1929334736 6820416 6763824
17:15:57 6232 8192000000 10827749792 11265597440 1918015216 18.971 100 32 64 4 1932829984 6486800 8327968
17:16:09 6311 8192000000 10831178144 11269627904 1919519024 18.983 100 26 52 0 1932988896 6386624 7083248
17:16:25 6679 8192000000 10830141872 11264126976 1914353872 18.942 100 24 48 3 1927358832 6236016 6768944
17:16:37 8651 8192000000 10828123248 11259006976 1895251488 18.788 99 26 52 1 1909635360 6709824 7674048
17:16:59 8811 8192000000 10827440272 11261116416 1912042064 18.923 100 22 44 1 1923880624 4943952 6894608
17:17:17 7165 8192000000 10827877456 11267633152 1916361936 18.958 100 26 52 3 1930066960 5751616 7953408
17:17:31 15290 8192000000 10816335456 11259469824 1891612816 18.759 99 15 30 1 1901679136 6066864 3999456
17:18:00 13556 8192000000 10788595184 11225763840 1854363888 18.458 98 22 44 1 1866460688 5738160 6358640
17:18:20 22967 8192000000 10712554656 11122536448 1775965040 17.816 96 29 57 1 1788090384 4884304 7241040
17:19:19 20723 8192000000 10738623904 11167485952 1704248384 17.221 92 21 42 1 1715870192 5267616 6354192
17:19:46 12623 8192000000 10739580736 11160743936 1787786464 17.914 97 26 52 4 1801049984 6127856 7135664
17:20:05 7000 8192000000 10744448864 11168673792 1792215680 17.950 97 22 44 1 1804544240 6111216 6217344
17:20:22 5687 8192000000 10751656960 11159416832 1807701408 18.077 98 40 80 4 1826008432 6630576 11676448
17:20:34 5064 8192000000 10713494336 11120955392 1712523840 17.290 94 35 68 3 1728255808 5403664 10328304
17:20:50 4969 8192000000 10683904080 11104468992 1737945424 17.502 97 32 65 1 1753796704 6643376 9207904
17:21:03 8468 8192000000 10716900816 11130687488 1756463136 17.655 97 26 53 1 1768806944 4865440 7478368
17:21:19 8232 8192000000 10715070064 11133968384 1784299248 17.885 99 22 44 2 1795933264 5382768 6251248
17:21:35 6826 8192000000 10660727888 11076898816 1723753984 17.383 96 22 44 2 1735257616 5127376 6376256
17:21:49 7707 8192000000 10715992752 11134779392 1801209632 18.024 100 28 57 1 1815161152 5438752 8512768
17:22:03 5644 8192000000 10705933280 11117576192 1738469760 17.506 96 36 72 0 1754220992 5426336 10324896
17:22:16 9748 8192000000 10712671456 11134373888 1794655952 17.970 100 17 33 1 1804915616 5112784 5146880
17:22:35 6477 8192000000 10720911920 11141185536 1806419648 18.067 100 25 51 3 1819970000 6623088 6927264
17:22:48 8338 8192000000 10708125312 11127062528 1751800496 17.617 97 11 19 1 1760190208 5219120 3170592
17:23:02 9524 8192000000 10704840528 11136253952 1786652672 17.904 99 19 36 1 1797684688 5634304 5397712
17:23:18 70831 8192000000 10728104928 11154067456 1807747136 18.077 99 26 51 1 1820189696 5279984 7162576
17:24:35 11490 8192000000 10738717088 11169218560 1828471312 18.247 100 18 36 1 1839359968 5897344 4991312
17:24:55 4370 8192000000 10763476336 11180490752 1839430896 18.336 100 31 61 1 1854391920 6655904 8305120
17:25:08 5933 8192000000 10764826544 11181789184 1844709136 18.379 100 41 82 2 1862977296 7056864 11211296
17:25:20 6867 8192000000 10757782528 11183267840 1841141168 18.350 100 19 38 1 1853569712 7277168 5151376
17:25:37 6601 8192000000 10766639040 11190128640 1850459088 18.426 100 27 54 2 1863658272 5719104 7480080
17:25:51 6429 8192000000 10769769536 11196809216 1850717088 18.428 100 24 47 5 1862216896 4763952 6735856
17:26:04 6697 8192000000 10761081776 11193733120 1851723936 18.436 100 27 54 1 1865610592 5213312 8673344
17:26:17 8543 8192000000 10762948992 11196948480 1853275296 18.449 100 19 38 0 1864030432 5602784 5152352
17:26:32 10290 8192000000 10767766912 11200978944 1859531824 18.499 100 27 54 1 1873116624 5904656 7680144
17:26:48 12255 8192000000 10777901232 11205222400 1863147824 18.529 100 18 35 3 1873765936 5248976 5369136
17:27:07 10681 8192000000 10794689280 11224805376 1877913760 18.648 100 15 30 0 1886668368 4921392 3833216
17:27:25 22846 8192000000 10819947008 11235057664 1888900400 18.737 100 19 34 4 1898706736 4558752 5247584
17:27:54 16530 8192000000 10837775776 11253731328 1905726432 18.872 100 50 100 2 1926833840 6093296 15014112
17:28:23 59667 8192000000 10834404864 11264536576 1912715248 18.928 100 42 84 0 1933161280 8115936 12330096
17:29:50 87698 8192000000 10861838832 11297955840 1929789808 19.065 100 36 68 2 1951142000 11281408 10070784
17:31:29 28786 8192000000 10861629104 11307872256 1940873808 19.154 100 27 54 2 1961793552 12076400 8843344
17:32:07 19867 8192000000 10879788992 11313778688 1948849296 19.217 100 43 85 0 1972743456 11297504 12596656
17:32:35 11303 8192000000 10883840896 11312787456 1933912672 19.098 99 44 87 0 1959502896 12557632 13032592
17:32:55 7684 8192000000 10887090688 11319943168 1953910080 19.258 100 45 90 1 1980721808 12905744 13905984
17:33:21 30859 8192000000 10907983632 11340079104 1965390656 19.349 100 52 104 0 1997308816 16644432 15273728
17:34:02 6652 8192000000 10922802864 11349385216 1973449952 19.413 100 53 106 0 2007186864 17560352 16176560
17:34:19 10199 8192000000 10922015792 11356934144 1980313264 19.467 100 50 100 2 2014305136 18710784 15281088
17:34:39 6050 8192000000 10942643552 11364290560 1987196432 19.522 100 69 137 2 2027100720 19584160 20320128
17:34:56 7951 8192000000 10943637072 11368169472 1988764080 19.534 100 70 139 2 2030644448 21711984 20168384
17:35:17 9826 8192000000 10941539792 11370835968 1988527296 19.532 100 63 126 4 2029628416 22831440 18269680
17:35:37 8892 8192000000 10940053808 11370532864 1989141232 19.537 100 59 118 1 2030061536 23070928 17849376
17:35:55 14477 8192000000 10942228256 11378937856 1992748096 19.566 100 56 111 2 2034898288 25264544 16885648
17:36:20 6602 8192000000 10955629552 11387355136 2001348672 19.633 100 60 121 3 2045302128 25366560 18586896
17:36:37 10263 8192000000 10940464144 11382894592 1994304592 19.578 100 47 94 2 2036503856 26864160 15335104
17:36:58 23105 8192000000 10950180688 11394486272 2000067088 19.623 100 51 102 0 2045329696 28704176 16558432
17:37:36 8892 8192000000 10957997584 11399376896 2007438368 19.681 100 51 98 3 2048856416 25960672 15457376
17:37:57 6720 8192000000 10968438528 11400818688 2012583376 19.722 100 66 130 1 2058409072 26089248 19736448
17:38:18 11257 8192000000 10965998432 11406450688 2012223968 19.719 100 61 122 2 2058866032 27745824 18896240
17:38:37 3270 8192000000 10985609696 11409551360 2018417552 19.768 100 74 148 0 2069855568 28429568 23008448
17:38:47 4384 8192000000 10985699728 11414294528 2021060368 19.788 100 84 168 1 2075603648 28619920 25923360
17:39:01 5251 8192000000 10992030544 11418009600 2022842928 19.802 100 84 168 2 2077508304 29436400 25228976
17:39:17 2422 8192000000 10992969328 11420176384 2023063728 19.804 100 72 142 1 2074147968 29900848 21183392
17:39:28 6422 8192000000 10986096032 11421859840 2025058368 19.820 100 72 144 2 2074966032 28391264 21516400
17:39:42 9175 8192000000 10992394288 11423645696 2026053952 19.828 100 58 117 0 2074133296 30425152 17654192
17:39:58 4013 8192000000 11013641248 11436253184 2035669616 19.903 100 75 148 0 2090783296 32190656 22923024
17:40:12 6047 8192000000 10988325648 11427037184 2028281808 19.845 100 64 129 1 2080735088 33066592 19386688
17:40:26 4256 8192000000 10998161424 11431886848 2028754896 19.849 100 61 122 2 2081743568 34004864 18983808
17:40:39 4636 8192000000 11007644368 11440750592 2034852384 19.897 100 67 133 1 2089463328 34062016 20548928
17:40:51 4988 8192000000 11018869728 11452264448 2040183200 19.938 100 77 154 1 2102102928 38017744 23901984
17:41:05 2586 8192000000 11022710720 11452518400 2046118976 19.985 100 82 165 1 2108649664 37785280 24745408
17:41:16 3663 8192000000 10996276560 11428175872 2020322496 19.783 99 69 136 1 2079334000 37974464 21037040
17:41:27 13705 8192000000 10999893984 11437711360 2030496160 19.863 100 67 133 0 2088755600 37851616 20407824
17:41:50 4890 8192000000 11010386512 11444441088 2031261904 19.869 100 68 135 0 2092762336 40316512 21183920
17:42:03 7849 8192000000 10986422848 11419758592 2002622688 19.643 99 67 132 1 2063348048 40093856 20631504
17:42:23 6928 8192000000 10980661808 11419828224 1995598592 19.588 99 58 116 1 2055030608 40610704 18821312
17:42:38 5893 8192000000 10998082320 11431616512 2017375584 19.760 100 70 140 1 2082657008 42742640 22538784
17:42:52 6237 8192000000 10985434496 11417886720 2002003584 19.639 99 63 125 1 2067175520 45475280 19696656
17:43:07 5721 8192000000 10996366976 11430785024 2010368336 19.704 100 69 138 0 2082316992 49770512 22178144
17:43:25 6740 8192000000 10993582336 11431104512 1998002336 19.607 99 56 112 1 2067418192 51152704 18263152
17:43:50 4788 8192000000 10991598320 11432026112 1997487488 19.603 99 50 100 2 2063150048 47958320 17704240
17:44:14 5191 8192000000 10995171696 11428179968 2007918672 19.685 99 63 126 2 2077693264 48340272 21434320
17:44:28 7062 8192000000 10991912752 11423473664 2002280560 19.641 99 69 138 0 2073422384 49317424 21824400
17:44:44 4479 8192000000 10998231312 11436171264 2007775488 19.684 99 73 144 1 2079722800 49043504 22903808
17:45:04 2053 8192000000 11014444480 11441201152 2018449968 19.768 100 84 168 1 2092587072 47107872 27029232
17:45:13 1872 8192000000 11017970304 11442380800 2021899408 19.795 100 79 158 0 2095804624 49082496 24822720
17:45:22 1605 8192000000 11024153248 11445407744 2025064832 19.820 100 93 185 1 2106947040 51145312 30736896
17:45:34 2956 8192000000 11003327824 11429171200 1994936656 19.583 99 78 152 1 2071257760 52099696 24221408
17:45:45 5460 8192000000 11011726240 11442118656 2019225712 19.774 100 72 143 3 2093783488 51714496 22843280
17:45:58 4167 8192000000 11016209600 11433877504 2010669792 19.707 100 82 165 0 2090087232 52582528 26834912
17:46:11 1541 8192000000 11016627056 11431710720 2009249392 19.696 100 90 181 0 2089967424 52078272 28639760
17:46:21 2489 8192000000 11009635584 11429294080 2010776064 19.708 100 82 164 0 2090764336 54158000 25830272
17:46:32 2064 8192000000 11009391312 11432611840 2006580928 19.675 100 88 176 1 2090463840 56178576 27704336
17:46:45 6756 8192000000 10993737088 11412463616 1991574272 19.556 100 84 168 2 2074603904 56384816 26644816
17:47:00 3822 8192000000 10998267536 11422081024 1994496288 19.579 100 75 149 2 2076685728 57938032 24251408
17:47:12 3351 8192000000 11001375024 11425611776 1998183680 19.608 100 78 153 0 2087905408 64773872 24947856
17:47:23 2751 8192000000 10993028480 11413110784 1986162064 19.513 100 78 153 0 2071267824 60182176 24923584
17:47:32 3721 8192000000 10984512208 11414937600 1976988656 19.441 99 81 162 0 2065161120 61408768 26763696
17:47:44 4685 8192000000 10980146256 11404902400 1976872512 19.440 100 65 128 0 2062820640 63344064 22604064
17:47:55 6739 8192000000 10958714496 11399548928 1965254816 19.348 100 49 98 1 2046905296 64389888 17260592
17:48:13 19345 8192000000 10951619248 11397193728 1971511136 19.397 100 42 84 1 2041923840 55928784 14483920
17:48:45 7743 8192000000 10959924656 11401613312 1980483312 19.469 100 42 84 1 2048633232 53807824 14342096
17:49:01 6097 8192000000 10964200976 11405332480 1959239568 19.300 99 44 87 0 2029351504 55317216 14794720
17:49:15 8354 8192000000 10951619712 11390242816 1947080192 19.203 99 37 74 2 2017241728 57429856 12731680
17:49:43 19198 8192000000 10946417824 11400425472 1954628544 19.263 99 30 60 2 2017277760 52392608 10256608
17:50:18 16698 8192000000 10948186576 11391262720 1946977936 19.202 99 36 70 2 2015960320 56732688 12249696
17:50:51 18383 8192000000 10944996592 11398070272 1953996496 19.258 100 35 69 3 2032556256 66183168 12376592
17:51:18 16864 8192000000 10937632448 11387117568 1954738656 19.264 100 31 62 2 2023643680 56964976 11940048
17:52:01 17353 8192000000 10922892880 11371212800 1931143392 19.076 99 30 60 1 1991651008 49571200 10936416
17:52:24 14613 8192000000 10917500576 11366678528 1906262368 18.877 98 26 52 1 1966635600 51148800 9224432
17:52:58 30325 8192000000 10919329376 11383734272 1942388976 19.166 100 25 50 2 2000772592 49423440 8960176
17:53:50 28216 8192000000 10903347360 11360460800 1900485280 18.830 98 21 42 1 1964873248 56338752 8049216
17:54:25 38056 8192000000 10888904240 11350093824 1918996528 18.979 100 14 28 1 1966073072 41752048 5324496
17:55:09 16112 8192000000 10859308352 11327053824 1916876960 18.962 100 16 32 1 1954769312 32278896 5613456
17:55:31 12499 8192000000 10853447360 11319873536 1903423408 18.854 99 14 28 1 1927385312 19973744 3988160
17:55:53 58358 8192000000 10843370704 11290423296 1847300768 18.400 96 36 72 1 1865806288 7954848 10550672
17:56:59 112835 8192000000 10873332640 11301462016 1863064336 18.528 97 37 74 0 1884248576 10640848 10543392
17:58:59 7611 8192000000 10863723408 11299184640 1904598144 18.863 99 62 120 1 1930693648 8021184 18074320
17:59:14 6357 8192000000 10880899760 11307720704 1911908720 18.922 99 69 132 1 1938647168 8450592 18287856
17:59:27 38283 8192000000 10858680416 11319373824 1936113680 19.116 100 53 105 0 1961172912 10797296 14261936
18:00:26 92327 8192000000 10878029856 11335364608 1902338288 18.845 98 22 44 0 1921525968 13188080 5999600
18:02:09 92590 8192000000 10859286384 11322138624 1892120384 18.763 97 20 39 3 1906753744 8049056 6584304
18:03:48 60775 8192000000 10867650352 11332550656 1927711984 19.049 99 31 62 1 1948126672 10589792 9824896
18:04:59 28984 8192000000 10880497152 11336155136 1947113328 19.203 100 25 51 0 1964381760 9860512 7407920
18:05:34 34844 8192000000 10897906416 11345784832 1958729840 19.296 100 40 78 0 1978929344 9440432 10759072
18:06:18 19653 8192000000 10893154368 11323465728 1944510496 19.183 100 43 85 0 1965939488 9832864 11596128
18:06:47 158103 8192000000 10885331216 11364167680 1946187424 19.196 99 23 46 1 1966103216 12568592 7347200
18:09:32 33746 8192000000 10874248880 11337527296 1909541072 18.903 97 26 51 2 1930037760 13266448 7230240
18:11:04 73278 8192000000 10895437008 11369406464 1968608336 19.374 100 19 38 2 1991144096 17021824 5513936
18:12:34 78688 8192000000 10887761152 11382595584 1971060192 19.394 100 14 28 0 1993125600 18212976 3852432
18:14:01 19572 8192000000 10903256400 11384655872 1969767264 19.384 100 7 14 1 1986874016 15124704 1982048
18:14:29 38494 8192000000 10914418832 11371786240 1963525984 19.334 99 25 50 1 1981329440 10643600 7159856
18:15:17 76164 8192000000 10903232672 11384233984 1975097936 19.426 100 12 24 0 1993149712 14507824 3543952
18:16:39 42417 8192000000 10905867088 11374346240 1963722992 19.336 99 27 54 1 1982212416 9889392 8600032
18:17:28 44679 8192000000 10914529712 11380285440 1984605232 19.501 100 23 45 0 2001850848 11011040 6234576
18:18:24 32220 8192000000 10942135280 11399090176 1993776192 19.574 100 33 66 1 2017841760 14158640 9906928
18:19:17 43004 8192000000 10933903200 11405467648 2000550096 19.627 100 20 40 1 2020498080 14158384 5789600
18:20:12 58437 8192000000 10910742832 11378429952 1969135952 19.379 99 14 28 0 1984688752 11426256 4126544
18:21:21 55387 8192000000 10937569984 11397591040 1998545056 19.611 100 23 46 0 2019188432 13104800 7538576
18:22:24 61545 8192000000 10925461120 11405332480 1999206208 19.616 100 21 42 3 2021238880 15670688 6361984
18:23:31 60432 8192000000 10931890048 11404886016 1998113712 19.608 100 8 16 1 2010881616 10587568 2180336
18:24:41 54676 8192000000 10919122288 11378733056 1937345792 19.126 97 23 46 0 1954408864 10867808 6195264
18:25:44 25512 8192000000 10914685984 11365924864 1961886256 19.321 99 56 113 2 1986035808 8135456 16014096
18:26:19 23086 8192000000 10930384976 11367682048 1978046608 19.449 100 38 76 1 1998581296 9902128 10632560
18:26:56 129471 8192000000 10903661728 11373461504 1966847392 19.360 99 35 70 0 1984342144 7524192 9970560
18:29:18 15237 8192000000 10904184336 11377319936 1983606736 19.493 100 25 50 1 1999567120 9268656 6691728
18:29:39 27929 8192000000 10890579616 11356823552 1949881600 19.226 98 28 56 0 1964814656 7640864 7292192
18:30:21 62501 8192000000 10863835376 11342884864 1935736912 19.113 98 19 38 0 1949224624 8400624 5087088
18:32:03 61506 8192000000 10875657984 11359133696 1907993760 18.891 97 4 8 0 1916223168 7508784 720624
18:33:11 45865 8192000000 10879590864 11357913088 1910098640 18.907 97 21 42 1 1927939824 12031232 5809952
18:34:12 32649 8192000000 10869805344 11343548416 1918385024 18.974 98 14 28 0 1932604672 10241648 3978000
18:35:03 54649 8192000000 10891990736 11341258752 1885156224 18.707 96 17 34 0 1901516448 11607920 4752304
18:36:08 33036 8192000000 10872873984 11341430784 1914336336 18.941 98 17 35 2 1932210608 13106016 4768256
18:36:47 70108 8192000000 10883653968 11337506816 1871579456 18.597 96 11 22 1 1890473856 15769728 3124672
18:38:04 62353 8192000000 10857874592 11340300288 1887006416 18.722 97 34 68 1 1921680352 24647824 10026112
18:39:16 46123 8192000000 10842350096 11295105024 1802286336 18.033 93 24 48 1 1815733216 6731712 6715168
18:40:09 55003 8192000000 10834111600 11286482944 1827462512 18.239 95 36 72 1 1847086288 9565504 10058272
18:41:17 14931 8192000000 10854017200 11295027200 1908500928 18.895 100 42 84 2 1929580048 9789968 11289152
18:41:40 33283 8192000000 10847354400 11296710656 1888698544 18.735 99 39 78 0 1911472640 11998128 10775968
18:42:19 21501 8192000000 10838232896 11287359488 1858376256 18.490 97 43 86 1 1882792800 12071920 12344624
18:42:56 49538 8192000000 10847129616 11306627072 1881220352 18.675 98 42 83 0 1907343440 15021136 11101952
18:43:52 32253 8192000000 10854481840 11329970176 1916680368 18.960 100 12 24 1 1940525776 20209200 3636208
18:44:38 58163 8192000000 10834639040 11286663168 1827106768 18.236 95 11 22 0 1847429168 17614080 2708320
18:45:43 55646 8192000000 10838142256 11296063488 1854160240 18.456 97 13 26 1 1869620784 11830880 3629664
18:46:44 51690 8192000000 10854673264 11314946048 1921362912 18.998 100 35 68 2 1943449152 13335520 8750720
18:48:18 56998 8192000000 10838179936 11312123904 1899935680 18.826 99 25 50 0 1924800976 17052608 7812688
18:49:25 68694 8192000000 10841964064 11318788096 1911743008 18.921 99 27 54 2 1937831840 17578096 8510736
18:51:09 56150 8192000000 10839404256 11318247424 1919947296 18.986 100 7 14 1 1934027856 12246704 1833856
18:52:11 59053 8192000000 10844985712 11328438272 1912901744 18.930 99 15 30 0 1928685648 11391120 4392784
18:53:17 49729 8192000000 10855183232 11340652544 1932207024 19.085 100 8 16 0 1951316128 16453296 2655808
18:54:16 86382 8192000000 10866360736 11340046336 1916171312 18.956 99 15 30 0 1931972480 11520928 4280240
18:55:49 91461 8192000000 10877155888 11331952640 1880865264 18.672 97 15 32 0 1897803504 12641216 4297024
18:57:39 43619 8192000000 10882141936 11341463552 1932682352 19.088 99 31 62 1 1951349280 10072128 8594800
18:58:29 138407 8192000000 10896377072 11371655168 1925333888 19.030 98 15 30 0 1945563536 16276080 3953568
19:00:53 74629 8192000000 10909950608 11373682688 1966876528 19.361 100 11 22 0 1986865632 16958960 3030144
19:03:18 86426 8192000000 10915025104 11383709696 1918023344 18.971 97 12 24 0 1935323440 14054144 3245952
19:04:51 14079 8192000000 10937296896 11381919744 1966392688 19.357 99 44 86 3 1992144496 12474896 13276912
19:05:12 19370 8192000000 10914570400 11373072384 1965192000 19.347 99 44 88 0 1997947600 20387072 12368528
19:07:17 115475 8192000000 10901863680 11375841280 1961715232 19.320 99 21 42 0 1976096944 8617232 5764480
19:09:23 42901 8192000000 10904782384 11387908096 1986438624 19.516 100 29 58 1 2006405312 11479424 8487264
19:10:19 58827 8192000000 10899233024 11395117056 1969409232 19.381 99 12 24 0 1989983952 16779488 3795232
19:11:26 26829 8192000000 10902368880 11403313152 1982377872 19.484 100 4 8 0 2000456192 16838208 1240112
19:11:59 4525 8192000000 10905379344 11406200832 1984397088 19.499 100 4 8 0 2002548640 17026736 1124816
19:12:09 11690 8192000000 10907674080 11403534336 1985420048 19.508 100 8 16 0 2002860688 15516720 1923920
19:12:27 34806 8192000000 10896695856 11400450048 1972913200 19.409 100 10 20 0 1989936464 14349840 2673424
19:13:11 37168 8192000000 10913607712 11394908160 1966536096 19.358 99 11 22 1 1983745632 14298912 2910624
19:14:01 78706 8192000000 10911480928 11405119488 1985280080 19.506 100 16 32 1 2010753360 20245504 5227776
19:15:33 40271 8192000000 10915944480 11405365248 1992130448 19.561 100 22 44 4 2016913632 18539584 6243600
19:16:20 94096 8192000000 10901986544 11390443520 1911566624 18.919 96 11 22 2 1927256976 12502704 3187648
19:18:50 72284 8192000000 10909986128 11390713856 1927975968 19.051 97 12 24 2 1953578784 21849744 3753072
19:20:08 58605 8192000000 10882878752 11373363200 1882831792 18.688 95 10 20 0 1900290400 13959600 3499008
19:21:13 50139 8192000000 10912431616 11368796160 1940868560 19.154 99 30 59 0 1964749728 15852832 8028336
19:22:12 31400 8192000000 10902950080 11376041984 1947488816 19.206 99 34 68 1 1972662784 15783728 9390240
19:22:56 23175 8192000000 10906974192 11369578496 1952233216 19.244 99 42 84 3 1979342144 15637680 11471248
19:23:37 27658 8192000000 10893010368 11355656192 1901940560 18.842 97 39 78 1 1924633856 12161264 10532032
19:24:12 33284 8192000000 10893403536 11352457216 1940407840 19.150 99 38 76 0 1964073440 13681488 9984112
19:25:09 22428 8192000000 10865551456 11318120448 1860910752 18.511 96 44 88 0 1884802176 11818608 12072816
19:25:38 30344 8192000000 10854323328 11317407744 1848951008 18.414 96 41 82 1 1875463408 14441312 12071088
19:26:30 43857 8192000000 10807353376 11257606144 1783124608 17.875 94 29 58 0 1801678816 10837520 7716688
19:27:25 14697 8192000000 9094878480 9304092672 255781408 3.027 14 3 6 0 262160880 5627552 751920

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 23-03-2021 19:28:49 to 23-03-2021 19:29:21.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 117 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 23-03-2021 19:29:22 to 23-03-2021 19:29:24.

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          235957
MON$OLDEST_ACTIVE               236265
MON$OLDEST_SNAPSHOT             236265
MON$NEXT_TRANSACTION            236265
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                       2037408
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33428 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33428 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33428 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33428 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

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

Database validation

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

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

--- start of diff output ---
:171: 
:172: mscs-test-161.budzdorov.ru    Tue Mar 23 19:27:53 2021
:173:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:174: 
:175: 
:176: mscs-test-161.budzdorov.ru    Tue Mar 23 19:27:53 2021
:177:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:178: 
--- end of diff output ---

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

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