Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 12.03.2021 01: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 17483056 kB
MemAvailable 31596256 kB
Buffers 0 kB
Cached 14201660 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-12 01:27:21
DTS_END                         2021-03-12 01:27:21.5880
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/60978
TRN_ID                          235409
ATT_ID                          608
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: 9255.57 19376 1110668
customer order: creation 170.28 330 20433
customer order: refuse 13.93 352 1671
order to supplier: creation 44.53 1236 5344
order to supplier: removal 3.57 93478 428
invoice (draft): creation 44.68 3390 5362
invoice (draft): removal 52.33 726 6280
invoice accept: apply 40.50 17367 4860
invoice accept: cancel 47.48 700 5698
customer reserve: creation 3842.54 168 461105
customer reserve: removal 4703.84 56 564461
realization accept: apply 82.59 149 9911
realization accept: cancel 84.95 106 10194
payment from customer: creation 56.76 102 6811
payment from customer: removal 5.61 71 673
payment to supplier: creation 46.93 114 5632
payment to supplier: removal 3.34 61 401
service: total inventory turnovers 4.77 1117 572
service: total monetary turnovers 6.04 59 725
service: aggregate perf. data 0.86 15424 103
service: refresh index statistics 0.03 252516 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 12-03-2021 01:28:47 to 12-03-2021 01:28:49.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3335
TEST_TIME 2 5107
TEST_TIME 3 4817
TEST_TIME 4 5062
TEST_TIME 5 5203
TEST_TIME 6 5080
TEST_TIME 7 5285
TEST_TIME 8 5299
TEST_TIME 9 5773
TEST_TIME 10 6463
TEST_TIME 11 6474
TEST_TIME 12 6394
TEST_TIME 13 6342
TEST_TIME 14 6417
TEST_TIME 15 6670
TEST_TIME 16 7120
TEST_TIME 17 7372
TEST_TIME 18 8293
TEST_TIME 19 8196
TEST_TIME 20 8524
TEST_TIME 21 8952
TEST_TIME 22 9558
TEST_TIME 23 9683
TEST_TIME 24 10058
TEST_TIME 25 10267
TEST_TIME 26 10370
TEST_TIME 27 10929
TEST_TIME 28 10942
TEST_TIME 29 10683
TEST_TIME 30 10640
TEST_TIME 31 10720
TEST_TIME 32 10405
TEST_TIME 33 10440
TEST_TIME 34 10430
TEST_TIME 35 10404
TEST_TIME 36 10190
TEST_TIME 37 10109
TEST_TIME 38 10207
TEST_TIME 39 10150
TEST_TIME 40 10229
TEST_TIME 41 10058
TEST_TIME 42 9960
TEST_TIME 43 9880
TEST_TIME 44 9886
TEST_TIME 45 9699
TEST_TIME 46 9674
TEST_TIME 47 9593
TEST_TIME 48 9559
TEST_TIME 49 9496
TEST_TIME 50 9462
TEST_TIME 51 9437
TEST_TIME 52 9425
TEST_TIME 53 9430
TEST_TIME 54 9535
TEST_TIME 55 9546
TEST_TIME 56 9639
TEST_TIME 57 9803
TEST_TIME 58 9757
TEST_TIME 59 9722
TEST_TIME 60 9807
TEST_TIME 61 9872
TEST_TIME 62 9902
TEST_TIME 63 9979
TEST_TIME 64 9869
TEST_TIME 65 9787
TEST_TIME 66 9728
TEST_TIME 67 9667
TEST_TIME 68 9622
TEST_TIME 69 9612
TEST_TIME 70 9551
TEST_TIME 71 9518
TEST_TIME 72 9463
TEST_TIME 73 9474
TEST_TIME 74 9506
TEST_TIME 75 9469
TEST_TIME 76 9415
TEST_TIME 77 9461
TEST_TIME 78 9496
TEST_TIME 79 9574
TEST_TIME 80 9548
TEST_TIME 81 9565
TEST_TIME 82 9558
TEST_TIME 83 9603
TEST_TIME 84 9656
TEST_TIME 85 9624
TEST_TIME 86 9601
TEST_TIME 87 9529
TEST_TIME 88 9474
TEST_TIME 89 9421
TEST_TIME 90 9446
TEST_TIME 91 9385
TEST_TIME 92 9363
TEST_TIME 93 9356
TEST_TIME 94 9334
TEST_TIME 95 9388
TEST_TIME 96 9369
TEST_TIME 97 9380
TEST_TIME 98 9342
TEST_TIME 99 9413
TEST_TIME 100 9472
TEST_TIME 101 9449
TEST_TIME 102 9455
TEST_TIME 103 9479
TEST_TIME 104 9556
TEST_TIME 105 9526
TEST_TIME 106 9546
TEST_TIME 107 9593
TEST_TIME 108 9519
TEST_TIME 109 9487
TEST_TIME 110 9456
TEST_TIME 111 9487
TEST_TIME 112 9455
TEST_TIME 113 9412
TEST_TIME 114 9379
TEST_TIME 115 9366
TEST_TIME 116 9342
TEST_TIME 117 9319
TEST_TIME 118 9300
TEST_TIME 119 9324
TEST_TIME 120 9258

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 12-03-2021 01:28:51 to 12-03-2021 01:28:54.

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 1537115 1537115 0 0.00 0 20380 5 0 0
doc_list_biud 1537114 1537114 0 0.00 0 30797 26 0 0
sp_add_invoice_to_stock 5018 4860 158 3.14 33 207015 17367 0 158
sp_cancel_adding_invoice 5698 5698 0 0.00 5 50961 701 0 0
sp_cancel_client_order 1671 1671 0 0.00 4 10584 352 0 0
sp_cancel_customer_reserve 564461 564461 0 0.00 1 20134 56 0 0
sp_cancel_pay_from_customer 673 673 0 0.00 3 3647 72 0 0
sp_cancel_pay_to_supplier 401 401 0 0.00 3 2509 61 0 0
sp_cancel_supplier_invoice 6291 6280 11 0.17 2 20845 726 0 11
sp_cancel_supplier_order 428 428 0 0.00 6 955155 93479 0 0
sp_cancel_write_off 10194 10194 0 0.00 1 23567 106 0 0
sp_client_order 20433 20433 0 0.00 4 16823 330 0 0
sp_customer_reserve 461105 461105 0 0.00 0 74163 168 0 0
sp_fill_shopping_cart 31112 31112 0 0.00 1 15401 37 0 0
sp_fill_shopping_cart_clo_res 461101 461101 0 0.00 0 25805 14 0 0
sp_get_clo_for_invoice 4851 4851 0 0.00 0 24962 321 0 0
sp_kill_cost_storno 16966 16966 0 0.00 0 6358 50 0 0
sp_kill_qstorno_ret_qs2qd 1145824 1145824 0 0.00 0 23518 30 0 0
sp_kill_qty_storno 603490 603490 0 0.00 0 30791 65 0 0
sp_lock_selected_doc 20379 20379 0 0.00 0 9805 5 0 0
sp_make_cost_storno 27201 27201 0 0.00 0 13134 44 0 0
sp_multiply_rows_for_pdistr 27201 27201 0 0.00 0 14642 26 0 0
sp_multiply_rows_for_qdistr 20433 20433 0 0.00 0 11740 149 0 0
sp_pay_from_customer 6811 6811 0 0.00 4 43811 103 0 0
sp_pay_to_supplier 5632 5632 0 0.00 5 14663 114 0 0
sp_payment_common 12443 12443 0 0.00 1 43787 30 0 0
sp_qd_handle_on_cancel_clo 1671 1671 0 0.00 0 8827 301 0 0
sp_qd_handle_on_invoice_upd_sts 10545 10545 0 0.00 0 30784 299 0 0
sp_qd_handle_on_reserve_upd_sts 9911 9911 0 0.00 0 11938 53 0 0
sp_reserve_write_off 9911 9911 0 0.00 6 12916 150 0 0
sp_supplier_invoice 5362 5362 0 0.00 7 81973 3391 0 0
sp_supplier_order 5344 5344 0 0.00 5 26823 1236 0 0
srv_aggregate_perf_data 104 103 1 0.96 2347 135808 15424 0 1
srv_fill_mon_cache_memory 154 154 0 0.00 962 162834 34983 0 0
srv_find_qd_qs_mism 1063558 1063558 0 0.00 0 20379 5 0 0
srv_make_invnt_saldo 572 572 0 0.00 28 99936 1118 0 0
srv_make_money_saldo 725 725 0 0.00 1 23080 59 0 0
srv_recalc_idx_stat 4 4 0 0.00 155690 348156 252517 0 0
t$perf-abend:sp_add_invoice_to_stock 158 158 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 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 4860 4860 0 0.00 0 19672 187 0 0
t$perf-norm:sp_cancel_adding_invoice 420 420 0 0.00 0 2461 95 0 0
t$perf-norm:sp_cancel_client_order 1671 1671 0 0.00 0 3032 12 0 0
t$perf-norm:sp_cancel_customer_reserve 683 683 0 0.00 0 2166 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 673 673 0 0.00 0 1821 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 401 401 0 0.00 0 5898 25 0 0
t$perf-norm:sp_cancel_supplier_invoice 399 399 0 0.00 0 5875 32 0 0
t$perf-norm:sp_cancel_supplier_order 428 428 0 0.00 0 24391 1682 0 0
t$perf-norm:sp_cancel_write_off 946 946 0 0.00 0 3986 17 0 0
t$perf-norm:sp_client_order 20433 20433 0 0.00 0 16424 20 0 0
t$perf-norm:sp_customer_reserve 1050 1050 0 0.00 0 3124 13 0 0
t$perf-norm:sp_pay_from_customer 6811 6811 0 0.00 0 8688 11 0 0
t$perf-norm:sp_pay_to_supplier 5632 5632 0 0.00 0 10955 12 0 0
t$perf-norm:sp_reserve_write_off 9911 9911 0 0.00 0 8408 11 0 0
t$perf-norm:sp_supplier_invoice 5362 5362 0 0.00 0 5349 18 0 0
t$perf-norm:sp_supplier_order 5344 5344 0 0.00 0 10791 18 0 0
t$perf-norm:srv_aggregate_perf_data 103 103 0 0.00 0 192 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 154 154 0 0.00 0 6729 56 0 0
t$perf-norm:srv_make_invnt_saldo 572 572 0 0.00 0 2808 22 0 0
t$perf-norm:srv_make_money_saldo 725 725 0 0.00 0 4038 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 93 25 0 0
v_add_invoice_to_stock 10010 9694 316 3.15 0 4395 16 0 316
v_all_customers 36758 36758 0 0.00 0 16 1 0 0
v_all_suppliers 29516 29516 0 0.00 0 23 1 0 0
v_all_wares 40866 40866 0 0.00 0 77 1 0 0
v_cancel_adding_invoice 840 840 0 0.00 0 1424 9 0 0
v_cancel_client_order 3342 3342 0 0.00 0 9794 11 0 0
v_cancel_customer_prepayment 1346 1346 0 0.00 0 2139 6 0 0
v_cancel_customer_reserve 1366 1366 0 0.00 0 313 2 0 0
v_cancel_payment_to_supplier 802 802 0 0.00 0 274 3 0 0
v_cancel_supplier_invoice 820 798 22 2.68 0 7398 23 0 22
v_cancel_supplier_order 856 856 0 0.00 0 2390 7 0 0
v_cancel_write_off 1892 1892 0 0.00 0 3190 15 0 0
v_max_id_clo_ord 5344 5344 0 0.00 0 1055 1 0 0
v_max_id_clo_res 1050 1050 0 0.00 0 5510 21 0 0
v_max_id_ord_sup 5334 5334 0 0.00 0 4914 6 0 0
v_max_non_paid_invoice 1552 1552 0 0.00 0 4332 6 0 0
v_max_non_paid_realizn 3712 3712 0 0.00 0 2023 4 0 0
v_min_id_clo_ord 5344 5344 0 0.00 0 1589 4 0 0
v_min_id_clo_res 1050 1050 0 0.00 0 2941 8 0 0
v_min_id_ord_sup 5334 5334 0 0.00 0 6251 9 0 0
v_min_non_paid_invoice 5632 5632 0 0.00 0 6762 13 0 0
v_min_non_paid_realizn 6811 6811 0 0.00 0 5055 12 0 0
v_our_firm 10306 10306 0 0.00 0 15 1 0 0
v_reserve_write_off 19822 19822 0 0.00 0 9441 5 0 0
x_lock_depdocs_on_canc_invoice 11579 11579 0 0.00 0 13732 105 0 0
x_lock_depdocs_on_canc_sup_ord 428 428 0 0.00 0 5220 293 0 0
x_make_qstorno_1000_1200 5344 5344 0 0.00 2 26818 1174 0 0
x_make_qstorno_1200_2000 5362 5362 0 0.00 2 78387 3236 0 0
x_make_qstorno_2100_3300 461105 461105 0 0.00 0 74162 152 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 12-03-2021 01:28:55 to 12-03-2021 01:28:59.

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
22:57:25 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:31 26076 8192000000 10277707296 10585116672 867329456 9.573 67 53 106 0 887098496 2605728 17163312
22:58:08 29969 8192000000 10346133088 10659323904 1391755520 14.522 100 93 185 0 1427135136 5219936 30159680
22:58:46 39375 8192000000 10394521488 10718052352 1438800272 14.939 100 88 176 0 1474540336 6510128 29229936
22:59:33 17113 8192000000 10414302384 10739515392 1470563472 15.219 100 92 184 0 1508962176 7999120 30399584
23:00:03 23891 8192000000 10430034240 10761404416 1482270352 15.321 100 86 172 0 1518884768 8485008 28129408
23:00:39 21053 8192000000 10455776976 10786660352 1505745488 15.526 100 92 185 1 1544175632 9125088 29305056
23:01:15 14802 8192000000 10469243568 10807681024 1522478352 15.672 100 85 170 0 1559063440 9873072 26712016
23:01:39 13718 8192000000 10487525216 10828300288 1537800736 15.805 100 82 164 1 1573837744 10253168 25783840
23:02:04 16910 8192000000 10517477056 10869174272 1570846464 16.090 100 74 146 2 1603613712 10190928 22576320
23:02:32 15744 8192000000 10555150624 10913107968 1610993984 16.433 100 80 160 1 1645953520 10690896 24268640
23:02:56 12623 8192000000 10582814976 10942988288 1640913520 16.687 100 85 170 1 1678529248 11724064 25891664
23:03:17 12899 8192000000 10602801616 10968322048 1662348464 16.869 100 74 148 0 1696519856 11765904 22405488
23:03:44 7373 8192000000 10623185568 10993569792 1686432640 17.071 100 77 154 0 1721188256 12511680 22243936
23:03:59 9582 8192000000 10631450272 11004416000 1694489136 17.139 100 69 138 0 1726240336 11470288 20280912
23:04:15 9496 8192000000 10665971376 11035623424 1717901600 17.335 100 84 166 2 1755168928 13466848 23800480
23:04:32 7481 8192000000 10665253968 11037757440 1726160880 17.404 100 81 162 0 1763353296 14152480 23039936
23:04:49 6644 8192000000 10674559344 11051241472 1732993136 17.460 100 79 159 3 1769206528 14033872 22179520
23:05:03 5290 8192000000 10686194544 11064844288 1743475200 17.547 100 75 150 1 1778793968 14372784 20945984
23:05:16 6193 8192000000 10699799072 11077758976 1756876128 17.659 100 80 158 3 1793364544 14265072 22223344
23:05:29 3654 8192000000 10702075040 11082584064 1769735856 17.765 100 86 171 2 1808871728 14746640 24389232
23:05:40 3382 8192000000 10719860752 11103744000 1780049024 17.850 100 72 143 0 1812847472 13256992 19541456
23:05:50 6958 8192000000 10719178400 11104575488 1784536736 17.887 100 73 144 0 1817996464 12600416 20859312
23:06:05 3403 8192000000 10741476928 11124912128 1796359072 17.984 100 79 158 1 1832180976 13640880 22181024
23:06:15 2763 8192000000 10760588736 11145744384 1814648240 18.134 100 86 170 0 1855860880 16685840 24526800
23:06:24 2831 8192000000 10773101056 11154096128 1823085328 18.203 100 88 175 3 1861299952 13258336 24956288
23:06:34 2214 8192000000 10775822928 11158896640 1825546064 18.223 100 86 173 1 1863364544 13034368 24784112
23:06:43 2582 8192000000 10773801280 11157839872 1837977856 18.324 100 93 185 1 1875850864 12560912 25312096
23:06:53 2515 8192000000 10778595280 11166683136 1839372992 18.336 100 88 175 1 1876580160 12766208 24440960
23:07:01 2120 8192000000 10785563392 11177578496 1845342368 18.384 100 80 157 2 1879875536 12694736 21838432
23:07:10 2246 8192000000 10786081072 11173773312 1850046656 18.423 100 86 172 1 1886452064 12153168 24252240
23:07:19 2722 8192000000 10791892608 11180310528 1852649760 18.444 100 83 165 0 1888062672 11981696 23431216
23:07:27 2767 8192000000 10805255200 11194519552 1858405792 18.490 100 88 174 1 1896243328 13223360 24614176
23:07:36 1508 8192000000 10805928144 11193720832 1865410800 18.547 100 97 194 3 1906665056 14788992 26465264
23:07:45 1325 8192000000 10811019120 11199184896 1867183472 18.561 100 92 180 0 1907263776 14671424 25408880
23:07:52 1270 8192000000 10808781136 11199131648 1866992464 18.560 100 93 185 1 1907860000 14244672 26622864
23:08:00 1294 8192000000 10815550688 11206475776 1877485232 18.645 100 94 186 0 1916923968 13404736 26034000
23:08:07 1013 8192000000 10817600608 11205963776 1874259344 18.619 100 89 180 4 1912210080 13189392 24761344
23:08:15 1728 8192000000 10827008832 11216121856 1879232672 18.659 100 92 184 2 1918576288 13094960 26248656
23:08:23 1218 8192000000 10821880288 11213529088 1880349536 18.668 100 91 181 0 1919733536 12687568 26696432
23:08:30 37855 8192000000 10817682784 11220160512 1874757568 18.623 100 58 117 1 1899181200 7489232 16934400
23:09:14 7664 8192000000 10812935360 11221737472 1885415040 18.709 100 46 92 0 1906645856 8379520 12851296
23:09:28 5904 8192000000 10800105808 11225427968 1884054480 18.698 100 30 59 3 1900880800 8635616 8190704
23:09:43 7159 8192000000 10790770704 11223371776 1884716240 18.703 100 17 34 2 1896093328 6524800 4852288
23:09:56 6095 8192000000 10805601760 11230101504 1886991296 18.722 100 22 44 0 1904351584 11177760 6182528
23:10:08 6370 8192000000 10806957792 11234516992 1889509920 18.742 100 24 47 0 1902121248 6324224 6287104
23:10:23 7249 8192000000 10795740528 11229687808 1892298960 18.764 100 22 44 0 1904936672 5923216 6714496
23:10:37 10833 8192000000 10802103936 11233603584 1892177168 18.763 100 13 26 0 1901519664 5786256 3556240
23:10:54 11575 8192000000 10805444352 11238797312 1893775712 18.776 100 14 26 2 1904176480 6650208 3750560
23:11:13 18763 8192000000 10807383440 11242852352 1897124752 18.803 100 18 36 4 1908209824 6247920 4837152
23:11:38 7527 8192000000 10802013520 11240878080 1899800800 18.825 100 17 35 1 1910707392 5989776 4916816
23:11:53 8604 8192000000 10808578784 11247788032 1901770960 18.841 100 20 40 2 1914113072 6818912 5523200
23:12:10 14084 8192000000 10815736432 11249139712 1905966736 18.874 100 29 58 1 1920610192 6539792 8103664
23:12:30 61144 8192000000 10839458960 11262820352 1906719168 18.880 100 26 51 1 1924295584 10698224 6878192
23:13:37 9338 8192000000 10810551360 11257237504 1906707152 18.880 100 17 34 2 1918025984 6716352 4602480
23:13:55 6346 8192000000 10825536880 11262164992 1910662640 18.912 100 28 54 1 1925378992 7344672 7371680
23:14:07 5601 8192000000 10822678704 11257810944 1907460016 18.886 100 34 68 2 1923884384 6441920 9982448
23:14:24 4333 8192000000 10822457168 11257323520 1909418512 18.902 100 31 62 3 1925111104 6415920 9276672
23:14:36 5089 8192000000 10816197264 11258667008 1907679792 18.888 100 29 56 1 1922164384 6396096 8088496
23:14:47 5190 8192000000 10821331856 11260125184 1910009072 18.907 100 33 66 0 1926817216 6626208 10181936
23:14:59 7181 8192000000 10825954400 11259379712 1908923744 18.898 100 21 42 0 1920560608 5788384 5848480
23:15:13 10103 8192000000 10825929248 11257737216 1890035872 18.746 99 16 32 2 1900872976 6018048 4819056
23:15:31 5872 8192000000 10821573536 11255652352 1905029376 18.867 100 37 74 1 1923487712 7042688 11415648
23:15:43 8034 8192000000 10826493584 11256668160 1903915120 18.858 100 15 30 0 1914304768 5735120 4654528
23:15:59 9949 8192000000 10837326880 11265900544 1909894112 18.906 100 28 56 1 1923651216 5583488 8173616
23:16:16 11767 8192000000 10786365248 11224928256 1849048992 18.414 97 23 46 2 1865535648 10290240 6196416
23:16:34 7547 8192000000 10810749392 11244929024 1893888144 18.777 100 19 38 1 1908675136 9873808 4913184
23:16:49 24047 8192000000 10783049824 11217379328 1839332000 18.335 97 25 51 2 1851493968 5166560 6995408
23:17:41 21215 8192000000 10768768736 11205132288 1809996240 18.096 96 45 89 1 1829256720 6102896 13157584
23:18:09 12903 8192000000 10761434064 11191640064 1817468672 18.157 97 26 51 2 1830642480 5734496 7439312
23:18:30 6679 8192000000 10788414960 11212169216 1862786912 18.526 100 29 58 3 1877966736 6596208 8583616
23:18:44 7931 8192000000 10750093056 11167223808 1777308640 17.827 96 31 62 3 1791903024 5967424 8626960
23:19:02 8698 8192000000 10753074736 11171856384 1786123440 17.900 97 34 67 1 1802307424 5849200 10334784
23:19:17 6578 8192000000 10709372944 11123126272 1657779376 16.830 90 30 60 1 1676682192 10437104 8465712
23:19:29 7924 8192000000 10726808160 11138486272 1783186304 17.876 99 25 50 1 1796068336 5580944 7301088
23:19:47 8160 8192000000 10713044544 11129114624 1744280528 17.554 96 28 56 3 1758394544 5776480 8337536
23:20:02 10722 8192000000 10714557936 11120283648 1712148464 17.287 95 31 63 2 1727087056 5379696 9558896
23:20:22 13626 8192000000 10704670448 11120717824 1717171776 17.329 95 19 38 1 1727680496 4667504 5841216
23:20:43 9400 8192000000 10719566016 11138174976 1782540800 17.870 99 13 25 0 1791545200 5446032 3558368
23:20:58 10013 8192000000 10690847696 11100463104 1712022416 17.286 95 23 46 1 1724783328 5284800 7476112
23:21:17 26295 8192000000 10690152304 11108823040 1739690048 17.516 97 26 51 1 1751831312 5277824 6863440
23:22:28 8741 8192000000 10691037824 11102973952 1754089824 17.635 98 12 22 2 1762763072 5361648 3311600
23:22:43 10829 8192000000 10712954368 11134795776 1797776496 17.996 100 23 46 0 1810491952 6278848 6436608
23:23:03 6382 8192000000 10734929744 11146158080 1794086784 17.965 99 34 68 2 1815416720 11035440 10294496
23:23:15 7057 8192000000 10733948784 11153469440 1821737136 18.192 100 31 61 1 1836066352 6295264 8033952
23:23:32 6702 8192000000 10740066864 11157991424 1822605728 18.199 100 29 58 2 1837925184 6434288 8885168
23:23:45 9886 8192000000 10748512816 11169787904 1833077056 18.284 100 29 57 3 1845796672 4778320 7941296
23:24:01 6660 8192000000 10749866928 11178278912 1838129648 18.326 100 20 40 0 1849836208 5674128 6032432
23:24:14 13744 8192000000 10759093376 11187937280 1842619296 18.362 100 23 46 4 1854669008 5242256 6807456
23:24:36 7919 8192000000 10763017472 11190280192 1852909376 18.446 100 23 46 1 1864752656 5457024 6386256
23:24:53 13920 8192000000 10760315440 11193835520 1854794672 18.461 100 14 28 2 1864267376 5645808 3826896
23:25:16 9276 8192000000 10773247872 11199844352 1861225536 18.513 100 19 38 1 1872650080 5370672 6053872
23:25:31 8944 8192000000 10782593216 11204796416 1864105248 18.537 100 26 54 4 1877329792 5371184 7853360
23:25:51 8531 8192000000 10771702160 11204071424 1860636048 18.508 100 11 23 1 1869143776 5610672 2897056
23:26:10 22658 8192000000 10777540448 11211169792 1866917648 18.559 100 26 51 1 1880060800 5521264 7621888
23:27:10 54247 8192000000 10814263856 11234713600 1887159888 18.723 100 36 70 2 1903143104 6155152 9828064
23:28:16 21932 8192000000 10833057232 11250642944 1905742160 18.872 100 54 107 1 1929070976 8451392 14877424
23:28:48 32629 8192000000 10848021296 11269902336 1911500080 18.919 100 40 80 2 1932755152 10142976 11112096
23:29:27 6496 8192000000 10872265632 11291029504 1925868128 19.034 100 56 112 3 1955264384 13543248 15853008
23:29:43 6616 8192000000 10879740336 11297697792 1935435936 19.110 100 60 120 1 1967154272 14608912 17109424
23:29:56 5855 8192000000 10883696336 11302469632 1935580048 19.111 100 55 110 1 1970674544 19678896 15415600
23:30:22 14892 8192000000 10880873456 11303817216 1934875552 19.106 100 58 116 0 1972425488 21158192 16391744
23:30:45 19302 8192000000 10887071552 11308974080 1941117696 19.156 100 58 116 3 1974949440 17346384 16485360
23:31:12 17379 8192000000 10888355968 11312590848 1945462864 19.190 100 56 112 0 1978352096 17006320 15882912
23:31:42 30147 8192000000 10892067184 11321335808 1949900240 19.226 100 49 98 2 1983327216 19174256 14252720
23:32:36 13923 8192000000 10890766544 11323912192 1952608384 19.247 100 41 80 3 1984307584 19539040 12160160
23:33:01 12216 8192000000 10898618208 11323088896 1941004736 19.155 99 55 110 4 1976158192 18969216 16184240
23:33:25 6119 8192000000 10902924320 11329720320 1955371216 19.269 100 54 108 0 1991950992 20880864 15698912
23:33:39 5549 8192000000 10921314496 11338784768 1962108608 19.323 100 63 125 2 2002835728 22054560 18672560
23:33:58 18894 8192000000 10910037328 11346354176 1967156112 19.363 100 46 92 0 2002700736 21640656 13903968
23:34:24 9941 8192000000 10918202192 11351457792 1973914976 19.416 100 45 89 0 2008496448 20377792 14203680
23:34:40 24665 8192000000 10917615664 11359334400 1977488592 19.445 100 39 78 0 2011140352 21678144 11973616
23:35:28 8449 8192000000 10939167680 11377684480 1987600912 19.525 100 47 93 2 2026747744 25335168 13811664
23:35:45 10159 8192000000 10948010752 11385524224 1993880576 19.574 100 61 122 0 2041785616 28493744 19411296
23:36:06 7230 8192000000 10935152080 11377557504 1986051760 19.513 100 41 82 1 2027655264 28397216 13206288
23:36:20 6358 8192000000 10937311824 11369836544 1968375328 19.373 99 48 95 0 2010106000 25261344 16469328
23:36:34 4192 8192000000 10955104688 11383824384 1991174640 19.553 100 65 128 1 2039655200 28750768 19729792
23:36:47 11152 8192000000 10959417712 11388788736 1995635328 19.588 100 74 148 1 2048444752 29947936 22861488
23:37:09 14876 8192000000 10961793264 11390734336 1996242464 19.593 100 59 116 1 2043119808 28524960 18352384
23:37:48 12321 8192000000 10952460848 11388518400 1985068208 19.505 99 49 98 1 2025935104 25717024 15149872
23:38:08 5187 8192000000 10963239632 11397328896 2006347600 19.673 100 58 115 2 2049033088 24253504 18431984
23:38:20 11282 8192000000 10964319456 11399720960 2011165472 19.711 100 55 110 1 2051693232 23551232 16976528
23:38:40 2545 8192000000 10956208288 11375632384 1977284944 19.443 99 80 159 2 2025353632 23965328 24103360
23:38:52 5740 8192000000 10958336144 11384000512 1998635904 19.612 100 77 151 1 2047454864 26605184 22213776
23:39:05 8248 8192000000 10970880912 11394555904 2004543328 19.659 100 76 152 1 2056659904 28516800 23599776
23:39:22 2731 8192000000 10980794000 11403354112 2011315472 19.712 100 77 155 1 2063946576 29803296 22827808
23:39:35 3133 8192000000 10984416464 11403481088 2009953888 19.701 100 83 164 3 2063199696 29632416 23613392
23:39:48 12685 8192000000 10983033504 11407536128 2012420096 19.721 100 77 153 1 2064849664 29851920 22577648
23:40:09 3725 8192000000 10982775472 11411689472 2016103248 19.750 100 76 152 1 2070081760 30645056 23333456
23:40:26 10287 8192000000 10977150496 11406598144 2010871952 19.708 100 63 126 1 2062342368 31815328 19655088
23:40:49 9469 8192000000 10953541264 11383803904 1988094768 19.529 99 59 118 1 2039530192 33385888 18049536
23:41:09 3684 8192000000 10978886256 11402436608 2006944624 19.677 100 66 132 0 2062595536 33779872 21871040
23:41:21 8846 8192000000 10990287728 11411898368 2010946160 19.709 100 79 159 3 2070208352 34845696 24416496
23:41:37 3925 8192000000 10990803200 11417612288 2015900528 19.748 100 79 156 1 2075752272 34784720 25067024
23:41:49 7572 8192000000 11004480768 11425443840 2022302512 19.798 100 85 171 0 2085900272 36763472 26834288
23:42:05 9376 8192000000 10996567824 11430002688 2023048064 19.804 100 61 122 0 2081869632 38881328 19940240
23:42:23 2696 8192000000 10970581552 11393433600 1981700976 19.478 98 69 138 0 2041398512 36436112 23261424
23:42:38 2047 8192000000 10994434000 11409137664 2004141808 19.655 100 74 146 0 2066866736 39556880 23168048
23:42:48 3460 8192000000 10998620336 11417628672 2011236000 19.711 100 80 160 0 2076747088 39446736 26064352
23:42:59 3872 8192000000 10996381632 11421630464 2011746672 19.715 100 77 154 1 2076558048 40282752 24528624
23:43:09 961 8192000000 10991013328 11415494656 1996120608 19.592 99 91 181 4 2066975120 42020752 28833760
23:43:17 4435 8192000000 10986758304 11414462464 2011124064 19.710 100 83 166 1 2074413088 36687968 26601056
23:43:31 2488 8192000000 10995999504 11418578944 2014862384 19.740 100 83 164 0 2077478176 37040848 25574944
23:43:40 3998 8192000000 10970669536 11392454656 1968064416 19.370 98 78 155 0 2030061648 38218272 23778960
23:43:51 4536 8192000000 10975182784 11395342336 1988988416 19.536 100 84 168 1 2054429216 38819840 26620960
23:44:03 4073 8192000000 10975304032 11400708096 1991009536 19.552 100 77 153 1 2055292400 38977232 25305632
23:44:24 3849 8192000000 10974359296 11403898880 1999132848 19.616 100 70 140 1 2060266832 38628560 22505424
23:44:37 2184 8192000000 10988801680 11414822912 2003656992 19.652 100 76 153 0 2067878624 39545152 24676480
23:44:45 8301 8192000000 10983511600 11414114304 2000840336 19.629 100 67 134 1 2061787216 39008320 21938560
23:45:03 1881 8192000000 10984973184 11408306176 2005934592 19.670 100 80 158 4 2070106192 38882992 25288608
23:45:12 2263 8192000000 10976728464 11402194944 2000060000 19.623 100 66 132 1 2055824640 34356080 21408560
23:45:21 5041 8192000000 10976795680 11408097280 2008761136 19.692 100 73 144 1 2065096416 33912704 22422576
23:45:33 7507 8192000000 10952257392 11398725632 1982704416 19.486 99 50 98 2 2031541616 33004016 15833184
23:45:55 11820 8192000000 10940992384 11393486848 1976264688 19.435 99 40 80 0 2019530672 29978896 13287088
23:46:32 11079 8192000000 10950131840 11390701568 1985600640 19.509 100 45 89 2 2032333072 31443888 15288544
23:46:51 3411 8192000000 10968399488 11389259776 1983722352 19.494 100 73 146 1 2039797808 31841552 24233904
23:47:02 1925 8192000000 10955254512 11381424128 1978078272 19.449 100 75 147 1 2036697488 35199088 23420128
23:47:15 17356 8192000000 10915955600 11362078720 1959486304 19.302 100 48 95 3 2015150944 39656160 16008480
23:47:38 7641 8192000000 10888064912 11327655936 1887226736 18.723 96 41 82 2 1935425072 34193840 14004496
23:47:59 21605 8192000000 10875432240 11324796928 1880950000 18.673 97 37 70 1 1928221408 34733792 12537616
23:48:31 17257 8192000000 10866655104 11305091072 1889379632 18.741 98 37 73 0 1932856112 30843216 12633264
23:49:03 13573 8192000000 10859712240 11312242688 1886266048 18.716 98 39 78 1 1929230032 30210944 12753040
23:49:25 1115 8192000000 10890789952 11322146816 1923655552 19.016 100 53 107 3 1966259104 25445792 17157760
23:49:32 9075 8192000000 10858232192 11297361920 1887568576 18.726 98 29 58 0 1927003744 29522848 9912320
23:49:51 15512 8192000000 10868033664 11315998720 1897489232 18.806 99 27 54 1 1931554896 25141360 8924304
23:50:14 21931 8192000000 10862035952 11316428800 1897255792 18.804 99 30 59 1 1928932400 22349536 9327072
23:50:44 17850 8192000000 10874626544 11321569280 1921008304 18.995 100 22 44 1 1953829200 25871520 6949376
23:51:12 11404 8192000000 10864767008 11304628224 1898484800 18.814 99 35 70 3 1938142144 28568192 11089152
23:51:30 23254 8192000000 10821520080 11280363520 1850462080 18.426 97 21 42 0 1891108464 33426576 7219808
23:52:01 41064 8192000000 10859606816 11312861184 1904006016 18.859 100 21 42 2 1942230032 31136496 7087520
23:52:54 20461 8192000000 10852589600 11308085248 1895387744 18.789 100 14 28 0 1931471680 31380352 4703584
23:53:21 42960 8192000000 10848581312 11313012736 1883715328 18.695 99 13 26 0 1922837504 34770304 4351872
23:54:20 38096 8192000000 10846889872 11307671552 1885729408 18.711 99 15 30 2 1916129488 25767136 4632944
23:55:21 93748 8192000000 10802800704 11245232128 1770858384 17.774 93 9 18 0 1785540320 12297104 2384832
23:57:21 162834 8192000000 10844106624 11291615232 1867398496 18.563 97 31 61 0 1895842704 19561600 8882608
00:00:25 64854 8192000000 10835569392 11276824576 1835382864 18.303 95 36 70 1 1852132032 7078256 9670912
00:01:52 59256 8192000000 10863111552 11326451712 1912258768 18.925 99 28 56 1 1931632432 11221456 8152208
00:03:02 35783 8192000000 10872735808 11334660096 1942527920 19.167 100 22 44 1 1960982640 12389824 6064896
00:03:45 14233 8192000000 10874432816 11329990656 1946308816 19.197 100 24 48 0 1964407488 11215664 6883008
00:04:06 43876 8192000000 10880286832 11342962688 1933411248 19.094 99 17 34 0 1947942336 9189152 5341936
00:05:03 61761 8192000000 10882106784 11348090880 1943602848 19.175 99 32 65 0 1963264112 9961984 9699280
00:06:17 17372 8192000000 10919588048 11352195072 1962894448 19.329 100 49 96 2 1988924768 10798704 15231616
00:06:50 24576 8192000000 10907440480 11365376000 1969507264 19.382 100 47 95 1 1996773536 14669248 12597024
00:07:22 42625 8192000000 10872849776 11351760896 1945792576 19.193 99 12 24 1 1961451568 11922736 3736256
00:08:11 120541 8192000000 10885635088 11356696576 1930551408 19.071 98 12 24 0 1943851296 9965136 3334752
00:11:03 53275 8192000000 10879125040 11355119616 1947625472 19.208 99 25 50 2 1962914720 8051568 7237680
00:12:18 57531 8192000000 10895571536 11365195776 1972483040 19.405 100 25 50 2 1986104656 5946560 7675056
00:13:51 85117 8192000000 10896245760 11380383744 1980149808 19.466 100 7 14 0 1992309088 10188448 1970832
00:15:26 23622 8192000000 10901290208 11377643520 1982841792 19.487 100 14 28 0 1999830064 13360608 3627664
00:16:12 49065 8192000000 10908701216 11390988288 1988886576 19.535 100 20 40 1 2007069424 12481120 5701728
00:17:39 46356 8192000000 10910184176 11383803904 1966063152 19.354 99 14 28 1 1978660976 8801632 3796192
00:18:37 49275 8192000000 10914677744 11395878912 1988829952 19.535 100 16 31 2 2006683392 13376672 4476768
00:19:34 37240 8192000000 10910375728 11384397824 1955743776 19.272 98 23 46 2 1975247280 12923520 6579984
00:20:18 55480 8192000000 10934102032 11402674176 1986638448 19.517 100 14 28 0 2008032928 17186240 4208240
00:21:19 51641 8192000000 10925485952 11409178624 1998146896 19.608 100 18 36 0 2014095936 10984336 4964704
00:22:22 31511 8192000000 10935259808 11404070912 1983146720 19.490 99 24 48 0 2003289200 13651984 6490496
00:23:31 42663 8192000000 10947799920 11417636864 2001041792 19.631 100 19 38 0 2026984704 19868832 6074080
00:24:20 55391 8192000000 10932935584 11394772992 1948751792 19.217 97 32 65 3 1968962352 11513568 8696992
00:25:25 29896 8192000000 10896915152 11356786688 1892398560 18.765 95 27 54 1 1910438192 10640384 7399248
00:26:03 21634 8192000000 10892473952 11342049280 1891473024 18.758 96 39 78 1 1914868832 12362880 11032928
00:26:34 33792 8192000000 10913233808 11375280128 1967205888 19.363 100 38 76 0 1993213152 15340160 10667104
00:27:14 92867 8192000000 10905344560 11389644800 1919829568 18.985 97 20 40 4 1945721808 20223744 5668496
00:28:55 139609 8192000000 10851018208 11320844288 1744276240 17.554 88 15 30 1 1763761152 15783040 3701872
00:31:23 98642 8192000000 10885131616 11353100288 1937627440 19.128 99 29 58 0 1958139888 12213744 8298704
00:33:12 39946 8192000000 10887063936 11342737408 1922758416 19.009 98 34 67 1 1942710512 10276976 9675120
00:34:07 37778 8192000000 10876446816 11363155968 1946430880 19.198 99 16 31 2 1963105680 12349824 4324976
00:34:55 57128 8192000000 10874753600 11359174656 1944302352 19.181 99 8 16 0 1958086944 11579600 2204992
00:35:58 32541 8192000000 10898683040 11380682752 1970196528 19.387 100 10 20 0 1983960432 10765472 2998432
00:36:37 45456 8192000000 10895310960 11385417728 1963238592 19.332 99 6 12 0 1977587904 12706480 1642832
00:37:36 46271 8192000000 10887016816 11362295808 1915816096 18.953 97 15 30 1 1935479008 15437760 4225152
00:38:29 75092 8192000000 10865570080 11357986816 1880994528 18.673 96 14 27 0 1897269280 13017360 3257392
00:40:03 65301 8192000000 10869765808 11348905984 1927699216 19.048 99 11 23 0 1945521264 14704080 3117968
00:41:14 52233 8192000000 10868158432 11357577216 1921901232 19.002 98 24 48 2 1941978832 12353600 7724000
00:42:30 41771 8192000000 10827204320 11294150656 1812712624 18.118 94 15 30 1 1826252016 9733600 3805792
00:43:18 24104 8192000000 10857269744 11316781056 1915855264 18.954 100 36 70 1 1937198624 11375824 9967536
00:43:50 45834 8192000000 10880730960 11346628608 1938919472 19.138 100 22 44 0 1958509056 13259872 6329712
00:44:48 114716 8192000000 10880865136 11354697728 1885466912 18.709 97 21 42 2 1905577456 13788944 6321600
00:47:01 64966 8192000000 10855904384 11320582144 1851975904 18.438 95 12 24 0 1870772048 15647056 3149088
00:48:15 59807 8192000000 10859670256 11320631296 1870814240 18.591 97 9 18 1 1885977184 12763712 2399232
00:49:27 35528 8192000000 10875271584 11327471616 1898882944 18.817 98 36 72 0 1921423312 12376880 10163488
00:50:13 131511 8192000000 10869560992 11349573632 1903111728 18.851 98 9 18 0 1926618128 20939584 2566816
00:52:47 117158 8192000000 10858032656 11322707968 1885857968 18.712 97 25 50 0 1904088704 11701056 6529680
00:54:56 84466 8192000000 10871002848 11339141120 1928098096 19.052 99 25 50 1 1943678976 8055680 7525200
00:56:39 37355 8192000000 10859112432 11338289152 1940859376 19.154 100 9 18 0 1953080880 9600720 2620784
00:57:33 66036 8192000000 10854300848 11343638528 1927185632 19.044 99 12 23 0 1938272160 7336864 3749664
00:58:49 24230 8192000000 10866361520 11348029440 1933401184 19.094 99 9 18 0 1941139088 5582848 2155056
00:59:22 39815 8192000000 10858920736 11335286784 1920447872 18.990 98 10 20 0 1929697168 7040192 2209104
01:00:14 45029 8192000000 10877347552 11346661376 1952034304 19.243 100 12 24 0 1962921600 7594528 3292768
01:01:11 22850 8192000000 10897448752 11355021312 1933971072 19.099 98 32 66 2 1950621072 8021344 8628656
01:01:42 38452 8192000000 10882175088 11365535744 1965010480 19.346 100 25 50 2 1982202736 9894832 7297424
01:02:29 42711 8192000000 10893534704 11372199936 1969584880 19.382 100 12 24 0 1982485952 9425808 3475264
01:03:47 74042 8192000000 10916129408 11378692096 1965777488 19.352 99 26 52 1 1980602848 8054592 6770768
01:05:12 47432 8192000000 10923542176 11386699776 1965392192 19.349 99 40 79 1 1988768496 12518352 10857952
01:06:12 103320 8192000000 10912036320 11409657856 1962399312 19.325 99 13 26 0 1982302416 15988672 3914432
01:08:02 147755 8192000000 10921933504 11406434304 1968615504 19.374 99 10 20 1 1993374368 21716432 3042432
01:10:46 63669 8192000000 10912543856 11409199104 1970863840 19.392 99 13 26 1 1991559776 17202896 3493040
01:11:56 65760 8192000000 10919030416 11389251584 1928914752 19.058 97 23 46 1 1946432816 10828992 6689072
01:13:12 14159 8192000000 10922998288 11376107520 1951900160 19.242 98 47 95 2 1974361520 9583920 12877440
01:13:38 35302 8192000000 10914722608 11392507904 1975564992 19.430 100 37 74 1 1998980400 13006208 10409200
01:14:36 130038 8192000000 10878446608 11358183424 1905861136 18.873 97 16 32 1 1919010144 9054688 4094320
01:16:52 73445 8192000000 10904318400 11383554048 1970402960 19.389 100 19 36 2 1992141776 16978112 4760704
01:18:12 80607 8192000000 10868584544 11363762176 1909607984 18.904 97 20 39 0 1929130960 13985008 5537968
01:19:38 37601 8192000000 10864975584 11361660928 1939002800 19.139 99 5 10 1 1948120000 8075312 1041888
01:20:23 44248 8192000000 10886890192 11367550976 1961069392 19.315 100 17 34 1 1974503840 7953488 5480960
01:21:18 73128 8192000000 10869510432 11341508608 1884008992 18.697 96 15 30 0 1896535440 8146768 4379680
01:22:43 61141 8192000000 10884629200 11361378304 1935534496 19.111 99 14 29 0 1954936512 14883360 4518656
01:24:36 74206 8192000000 10863864976 11336589312 1824726992 18.216 93 16 32 2 1836673568 7604672 4341904
01:25:59 56457 8192000000 10878148368 11371061248 1952546448 19.247 100 21 42 3 1975228304 16715888 5965968
01:27:02 24791 8192000000 9124064720 9353682944 289236720 3.410 15 2 2 1 293736848 4080448 419680

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 12-03-2021 01:29:01 to 12-03-2021 01:29:31.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 158 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 12-03-2021 01:29:32 to 12-03-2021 01:29:34.

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          235689
MON$OLDEST_ACTIVE               235690
MON$OLDEST_SNAPSHOT             235690
MON$NEXT_TRANSACTION            235690
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                       2031136
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.33424 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33424 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33424 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33424 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 ---
:37: 
:38: mscs-test-161.budzdorov.ru    Fri Mar 12 01:27:29 2021
:39:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:40: 
:41: 
:42: mscs-test-161.budzdorov.ru    Fri Mar 12 01:27:30 2021
:43:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:44: 
:45: 
:46: mscs-test-161.budzdorov.ru    Fri Mar 12 01:27:37 2021
:47:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:48: 
--- end of diff output ---

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

12.03.21 01:29:35. 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-12 01:29:37 No severe PSQL-related problems occured
12.03.21 01:29:39. End of report.