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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-15 22:27:15
DTS_END                         2021-02-15 22:27:15.4990
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_ADDING_INVOICE(33:5) ==> SP_ADD_INVOICE_TO_STOCK(141:26) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/38772
TRN_ID                          242537
ATT_ID                          639
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: 9430.61 18205 1131673
customer order: creation 177.96 349 21355
customer order: refuse 14.79 343 1775
order to supplier: creation 46.97 1421 5636
order to supplier: removal 3.68 96937 442
invoice (draft): creation 46.90 3668 5628
invoice (draft): removal 53.88 787 6466
invoice accept: apply 42.95 17951 5154
invoice accept: cancel 48.83 903 5860
customer reserve: creation 3915.57 178 469868
customer reserve: removal 4779.73 58 573567
realization accept: apply 85.90 200 10308
realization accept: cancel 80.83 111 9699
payment from customer: creation 60.88 133 7306
payment from customer: removal 6.18 77 742
payment to supplier: creation 49.55 131 5946
payment to supplier: removal 3.47 88 416
service: total inventory turnovers 4.79 1208 575
service: total monetary turnovers 6.86 32 823
service: aggregate perf. data 0.86 17370 103
service: refresh index statistics 0.03 222158 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 15-02-2021 22:28:20 to 15-02-2021 22:28:22.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6245
TEST_TIME 2 5396
TEST_TIME 3 4943
TEST_TIME 4 5031
TEST_TIME 5 4930
TEST_TIME 6 5059
TEST_TIME 7 5668
TEST_TIME 8 6027
TEST_TIME 9 6106
TEST_TIME 10 6606
TEST_TIME 11 6668
TEST_TIME 12 7191
TEST_TIME 13 7535
TEST_TIME 14 7698
TEST_TIME 15 7529
TEST_TIME 16 7816
TEST_TIME 17 7802
TEST_TIME 18 7805
TEST_TIME 19 8027
TEST_TIME 20 8356
TEST_TIME 21 8742
TEST_TIME 22 8686
TEST_TIME 23 8694
TEST_TIME 24 8938
TEST_TIME 25 9315
TEST_TIME 26 9363
TEST_TIME 27 9582
TEST_TIME 28 10023
TEST_TIME 29 10214
TEST_TIME 30 10881
TEST_TIME 31 10717
TEST_TIME 32 10617
TEST_TIME 33 10477
TEST_TIME 34 10516
TEST_TIME 35 10487
TEST_TIME 36 10381
TEST_TIME 37 10274
TEST_TIME 38 10300
TEST_TIME 39 10334
TEST_TIME 40 10419
TEST_TIME 41 10492
TEST_TIME 42 10400
TEST_TIME 43 10240
TEST_TIME 44 10131
TEST_TIME 45 10016
TEST_TIME 46 9987
TEST_TIME 47 9999
TEST_TIME 48 10023
TEST_TIME 49 9980
TEST_TIME 50 9886
TEST_TIME 51 9933
TEST_TIME 52 9993
TEST_TIME 53 9914
TEST_TIME 54 9905
TEST_TIME 55 9767
TEST_TIME 56 9663
TEST_TIME 57 9847
TEST_TIME 58 9933
TEST_TIME 59 9866
TEST_TIME 60 9763
TEST_TIME 61 9712
TEST_TIME 62 9707
TEST_TIME 63 9708
TEST_TIME 64 9702
TEST_TIME 65 9732
TEST_TIME 66 9700
TEST_TIME 67 9772
TEST_TIME 68 9781
TEST_TIME 69 9787
TEST_TIME 70 9802
TEST_TIME 71 9757
TEST_TIME 72 9689
TEST_TIME 73 9926
TEST_TIME 74 9874
TEST_TIME 75 9908
TEST_TIME 76 9971
TEST_TIME 77 9932
TEST_TIME 78 9846
TEST_TIME 79 9790
TEST_TIME 80 9714
TEST_TIME 81 9734
TEST_TIME 82 9719
TEST_TIME 83 9743
TEST_TIME 84 9717
TEST_TIME 85 9690
TEST_TIME 86 9657
TEST_TIME 87 9598
TEST_TIME 88 9535
TEST_TIME 89 9537
TEST_TIME 90 9521
TEST_TIME 91 9528
TEST_TIME 92 9532
TEST_TIME 93 9532
TEST_TIME 94 9597
TEST_TIME 95 9595
TEST_TIME 96 9602
TEST_TIME 97 9576
TEST_TIME 98 9637
TEST_TIME 99 9668
TEST_TIME 100 9681
TEST_TIME 101 9647
TEST_TIME 102 9722
TEST_TIME 103 9725
TEST_TIME 104 9719
TEST_TIME 105 9667
TEST_TIME 106 9644
TEST_TIME 107 9631
TEST_TIME 108 9600
TEST_TIME 109 9574
TEST_TIME 110 9562
TEST_TIME 111 9530
TEST_TIME 112 9482
TEST_TIME 113 9513
TEST_TIME 114 9499
TEST_TIME 115 9500
TEST_TIME 116 9488
TEST_TIME 117 9490
TEST_TIME 118 9494
TEST_TIME 119 9510
TEST_TIME 120 9436

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 15-02-2021 22:28:23 to 15-02-2021 22:28:27.

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 1567124 1567124 0 0.00 0 19765 6 0 0
doc_list_biud 1567119 1567119 0 0.00 0 56587 27 0 0
sp_add_invoice_to_stock 5255 5154 101 1.92 37 181085 17951 0 101
sp_cancel_adding_invoice 5860 5860 0 0.00 4 66864 904 0 0
sp_cancel_client_order 1775 1775 0 0.00 3 11680 343 0 0
sp_cancel_customer_reserve 573567 573567 0 0.00 1 56588 58 0 0
sp_cancel_pay_from_customer 742 742 0 0.00 2 3686 77 0 0
sp_cancel_pay_to_supplier 416 416 0 0.00 3 3753 89 0 0
sp_cancel_supplier_invoice 6483 6466 17 0.26 2 38101 788 0 17
sp_cancel_supplier_order 442 442 0 0.00 7 861912 96938 0 0
sp_cancel_write_off 9699 9699 0 0.00 1 9100 112 0 0
sp_client_order 21355 21355 0 0.00 3 17458 350 0 0
sp_customer_reserve 469868 469868 0 0.00 0 33595 179 0 0
sp_fill_shopping_cart 32615 32615 0 0.00 1 19392 40 0 0
sp_fill_shopping_cart_clo_res 469862 469862 0 0.00 0 12363 12 0 0
sp_get_clo_for_invoice 5146 5146 0 0.00 0 26489 264 0 0
sp_kill_cost_storno 16717 16717 0 0.00 0 16224 61 0 0
sp_kill_qstorno_ret_qs2qd 1163741 1163741 0 0.00 0 55249 32 0 0
sp_kill_qty_storno 613263 613263 0 0.00 0 56587 69 0 0
sp_lock_selected_doc 21345 21345 0 0.00 0 11554 6 0 0
sp_make_cost_storno 28706 28706 0 0.00 0 16995 63 0 0
sp_multiply_rows_for_pdistr 28706 28706 0 0.00 0 6084 32 0 0
sp_multiply_rows_for_qdistr 21355 21355 0 0.00 0 17429 149 0 0
sp_pay_from_customer 7306 7306 0 0.00 4 14262 134 0 0
sp_pay_to_supplier 5946 5946 0 0.00 5 13182 132 0 0
sp_payment_common 13251 13251 0 0.00 1 14247 35 0 0
sp_qd_handle_on_cancel_clo 1775 1775 0 0.00 0 11672 313 0 0
sp_qd_handle_on_invoice_upd_sts 11006 11006 0 0.00 0 15973 361 0 0
sp_qd_handle_on_reserve_upd_sts 10308 10308 0 0.00 0 14726 57 0 0
sp_reserve_write_off 10308 10308 0 0.00 6 15510 200 0 0
sp_supplier_invoice 5628 5628 0 0.00 6 85843 3669 0 0
sp_supplier_order 5636 5636 0 0.00 5 25850 1422 0 0
srv_aggregate_perf_data 103 103 0 0.00 3128 219332 17370 0 0
srv_fill_mon_cache_memory 175 175 0 0.00 1161 173081 28492 0 0
srv_find_qd_qs_mism 1082992 1082992 0 0.00 0 9653 5 0 0
srv_make_invnt_saldo 575 575 0 0.00 38 67530 1209 0 0
srv_make_money_saldo 823 823 0 0.00 1 1240 33 0 0
srv_recalc_idx_stat 4 4 0 0.00 132225 285535 222159 0 0
t$perf-abend:sp_add_invoice_to_stock 101 101 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 17 17 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5154 5154 0 0.00 0 11716 168 0 0
t$perf-norm:sp_cancel_adding_invoice 418 418 0 0.00 0 12386 136 0 0
t$perf-norm:sp_cancel_client_order 1775 1775 0 0.00 0 4909 18 0 0
t$perf-norm:sp_cancel_customer_reserve 693 693 0 0.00 0 1728 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 742 742 0 0.00 0 936 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 416 416 0 0.00 0 11919 43 0 0
t$perf-norm:sp_cancel_supplier_invoice 407 407 0 0.00 0 487 9 0 0
t$perf-norm:sp_cancel_supplier_order 442 442 0 0.00 0 25682 1485 0 0
t$perf-norm:sp_cancel_write_off 999 999 0 0.00 0 5495 13 0 0
t$perf-norm:sp_client_order 21355 21355 0 0.00 0 29155 24 0 0
t$perf-norm:sp_customer_reserve 1043 1043 0 0.00 0 2729 8 0 0
t$perf-norm:sp_pay_from_customer 7306 7306 0 0.00 0 6658 11 0 0
t$perf-norm:sp_pay_to_supplier 5946 5946 0 0.00 0 4040 11 0 0
t$perf-norm:sp_reserve_write_off 10308 10308 0 0.00 0 6354 11 0 0
t$perf-norm:sp_supplier_invoice 5628 5628 0 0.00 0 2956 18 0 0
t$perf-norm:sp_supplier_order 5636 5636 0 0.00 0 8867 19 0 0
t$perf-norm:srv_aggregate_perf_data 103 103 0 0.00 0 150 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 175 175 0 0.00 0 701 13 0 0
t$perf-norm:srv_make_invnt_saldo 575 575 0 0.00 0 1623 28 0 0
t$perf-norm:srv_make_money_saldo 823 823 0 0.00 0 812 18 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 10492 10290 202 1.92 0 8926 19 0 202
v_all_customers 38384 38384 0 0.00 0 52 1 0 0
v_all_suppliers 31262 31262 0 0.00 0 95 1 0 0
v_all_wares 42708 42708 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 836 836 0 0.00 0 398 7 0 0
v_cancel_client_order 3550 3550 0 0.00 0 3292 6 0 0
v_cancel_customer_prepayment 1484 1484 0 0.00 0 3028 6 0 0
v_cancel_customer_reserve 1386 1386 0 0.00 0 1653 7 0 0
v_cancel_payment_to_supplier 832 832 0 0.00 0 1420 6 0 0
v_cancel_supplier_invoice 848 814 34 4.00 0 6862 26 0 34
v_cancel_supplier_order 884 884 0 0.00 0 3243 12 0 0
v_cancel_write_off 1998 1998 0 0.00 0 3292 16 0 0
v_max_id_clo_ord 5635 5635 0 0.00 0 5261 2 0 0
v_max_id_clo_res 1043 1043 0 0.00 0 1512 8 0 0
v_max_id_ord_sup 5626 5626 0 0.00 0 5536 3 0 0
v_max_non_paid_invoice 1576 1576 0 0.00 0 3714 7 0 0
v_max_non_paid_realizn 4062 4062 0 0.00 0 3558 6 0 0
v_min_id_clo_ord 5635 5635 0 0.00 0 6769 15 0 0
v_min_id_clo_res 1043 1043 0 0.00 0 2491 4 0 0
v_min_id_ord_sup 5626 5626 0 0.00 0 4753 7 0 0
v_min_non_paid_invoice 5946 5946 0 0.00 0 8043 21 0 0
v_min_non_paid_realizn 7305 7305 0 0.00 0 14241 23 0 0
v_our_firm 10810 10810 0 0.00 0 95 1 0 0
v_reserve_write_off 20616 20616 0 0.00 0 6815 7 0 0
x_lock_depdocs_on_canc_invoice 11919 11919 0 0.00 0 44960 141 0 0
x_lock_depdocs_on_canc_sup_ord 442 442 0 0.00 0 17654 379 0 0
x_make_qstorno_1000_1200 5636 5636 0 0.00 2 25844 1323 0 0
x_make_qstorno_1200_2000 5628 5628 0 0.00 3 85832 3540 0 0
x_make_qstorno_2100_3300 469868 469868 0 0.00 0 30309 164 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 15-02-2021 22:28:28 to 15-02-2021 22:28:32.

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:18 12 8192000000 8804695648 8816922624 8751472 0.106 3 1 2 0 8872176 58144 62560
19:57:25 18555 8192000000 10245842992 10555748352 984295360 10.726 76 53 107 0 1004401744 2848832 17257552
19:57:52 29090 8192000000 10338064112 10652483584 1378436368 14.403 100 87 174 0 1411572384 4782480 28353536
19:58:33 22595 8192000000 10380481792 10702438400 1430141904 14.863 100 85 170 0 1464705408 6808528 27754976
19:59:04 22022 8192000000 10409906448 10736574464 1466785504 15.186 100 93 186 0 1504298800 7937584 29575712
19:59:35 25717 8192000000 10427287888 10759790592 1491295728 15.400 100 91 182 0 1528742704 8520864 28926112
20:00:27 15158 8192000000 10447902384 10787000320 1499351648 15.471 100 86 172 1 1536634656 9383488 27899520
20:00:57 9063 8192000000 10466054448 10805460992 1522756320 15.674 100 87 174 0 1560088736 9701856 27630560
20:01:13 13587 8192000000 10474659456 10815692800 1530712400 15.743 100 87 174 2 1568354208 9893248 27748560
20:01:37 19009 8192000000 10500360048 10842664960 1544106336 15.859 100 91 182 1 1582785056 10385216 28293504
20:02:03 16756 8192000000 10516871696 10864619520 1567466816 16.060 100 84 168 0 1605020880 11222896 26331168
20:02:38 13275 8192000000 10535750624 10893586432 1593681904 16.285 100 74 148 1 1627482624 11189920 22610800
20:03:04 12567 8192000000 10569166816 10924584960 1622960720 16.535 100 81 162 1 1659089008 11820400 24307888
20:03:23 3159 8192000000 10567065040 10928775168 1631796448 16.610 100 81 160 3 1668121456 12223728 24101280
20:03:34 8786 8192000000 10591638320 10951086080 1644739024 16.720 100 82 164 0 1681804688 12743904 24321760
20:03:50 7568 8192000000 10603287168 10964897792 1662265408 16.868 100 81 162 0 1699833312 13745472 23822432
20:04:06 8236 8192000000 10619820640 10983006208 1676580640 16.989 100 82 163 3 1713474752 13136192 23757920
20:04:21 6405 8192000000 10628570720 10998734848 1693615776 17.132 100 82 162 3 1730213440 13325840 23271824
20:04:34 7611 8192000000 10637369680 11010064384 1701685968 17.199 100 76 153 0 1735774000 12332448 21755584
20:04:49 7404 8192000000 10651092624 11027181568 1716537232 17.323 100 86 169 1 1754018112 12753888 24726992
20:05:05 4576 8192000000 10679140032 11050172416 1735617088 17.482 100 85 167 2 1772052336 12490224 23945024
20:05:17 5947 8192000000 10671081168 11049115648 1738717472 17.508 100 75 150 1 1772504672 12501360 21285840
20:05:32 4133 8192000000 10692479840 11069038592 1751687664 17.616 100 82 160 2 1786723600 12183552 22852384
20:05:42 4526 8192000000 10694668112 11072413696 1756589184 17.656 100 78 156 1 1792844704 13488944 22766576
20:05:55 5607 8192000000 10703046272 11084288000 1766361664 17.737 100 75 147 2 1800075744 13089616 20624464
20:06:08 4848 8192000000 10718564736 11099705344 1777274928 17.827 100 89 179 1 1816235360 13656432 25304000
20:06:27 6303 8192000000 10727072272 11113414656 1790338848 17.935 100 74 148 4 1824278912 12959056 20981008
20:06:43 2563 8192000000 10746583792 11131179008 1814686272 18.134 100 92 183 2 1854366144 13328992 26350880
20:06:52 2588 8192000000 10754577616 11143286784 1819854080 18.176 100 90 178 0 1858806272 13504432 25447760
20:07:01 3755 8192000000 10772156864 11155873792 1826971792 18.235 100 88 175 0 1863510240 12443072 24095376
20:07:11 2546 8192000000 10773691888 11156721664 1829464432 18.255 100 82 165 2 1866453104 13718384 23270288
20:07:20 2621 8192000000 10783159968 11165687808 1836096944 18.309 100 87 174 1 1875023312 14302480 24623888
20:07:29 1401 8192000000 10780488064 11165839360 1846252368 18.392 100 94 189 2 1886874304 14589248 26032688
20:07:37 1808 8192000000 10790937648 11176816640 1851931792 18.438 100 92 183 2 1891707952 13450848 26325312
20:07:47 2077 8192000000 10794861280 11182551040 1852724048 18.444 100 86 174 0 1889901760 13104640 24073072
20:07:55 2223 8192000000 10804556256 11191083008 1859987184 18.503 100 85 170 1 1896004048 11865680 24151184
20:08:04 3718 8192000000 10805931824 11196628992 1867704112 18.566 100 95 190 0 1907853616 13397520 26751984
20:08:14 1998 8192000000 10815791408 11203203072 1867851872 18.567 100 93 187 0 1907863392 13525984 26485536
20:08:23 1793 8192000000 10815849680 11203887104 1871008800 18.592 100 95 190 2 1911657408 12727008 27921600
20:08:31 1516 8192000000 10822653136 11210313728 1874801200 18.623 100 95 192 3 1914455104 12610288 27043616
20:08:39 1372 8192000000 10816478848 11204878336 1877170768 18.642 100 91 183 2 1915593184 13454800 24967616
20:08:47 36579 8192000000 10792687840 11205300224 1874252896 18.619 100 60 120 1 1901699920 10508608 16938416
20:09:30 1223 8192000000 10828580016 11224006656 1888432080 18.733 100 89 179 0 1924156160 9874976 25849104
20:09:38 8267 8192000000 10817481872 11222949888 1884571728 18.702 100 56 112 1 1910157280 10427744 15157808
20:09:52 10910 8192000000 10799433632 11220353024 1886922672 18.721 100 51 102 3 1910283152 9832928 13527552
20:10:12 5993 8192000000 10797125376 11215462400 1882709920 18.687 100 32 64 0 1897347056 5977280 8659856
20:10:24 5594 8192000000 10801836704 11225337856 1884705264 18.703 100 26 52 1 1899343456 7582960 7055232
20:10:37 5166 8192000000 10808417984 11226120192 1887595248 18.726 100 36 71 0 1904943664 6570752 10777664
20:10:49 6793 8192000000 10792689072 11223588864 1885355520 18.708 100 20 40 2 1897025456 6085168 5584768
20:11:02 9309 8192000000 10799470400 11225772032 1888447360 18.733 100 21 42 1 1899973888 5837168 5689360
20:11:18 7900 8192000000 10799781072 11225927680 1890729904 18.752 100 25 50 1 1903750128 5941232 7078992
20:11:34 6861 8192000000 10800956560 11231309824 1895592096 18.791 100 20 41 3 1905698352 5277024 4829232
20:11:48 6839 8192000000 10806606896 11235659776 1895821248 18.793 100 22 44 0 1908666080 6735824 6109008
20:12:03 7023 8192000000 10808798096 11244736512 1901060880 18.835 100 23 44 0 1917172800 10484992 5626928
20:12:16 13104 8192000000 10810859200 11251453952 1905397520 18.870 100 20 40 0 1921133520 10201280 5534720
20:12:36 7182 8192000000 10818471440 11250663424 1907898656 18.890 100 22 45 3 1919855408 5901904 6054848
20:12:52 8048 8192000000 10816010832 11249160192 1910544448 18.911 100 20 40 1 1923273936 7003152 5726336
20:13:06 6494 8192000000 10811775904 11252936704 1910535584 18.911 100 14 28 2 1920030432 5826400 3668448
20:13:22 18964 8192000000 10823956560 11253710848 1916113520 18.956 100 32 63 1 1930786656 5368992 9304144
20:13:48 66552 8192000000 10829318064 11268182016 1918387136 18.974 100 34 65 1 1933142320 5764400 8990784
20:15:03 6507 8192000000 10832488208 11270316032 1920114688 18.988 100 25 50 1 1934075584 6894784 7066112
20:15:17 5978 8192000000 10832450816 11271548928 1921894896 19.002 100 25 50 0 1934816816 5574992 7346928
20:15:30 7389 8192000000 10837010880 11271565312 1920651088 18.992 100 21 43 0 1932327504 5769968 5906448
20:15:46 4728 8192000000 10857624496 11278782464 1923355936 19.014 100 33 66 0 1940247456 7368688 9522832
20:15:58 7375 8192000000 10835676960 11275874304 1921410960 18.998 100 18 36 1 1931612016 4941136 5259920
20:16:11 6703 8192000000 10834935040 11271417856 1901301792 18.837 99 15 30 1 1911351664 5593216 4456656
20:16:24 7571 8192000000 10817468880 11249836032 1874010816 18.617 98 25 50 0 1887824208 6439280 7374112
20:16:39 8968 8192000000 10797910464 11228807168 1850973504 18.430 97 25 50 0 1864410944 5858384 7579056
20:16:55 10936 8192000000 10795462272 11225374720 1862123712 18.520 98 25 52 2 1875106560 5876752 7106096
20:17:16 5485 8192000000 10790515632 11224371200 1864277920 18.538 99 20 40 1 1875262368 5073520 5910928
20:17:29 9858 8192000000 10787540176 11216678912 1855683968 18.468 98 32 63 3 1870455216 5961504 8809744
20:17:48 8002 8192000000 10770336176 11198095360 1797232096 17.991 95 24 47 1 1810249104 6250880 6766128
20:18:06 7375 8192000000 10772290800 11195637760 1810285520 18.098 97 18 35 0 1820448832 5245376 4917936
20:18:20 9149 8192000000 10777069968 11206438912 1860804720 18.510 100 14 28 1 1870130896 5689616 3636560
20:18:38 59151 8192000000 10760657536 11158294528 1724159712 17.387 92 34 65 3 1738172960 4379600 9633648
20:19:46 16420 8192000000 10706620640 11128926208 1711487680 17.281 94 15 30 1 1720676672 4987248 4201744
20:20:09 8186 8192000000 10706099024 11121209344 1732628720 17.457 96 25 50 0 1746230960 6548000 7054240
20:20:24 7578 8192000000 10705447120 11126530048 1779615472 17.846 99 16 32 0 1789800720 5630704 4554544
20:20:39 6268 8192000000 10724228128 11141840896 1787423248 17.911 99 22 44 1 1799587696 5368560 6795888
20:20:52 4075 8192000000 10723830816 11137843200 1793675040 17.962 99 36 72 2 1811142880 7190624 10277216
20:21:03 6627 8192000000 10741698784 11158376448 1822134688 18.195 100 30 61 0 1838296944 7233024 8929232
20:21:17 8683 8192000000 10722934912 11145158656 1773277456 17.794 97 20 40 0 1788593408 10125328 5190624
20:21:31 6537 8192000000 10726825344 11146756096 1767275264 17.745 97 20 40 2 1778137840 4885248 5977328
20:21:45 12684 8192000000 10722987808 11143290880 1780832688 17.856 98 25 50 2 1793673904 5682736 7158480
20:22:05 5360 8192000000 10700987552 11114479616 1756071312 17.652 98 19 38 0 1766591808 5510288 5010208
20:22:18 11340 8192000000 10722831440 11144634368 1801167904 18.023 100 24 48 0 1813633312 5420944 7044464
20:22:36 8165 8192000000 10726776096 11150491648 1786636176 17.904 98 27 51 0 1799849760 4928816 8284768
20:22:50 9156 8192000000 10733280176 11160584192 1812319200 18.115 99 19 38 3 1823682976 5393744 5970032
20:23:06 12021 8192000000 10764783264 11177377792 1815330880 18.140 99 28 56 1 1834417344 9946528 9139936
20:23:24 14099 8192000000 10741821312 11164155904 1799107440 18.007 98 26 52 2 1812744240 4807760 8829040
20:23:44 54633 8192000000 10770404400 11185565696 1842984176 18.365 100 31 61 2 1857283648 5182128 9117344
20:24:52 23355 8192000000 10768506640 11196375040 1853985136 18.454 100 30 61 0 1867166960 5245920 7935904
20:25:21 7489 8192000000 10769875616 11198418944 1857483600 18.483 100 34 68 0 1873502736 6988576 9030560
20:25:40 10915 8192000000 10785576656 11208089600 1862328720 18.522 100 28 57 1 1876990672 6686144 7975808
20:25:58 6250 8192000000 10783222992 11209023488 1864447424 18.539 100 28 56 1 1879619136 6561408 8610304
20:26:10 6609 8192000000 10784397792 11211091968 1866170064 18.553 100 31 62 2 1881053184 5737072 9146048
20:26:24 7323 8192000000 10788587616 11212324864 1869223808 18.578 100 29 56 4 1883270752 6254464 7792480
20:26:41 11866 8192000000 10778813696 11213271040 1867837856 18.567 100 13 26 1 1877020256 5096240 4086160
20:27:01 11496 8192000000 10798786608 11229474816 1878132880 18.650 100 14 28 1 1886356272 5027680 3195712
20:27:21 32633 8192000000 10836160752 11247878144 1898892544 18.817 100 35 69 2 1916108528 6242160 10973824
20:28:13 8869 8192000000 10843993808 11256274944 1912981168 18.931 100 54 108 2 1936495600 8338688 15175744
20:28:29 2619 8192000000 10861290032 11274067968 1920520048 18.991 100 56 108 1 1947119264 10867376 15731840
20:28:38 4233 8192000000 10857133424 11275575296 1924649376 19.024 100 61 122 1 1952756592 10883440 17223776
20:28:51 38354 8192000000 10870032544 11289579520 1928944080 19.058 100 60 120 0 1958468000 12729936 16793984
20:29:44 51615 8192000000 10859906352 11292000256 1935366384 19.110 100 47 90 2 1960555632 11781968 13407280
20:30:46 47825 8192000000 10860065328 11308195840 1939072832 19.139 100 32 62 2 1961212192 11930512 10208848
20:31:50 33894 8192000000 10886363312 11326263296 1948521408 19.215 100 32 62 1 1977966800 20049728 9395664
20:32:39 20857 8192000000 10897075120 11328561152 1957789872 19.288 100 35 70 2 1981617200 13504640 10322688
20:33:12 13451 8192000000 10901039664 11333087232 1964087072 19.339 100 42 84 0 1992254304 15680768 12486464
20:33:32 2993 8192000000 10919610000 11341062144 1974276368 19.419 100 68 137 3 2012298176 16802080 21219728
20:33:43 9042 8192000000 10922140480 11348779008 1977566960 19.445 100 67 133 3 2015034944 17932448 19535536
20:34:01 8668 8192000000 10917180048 11348045824 1978046896 19.449 100 58 116 1 2010794224 14890864 17856464
20:34:18 11222 8192000000 10926332400 11354529792 1982827024 19.487 100 63 124 1 2017607600 16026336 18754240
20:34:36 11813 8192000000 10924769280 11355439104 1980563056 19.469 100 58 116 0 2013842656 16139424 17140176
20:34:58 6573 8192000000 10932829072 11358560256 1983870272 19.495 100 49 95 0 2012962288 15473152 13618864
20:35:17 8349 8192000000 10928188784 11356418048 1971050848 19.394 99 55 108 1 2002626144 15391312 16183984
20:35:33 11250 8192000000 10913536912 11349422080 1963386768 19.333 99 50 99 0 1995078912 15903920 15788224
20:36:03 8328 8192000000 10927444656 11353927680 1979576240 19.461 100 67 135 1 2015788720 15920640 20291840
20:36:18 2208 8192000000 10943190400 11355234304 1982458288 19.484 100 80 157 1 2023991264 18139056 23393920
20:36:28 10789 8192000000 10935074480 11361820672 1983183680 19.490 100 71 142 2 2024047888 19169216 21694992
20:37:04 7078 8192000000 10942482080 11368304640 1987795856 19.526 100 52 103 1 2024082064 20897888 15388320
20:37:19 2215 8192000000 10952424000 11373764608 1993498656 19.571 100 78 157 0 2038405888 21558688 23348544
20:37:28 2660 8192000000 10946643936 11372777472 1993018256 19.568 100 82 164 3 2039004448 21584016 24402176
20:37:40 5417 8192000000 10950202880 11378315264 1993676736 19.573 100 71 140 1 2036104624 22353728 20074160
20:37:54 2817 8192000000 10936483952 11365007360 1980027504 19.465 99 77 151 3 2024253088 21219088 23006496
20:38:04 9790 8192000000 10935226496 11356934144 1973543840 19.414 99 66 132 2 2014668048 21412704 19711504
20:38:21 3981 8192000000 10935316992 11348127744 1967711280 19.367 99 83 165 0 2015356032 22615936 25028816
20:38:32 10654 8192000000 10944000176 11373305856 1985962544 19.512 100 64 128 4 2027748016 22208048 19577424
20:38:53 3471 8192000000 10927440176 11355828224 1973189504 19.411 99 59 118 1 2015401488 24266208 17945776
20:39:03 3413 8192000000 10944995056 11362631680 1979634624 19.462 100 74 146 1 2026596320 24806832 22154864
20:39:17 1899 8192000000 10944592912 11359911936 1974379344 19.420 100 80 161 1 2024394976 25687728 24327904
20:39:25 8445 8192000000 10919614352 11335106560 1932403248 19.086 98 67 132 2 1978558240 26306944 19848048
20:39:52 7227 8192000000 10919315936 11347382272 1940167712 19.148 99 69 139 3 1992818256 31499184 21151360
20:40:08 4470 8192000000 10914405792 11340963840 1954532672 19.263 100 53 104 1 1994276080 23657680 16085728
20:40:20 3289 8192000000 10907793344 11331866624 1921536336 18.999 98 60 120 4 1963034992 23296192 18202464
20:40:31 9372 8192000000 10908301232 11332743168 1944142960 19.180 100 64 127 3 1988124000 25074736 18906304
20:40:50 5401 8192000000 10906716656 11335626752 1949108048 19.219 100 62 123 3 1992144160 23953376 19082736
20:41:02 4199 8192000000 10919173392 11343736832 1955456256 19.270 100 80 158 1 2002772912 24347712 22968944
20:41:14 1161 8192000000 10922092624 11339915264 1959928320 19.305 100 83 167 0 2008053968 23132896 24992752
20:41:22 5336 8192000000 10914752448 11340353536 1957963408 19.290 100 72 144 2 2002558016 23234432 21360176
20:41:36 1438 8192000000 10924166688 11352563712 1969862208 19.384 100 69 137 0 2011901840 21950304 20089328
20:41:46 6369 8192000000 10923254576 11356360704 1970381664 19.388 100 50 99 0 2007246128 22510624 14353840
20:41:59 7811 8192000000 10927624096 11359309824 1972794112 19.408 100 58 116 2 2013344864 23038448 17512304
20:42:16 2653 8192000000 10930736112 11362451456 1975182032 19.427 100 58 116 1 2014905632 22588944 17134656
20:42:27 7560 8192000000 10915295616 11335618560 1947533328 19.207 99 74 143 1 1992445696 23067760 21844608
20:42:48 7811 8192000000 10929221856 11350151168 1950861312 19.233 99 68 134 1 1996472896 25514416 20097168
20:43:02 4610 8192000000 10942260176 11360333824 1970866704 19.392 100 79 157 0 2021232816 26648432 23717680
20:43:22 6051 8192000000 10924722080 11353247744 1958184992 19.292 99 69 135 3 2005959840 26237200 21537648
20:43:36 2406 8192000000 10933898576 11355754496 1970723568 19.391 100 75 149 2 2017337280 23960864 22652848
20:43:46 4028 8192000000 10923533152 11352322048 1962926288 19.329 100 73 146 1 2013234224 28393232 21914704
20:43:57 11434 8192000000 10903102096 11338551296 1922096896 19.004 98 36 72 3 1959194368 25813280 11284192
20:44:27 5573 8192000000 10910429952 11343200256 1941813328 19.161 99 47 94 1 1984032736 27801920 14417488
20:44:40 3944 8192000000 10916566448 11337588736 1913098928 18.932 98 70 140 1 1970023712 36020800 20903984
20:44:52 3964 8192000000 10923761744 11339988992 1948054928 19.211 100 74 148 2 2006076176 35093456 22927792
20:45:03 3445 8192000000 10924794320 11340582912 1948758592 19.217 100 74 148 0 2006588768 35111120 22719056
20:45:15 2724 8192000000 10909954944 11324207104 1919609504 18.984 99 68 133 0 1973890128 33733520 20547104
20:45:26 3832 8192000000 10922819280 11337621504 1948809776 19.217 100 85 169 2 2008705008 34255280 25639952
20:45:38 4825 8192000000 10945705104 11359113216 1967111904 19.363 100 84 169 0 2028859920 35718624 26029392
20:45:54 3952 8192000000 10932432896 11350581248 1956028224 19.274 100 70 139 2 2012778032 35114368 21635440
20:46:08 1893 8192000000 10944388192 11353583616 1951683312 19.240 99 85 168 1 2017133552 38248864 27201376
20:46:17 3814 8192000000 10914685744 11317751808 1922602992 19.008 99 82 158 2 1986718512 38648976 25466544
20:46:29 4946 8192000000 10936668768 11337097216 1937036544 19.123 100 81 162 1 2003885696 40784992 26064160
20:46:41 2101 8192000000 10918541008 11328049152 1925904608 19.034 99 87 169 1 1993737280 41055488 26777184
20:46:50 2260 8192000000 10932848896 11342282752 1944744832 19.185 100 84 166 0 2011630128 41167984 25717312
20:47:00 2950 8192000000 10942703664 11347013632 1949491504 19.222 100 87 175 2 2019283872 42100672 27691696
20:47:10 2996 8192000000 10941899952 11353292800 1952617520 19.247 100 79 155 0 2019789968 42846768 24325680
20:47:20 6210 8192000000 10935363552 11346870272 1949964464 19.226 100 66 131 3 2012228496 42148048 20115984
20:47:34 5105 8192000000 10925825088 11356528640 1955041024 19.267 100 58 116 1 2016554464 43733184 17780256
20:47:52 6628 8192000000 10921965264 11348267008 1943100576 19.171 100 60 120 1 2006009696 43761344 19147776
20:48:11 4679 8192000000 10908275376 11326758912 1930087680 19.068 99 65 130 3 1992065872 40297072 21681120
20:48:22 3254 8192000000 10950422144 11353489408 1953649872 19.256 100 81 162 2 2019664464 39972672 26041920
20:48:34 2174 8192000000 10951018176 11357945856 1959251680 19.300 100 86 171 1 2028691504 42000656 27439168
20:48:43 1941 8192000000 10948617680 11359903744 1963157936 19.331 100 76 152 1 2028612976 41140832 24314208
20:48:54 5119 8192000000 10920468992 11359285248 1961781056 19.320 100 45 90 2 2014840672 38879984 14179632
20:49:14 9922 8192000000 10921768896 11352559616 1941621248 19.160 99 39 78 1 1992770672 38031200 13118224
20:49:31 12415 8192000000 10917173536 11354755072 1944092880 19.179 99 38 76 0 1994225344 37590288 12542176
20:49:53 4569 8192000000 10953306816 11364343808 1968991984 19.377 100 62 122 0 2027808032 39332448 19483600
20:50:05 2690 8192000000 10961278672 11373981696 1974694080 19.423 100 81 161 0 2040407504 39743536 25969888
20:50:17 1759 8192000000 10982312032 11388657664 1982328240 19.483 100 93 186 0 2053716352 41854656 29533456
20:50:25 1340 8192000000 10978193216 11394650112 1987810832 19.526 100 81 160 0 2059552768 45786864 25955072
20:50:35 4466 8192000000 10967061568 11396632576 1990568832 19.548 100 64 127 4 2056888288 45377344 20942112
20:50:52 3558 8192000000 10966677984 11391758336 1983108288 19.489 100 52 104 0 2045791600 45585312 17098000
20:51:13 11361 8192000000 10950617712 11392671744 1976552352 19.437 100 34 68 0 2038494800 49841312 12101136
20:51:34 9059 8192000000 10937432640 11380064256 1963407248 19.333 100 36 72 3 2023147888 46863760 12876880
20:51:54 12397 8192000000 10938633216 11381575680 1966510864 19.358 100 35 70 0 2026099296 47207968 12380464
20:52:19 14818 8192000000 10936111744 11378679808 1961564064 19.318 100 36 72 1 2021702464 47896384 12242016
20:52:41 36450 8192000000 10896816288 11334217728 1921246368 18.997 98 31 62 3 1981503856 48524432 11733056
20:53:25 20988 8192000000 10912155568 11359170560 1938426128 19.134 100 28 56 1 1997647776 48248560 10973088
20:53:53 28934 8192000000 10910911424 11375370240 1938296464 19.133 100 27 54 1 1999723184 51255472 10171248
20:54:39 14600 8192000000 10925312112 11375276032 1938565440 19.135 100 37 74 3 2006065360 55260096 12239824
20:55:02 22578 8192000000 10930715344 11371331584 1953117168 19.251 100 37 74 1 2005373248 39382864 12873216
20:55:40 2649 8192000000 10927828208 11360575488 1947568240 19.207 100 57 113 1 2007437200 42295488 17573472
20:55:49 6402 8192000000 10918389872 11370651648 1950403408 19.230 100 40 79 2 2004294928 41624336 12267184
20:56:04 32184 8192000000 10894540096 11357814784 1945556208 19.191 100 25 50 2 1986659648 32883264 8220176
20:56:53 17519 8192000000 10889721344 11356999680 1941765968 19.161 100 16 32 1 1973619328 26910000 4943360
20:57:21 20797 8192000000 10861792000 11343142912 1916026912 18.955 99 11 22 1 1946538208 27094416 3416880
20:57:53 51481 8192000000 10867232016 11328761856 1922030448 19.003 99 19 36 0 1943139552 15925040 5184064
20:58:51 85608 8192000000 10898183232 11328311296 1882339312 18.684 97 12 24 0 1900843824 14309664 4194848
21:00:23 52831 8192000000 10890589120 11343896576 1939884672 19.146 99 33 67 2 1959787760 9862048 10041040
21:01:22 110948 8192000000 10889051552 11358433280 1925984832 19.035 98 10 20 0 1941401856 12546640 2870384
21:03:36 74491 8192000000 10906404352 11353374720 1929885664 19.066 98 30 60 1 1951248800 12594944 8768192
21:05:08 38088 8192000000 10904564496 11368361984 1965413680 19.349 100 20 39 0 1990845328 19476576 5955072
21:05:55 73875 8192000000 10911524128 11375857664 1956286064 19.277 99 21 42 1 1977734704 15069104 6379536
21:07:19 98151 8192000000 10924193792 11394002944 1958514960 19.294 99 5 10 0 1977068688 17616144 937584
21:09:05 44228 8192000000 10909372128 11368480768 1942570016 19.167 98 15 30 1 1955750592 9147472 4033104
21:10:03 127160 8192000000 10926209488 11380420608 1962847664 19.329 99 33 67 3 1983676640 8970912 11858064
21:12:24 13040 8192000000 10930555936 11377774592 1969160304 19.379 99 46 92 1 1994409328 11386880 13862144
21:12:52 31553 8192000000 10954983488 11393388544 1989239600 19.538 100 57 114 1 2026581792 20201888 17140304
21:13:31 102213 8192000000 10923347760 11404181504 1979527584 19.461 100 23 46 0 2010924928 24830080 6567264
21:15:20 9318 8192000000 10910883104 11408703488 1979277984 19.459 100 3 6 0 2002823424 22657936 887504
21:15:48 13100 8192000000 10918588944 11387932672 1990170400 19.545 100 35 67 3 2010021744 10302816 9548528
21:16:14 13146 8192000000 10910741264 11373301760 1969338064 19.380 99 22 44 1 1985981776 10217584 6426128
21:16:46 24157 8192000000 10930230208 11388297216 1978998384 19.457 99 22 44 2 1998226368 12244432 6983552
21:17:19 32472 8192000000 10941251472 11395805184 1987360896 19.523 99 51 100 0 2018673472 16236672 15075904
21:17:59 26655 8192000000 10940977552 11401256960 2002856336 19.645 100 48 96 2 2029592192 13043616 13692240
21:18:47 30838 8192000000 10921301488 11399520256 1960331888 19.309 98 33 68 1 1985277792 14900880 10045024
21:20:35 50333 8192000000 10900628768 11373940736 1931269152 19.077 97 9 18 0 1952274736 18155840 2849744
21:21:52 28780 8192000000 10925379680 11395133440 1984466800 19.500 100 18 36 0 2007578608 17822080 5289728
21:23:04 52059 8192000000 10936541824 11408654336 1992221968 19.561 100 19 38 1 2020115888 22044320 5849600
21:24:09 53851 8192000000 10920110080 11407769600 1988311968 19.530 100 14 28 0 2010744912 18001520 4431424
21:25:11 36530 8192000000 10895531344 11379073024 1945401392 19.190 98 15 30 2 1968601248 19065744 4134112
21:25:54 32646 8192000000 10884102528 11351773184 1926279328 19.037 98 21 43 1 1940495584 8197376 6018880
21:26:59 43132 8192000000 10877156352 11355361280 1928870624 19.058 98 13 26 0 1941520576 8898960 3750992
21:27:56 58032 8192000000 10884667232 11374620672 1964117840 19.339 100 10 20 1 1975374576 8688688 2568048
21:29:23 72553 8192000000 10880462416 11364241408 1897943408 18.810 96 14 28 1 1912904592 11390224 3570960
21:30:42 53387 8192000000 10874884368 11351515136 1878841232 18.656 95 13 26 0 1894243104 11388096 4013776
21:31:42 45605 8192000000 10876892320 11356274688 1903936704 18.858 97 34 68 3 1926013344 12042704 10033936
21:32:33 30863 8192000000 10902544848 11362029568 1925419648 19.030 98 33 66 2 1944736208 10249888 9066672
21:33:10 15489 8192000000 10898218208 11361071104 1957614400 19.287 100 42 82 0 1984896432 16240752 11041280
21:34:15 41211 8192000000 10873711120 11349745664 1915933920 18.954 98 26 52 2 1941382576 18305744 7142912
21:35:05 46242 8192000000 10874860336 11339853824 1887643088 18.727 97 12 24 0 1902979440 12292288 3044064
21:35:58 95751 8192000000 10873343120 11352928256 1895312000 18.789 97 23 46 0 1913245696 11980384 5953312
21:37:41 52540 8192000000 10897303968 11372064768 1925750336 19.033 98 19 38 1 1948125232 16850832 5524064
21:38:47 72815 8192000000 10865298352 11332382720 1867196000 18.562 95 13 25 1 1896059344 24887056 3976288
21:40:06 37634 8192000000 10879522624 11359371264 1938439328 19.134 100 14 28 0 1966944112 24041728 4463056
21:41:01 26857 8192000000 10896327872 11356790784 1928652480 19.056 98 29 58 1 1951905568 15214096 8038992
21:41:40 43001 8192000000 10890212368 11340181504 1882131536 18.682 96 38 72 2 1907404048 15401872 9870640
21:42:34 41722 8192000000 10872052768 11349921792 1916399232 18.958 99 23 46 0 1944459376 21326816 6733328
21:43:31 84472 8192000000 10874048784 11347791872 1929303680 19.061 99 7 14 0 1949372704 18252976 1816048
21:45:06 85724 8192000000 10888746720 11358109696 1937092752 19.124 99 22 44 1 1950236944 6728032 6416160
21:46:40 57083 8192000000 10849554272 11312267264 1900319584 18.829 97 25 50 0 1916546224 9462864 6763776
21:47:44 19839 8192000000 10853397296 11315474432 1902844704 18.849 98 28 55 2 1921249760 10991472 7413584
21:49:11 100269 8192000000 10845212736 11332104192 1893094608 18.771 98 9 18 0 1913574656 17917568 2562480
21:51:03 45093 8192000000 10844534560 11306745856 1891901328 18.761 98 12 24 0 1903842080 8857760 3082992
21:51:55 66556 8192000000 10872821808 11354267648 1948292864 19.213 100 22 44 0 1962075216 7545776 6236576
21:54:57 51336 8192000000 10893865728 11354038272 1943303088 19.173 99 38 76 1 1962045264 8175344 10566832
21:55:57 37034 8192000000 10852716000 11335766016 1912327040 18.925 98 13 25 0 1927785376 12278032 3180304
21:56:40 56771 8192000000 10875656320 11356901376 1947352192 19.205 100 9 18 0 1958105440 8331088 2422160
21:58:32 58558 8192000000 10907774544 11403993088 1988197392 19.530 100 28 56 1 2007795824 11627200 7971232
21:59:36 30841 8192000000 10910055760 11379408896 1949684080 19.224 98 18 36 2 1965234560 10601168 4949312
22:00:19 49814 8192000000 10906794944 11383672832 1957965744 19.290 99 25 50 1 1982425440 17745072 6714624
22:01:15 59474 8192000000 10905822752 11369807872 1932973328 19.091 98 24 48 1 1959098624 19160848 6964448
22:02:24 43551 8192000000 10894090880 11363586048 1938950736 19.138 98 36 72 1 1960991728 11865744 10175248
22:03:20 55661 8192000000 10907189552 11379249152 1970420576 19.389 100 30 60 0 1990520560 11546512 8553472
22:04:34 24505 8192000000 10942610272 11390058496 1986326128 19.515 100 60 119 1 2018401888 14872352 17203408
22:05:10 173080 8192000000 10904640336 11392131072 1909098208 18.899 96 20 40 0 1926392016 12031952 5261856
22:08:10 48085 8192000000 10913740416 11387035648 1966663360 19.359 99 20 38 2 1983054080 10925072 5465648
22:09:08 70260 8192000000 10890311904 11371065344 1919872240 18.986 97 13 26 0 1938375024 15127280 3375504
22:10:25 90640 8192000000 10898910752 11364798464 1887126864 18.723 95 37 73 1 1909352544 12488000 9737680
22:12:09 97920 8192000000 10861121680 11324014592 1875940928 18.632 95 24 48 0 1889585696 6709920 6934848
22:13:59 66165 8192000000 10880372112 11358990336 1926729792 19.041 98 16 31 0 1942266128 10673072 4863264
22:15:15 2970 8192000000 10890130048 11364040704 1961550112 19.318 100 24 47 2 1975624064 8087552 5986400
22:15:24 23322 8192000000 10911479632 11372466176 1965270864 19.348 100 21 42 1 1980126432 8635216 6220352
22:15:54 22598 8192000000 10876326512 11356049408 1955253792 19.268 99 28 54 1 1970176224 7465920 7456512
22:16:26 87124 8192000000 10882113424 11371048960 1938283056 19.133 98 9 18 0 1951359024 10328400 2747568
22:19:16 66777 8192000000 10852699424 11341672448 1920165344 18.988 99 13 26 0 1937197376 13332048 3699984
22:20:38 23946 8192000000 10849536576 11344711680 1917570960 18.967 99 12 24 0 1932304192 11423920 3309312
22:21:08 38928 8192000000 10856734352 11345534976 1917678496 18.968 99 9 18 1 1929261648 9136336 2446816
22:21:58 34422 8192000000 10843012864 11322646528 1826705264 18.232 94 4 8 0 1836031056 8283312 1042480
22:22:51 76865 8192000000 10870625312 11344543744 1888722960 18.735 97 18 35 2 1902966016 9134448 5108608
22:24:19 62524 8192000000 10862033296 11326849024 1831670816 18.273 94 32 64 2 1849384704 8353520 9360368
22:25:28 32953 8192000000 10864804080 11330576384 1872504960 18.605 97 20 40 0 1889648880 11445360 5698560
22:26:11 45749 8192000000 10870022304 11339796480 1917657936 18.968 99 21 42 2 1936111504 12288352 6165216
22:27:03 20632 8192000000 9372939744 9669038080 523118512 6.002 28 7 12 1 533099776 7916096 2065168

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:34, from 15-02-2021 22:28:33 to 15-02-2021 22:29:07.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 101 v_add_invoice_to_stock 335544517
except 17 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 15-02-2021 22:29:07 to 15-02-2021 22:29:09.

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          242832
MON$OLDEST_ACTIVE               242833
MON$OLDEST_SNAPSHOT             242833
MON$NEXT_TRANSACTION            242833
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                       2045856
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.33415 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33415 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33415 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33415 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 ---
:444: 
:445: mscs-test-161.budzdorov.ru    Mon Feb 15 22:27:26 2021
:446:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:447: 
:448: 
:449: mscs-test-161.budzdorov.ru    Mon Feb 15 22:27:26 2021
:450:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:451: 
--- end of diff output ---

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

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