Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 29.03.2021 22:29
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 17286432 kB
MemAvailable 31518788 kB
Buffers 0 kB
Cached 14415400 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-29 22:28:00
DTS_END                         2021-03-29 22:27:28.3410
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_FILL_MON_CACHE_MEMORY(20:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/54188
TRN_ID                          240783
ATT_ID                          274
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: 9321.00 21064 1118520
customer order: creation 167.70 378 20124
customer order: refuse 13.63 369 1635
order to supplier: creation 44.58 1383 5349
order to supplier: removal 3.56 98726 427
invoice (draft): creation 45.01 3585 5401
invoice (draft): removal 55.23 779 6627
invoice accept: apply 40.04 17878 4805
invoice accept: cancel 50.38 781 6046
customer reserve: creation 3670.86 178 440503
customer reserve: removal 4923.22 56 590786
realization accept: apply 81.73 204 9808
realization accept: cancel 96.79 100 11615
payment from customer: creation 58.18 131 6981
payment from customer: removal 5.48 94 658
payment to supplier: creation 48.50 155 5820
payment to supplier: removal 3.67 116 440
service: total inventory turnovers 4.93 995 591
service: total monetary turnovers 6.60 33 792
service: aggregate perf. data 0.90 16184 108
service: refresh index statistics 0.03 279164 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 29-03-2021 22:29:54 to 29-03-2021 22:29:56.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5135
TEST_TIME 2 5148
TEST_TIME 3 3624
TEST_TIME 4 3568
TEST_TIME 5 3980
TEST_TIME 6 4076
TEST_TIME 7 4323
TEST_TIME 8 4497
TEST_TIME 9 4579
TEST_TIME 10 4961
TEST_TIME 11 5495
TEST_TIME 12 5453
TEST_TIME 13 5587
TEST_TIME 14 5789
TEST_TIME 15 6093
TEST_TIME 16 6277
TEST_TIME 17 6760
TEST_TIME 18 6926
TEST_TIME 19 7466
TEST_TIME 20 7581
TEST_TIME 21 7877
TEST_TIME 22 8329
TEST_TIME 23 8621
TEST_TIME 24 8872
TEST_TIME 25 9155
TEST_TIME 26 9332
TEST_TIME 27 9519
TEST_TIME 28 10074
TEST_TIME 29 10533
TEST_TIME 30 10344
TEST_TIME 31 10097
TEST_TIME 32 10225
TEST_TIME 33 10641
TEST_TIME 34 10468
TEST_TIME 35 10365
TEST_TIME 36 10159
TEST_TIME 37 10195
TEST_TIME 38 10062
TEST_TIME 39 9905
TEST_TIME 40 9946
TEST_TIME 41 9856
TEST_TIME 42 9836
TEST_TIME 43 9863
TEST_TIME 44 9829
TEST_TIME 45 9678
TEST_TIME 46 9714
TEST_TIME 47 9746
TEST_TIME 48 9581
TEST_TIME 49 9730
TEST_TIME 50 9643
TEST_TIME 51 9596
TEST_TIME 52 9551
TEST_TIME 53 9518
TEST_TIME 54 9397
TEST_TIME 55 9294
TEST_TIME 56 9290
TEST_TIME 57 9302
TEST_TIME 58 9298
TEST_TIME 59 9336
TEST_TIME 60 9342
TEST_TIME 61 9432
TEST_TIME 62 9355
TEST_TIME 63 9486
TEST_TIME 64 9510
TEST_TIME 65 9537
TEST_TIME 66 9518
TEST_TIME 67 9586
TEST_TIME 68 9623
TEST_TIME 69 9577
TEST_TIME 70 9677
TEST_TIME 71 9696
TEST_TIME 72 9720
TEST_TIME 73 9609
TEST_TIME 74 9536
TEST_TIME 75 9543
TEST_TIME 76 9444
TEST_TIME 77 9596
TEST_TIME 78 9529
TEST_TIME 79 9440
TEST_TIME 80 9458
TEST_TIME 81 9411
TEST_TIME 82 9340
TEST_TIME 83 9291
TEST_TIME 84 9274
TEST_TIME 85 9192
TEST_TIME 86 9244
TEST_TIME 87 9294
TEST_TIME 88 9292
TEST_TIME 89 9260
TEST_TIME 90 9274
TEST_TIME 91 9335
TEST_TIME 92 9359
TEST_TIME 93 9338
TEST_TIME 94 9307
TEST_TIME 95 9352
TEST_TIME 96 9337
TEST_TIME 97 9371
TEST_TIME 98 9377
TEST_TIME 99 9436
TEST_TIME 100 9415
TEST_TIME 101 9353
TEST_TIME 102 9326
TEST_TIME 103 9320
TEST_TIME 104 9282
TEST_TIME 105 9221
TEST_TIME 106 9228
TEST_TIME 107 9213
TEST_TIME 108 9229
TEST_TIME 109 9278
TEST_TIME 110 9249
TEST_TIME 111 9251
TEST_TIME 112 9212
TEST_TIME 113 9222
TEST_TIME 114 9271
TEST_TIME 115 9283
TEST_TIME 116 9375
TEST_TIME 117 9349
TEST_TIME 118 9426
TEST_TIME 119 9394
TEST_TIME 120 9325

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 29-03-2021 22:29:58 to 29-03-2021 22:30:01.

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 1527610 1527610 0 0.00 0 18699 6 0 0
doc_list_biud 1527610 1527610 0 0.00 0 52440 28 0 0
sp_add_invoice_to_stock 4936 4805 131 2.65 31 190626 17878 0 131
sp_cancel_adding_invoice 6046 6046 0 0.00 4 81935 781 0 0
sp_cancel_client_order 1635 1635 0 0.00 4 16663 370 0 0
sp_cancel_customer_reserve 590786 590786 0 0.00 1 52444 57 0 0
sp_cancel_pay_from_customer 658 658 0 0.00 3 7371 95 0 0
sp_cancel_pay_to_supplier 440 440 0 0.00 3 12689 116 0 0
sp_cancel_supplier_invoice 6635 6627 8 0.12 1 22532 780 0 8
sp_cancel_supplier_order 427 427 0 0.00 7 1130568 98727 0 0
sp_cancel_write_off 11615 11615 0 0.00 1 8419 100 0 0
sp_client_order 20124 20124 0 0.00 4 19770 379 0 0
sp_customer_reserve 440503 440503 0 0.00 0 99990 179 0 0
sp_fill_shopping_cart 30870 30870 0 0.00 1 22556 37 0 0
sp_fill_shopping_cart_clo_res 440497 440497 0 0.00 0 26811 13 0 0
sp_get_clo_for_invoice 4797 4797 0 0.00 0 25667 301 0 0
sp_kill_cost_storno 18759 18759 0 0.00 0 12681 54 0 0
sp_kill_qstorno_ret_qs2qd 1200241 1200241 0 0.00 0 52428 31 0 0
sp_kill_qty_storno 631741 631741 0 0.00 0 52437 66 0 0
sp_lock_selected_doc 20243 20243 0 0.00 0 9637 6 0 0
sp_make_cost_storno 27406 27406 0 0.00 0 18632 63 0 0
sp_multiply_rows_for_pdistr 27406 27406 0 0.00 0 10238 33 0 0
sp_multiply_rows_for_qdistr 20124 20124 0 0.00 0 15112 183 0 0
sp_pay_from_customer 6981 6981 0 0.00 4 13031 131 0 0
sp_pay_to_supplier 5820 5820 0 0.00 5 13976 155 0 0
sp_payment_common 12801 12801 0 0.00 1 13005 43 0 0
sp_qd_handle_on_cancel_clo 1635 1635 0 0.00 0 16656 337 0 0
sp_qd_handle_on_invoice_upd_sts 10843 10843 0 0.00 0 21818 312 0 0
sp_qd_handle_on_reserve_upd_sts 9808 9808 0 0.00 0 13915 61 0 0
sp_reserve_write_off 9808 9808 0 0.00 6 18909 204 0 0
sp_supplier_invoice 5401 5401 0 0.00 6 103731 3586 0 0
sp_supplier_order 5349 5349 0 0.00 5 77848 1383 0 0
srv_aggregate_perf_data 108 108 0 0.00 2868 118417 16184 0 0
srv_fill_mon_cache_memory 156 156 0 0.00 1681 157258 34801 0 0
srv_find_qd_qs_mism 1072730 1072730 0 0.00 0 13894 5 0 0
srv_make_invnt_saldo 591 591 0 0.00 26 29455 995 0 0
srv_make_money_saldo 792 792 0 0.00 1 6903 33 0 0
srv_recalc_idx_stat 4 4 0 0.00 128851 476877 279165 0 0
t$perf-abend:sp_add_invoice_to_stock 131 131 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4805 4805 0 0.00 0 13511 153 0 0
t$perf-norm:sp_cancel_adding_invoice 439 439 0 0.00 0 7098 100 0 0
t$perf-norm:sp_cancel_client_order 1635 1635 0 0.00 0 2088 10 0 0
t$perf-norm:sp_cancel_customer_reserve 676 676 0 0.00 0 513 6 0 0
t$perf-norm:sp_cancel_pay_from_customer 658 658 0 0.00 0 3940 18 0 0
t$perf-norm:sp_cancel_pay_to_supplier 440 440 0 0.00 0 518 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 384 384 0 0.00 0 1089 12 0 0
t$perf-norm:sp_cancel_supplier_order 427 427 0 0.00 0 32380 1586 0 0
t$perf-norm:sp_cancel_write_off 979 979 0 0.00 0 1799 9 0 0
t$perf-norm:sp_client_order 20124 20124 0 0.00 0 10078 17 0 0
t$perf-norm:sp_customer_reserve 1022 1022 0 0.00 0 909 4 0 0
t$perf-norm:sp_pay_from_customer 6981 6981 0 0.00 0 6697 9 0 0
t$perf-norm:sp_pay_to_supplier 5820 5820 0 0.00 0 3362 6 0 0
t$perf-norm:sp_reserve_write_off 9808 9808 0 0.00 0 6620 9 0 0
t$perf-norm:sp_supplier_invoice 5401 5401 0 0.00 0 11415 16 0 0
t$perf-norm:sp_supplier_order 5349 5349 0 0.00 0 3406 15 0 0
t$perf-norm:srv_aggregate_perf_data 108 108 0 0.00 0 599 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 156 156 0 0.00 0 811 8 0 0
t$perf-norm:srv_make_invnt_saldo 591 591 0 0.00 0 1313 22 0 0
t$perf-norm:srv_make_money_saldo 792 792 0 0.00 0 1498 18 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 148 39 0 0
v_add_invoice_to_stock 9856 9594 262 2.65 0 6518 21 0 262
v_all_customers 36934 36934 0 0.00 0 12 1 0 0
v_all_suppliers 29810 29810 0 0.00 0 16 1 0 0
v_all_wares 40248 40248 0 0.00 0 20 1 0 0
v_cancel_adding_invoice 878 878 0 0.00 0 1254 6 0 0
v_cancel_client_order 3270 3270 0 0.00 0 8095 9 0 0
v_cancel_customer_prepayment 1316 1316 0 0.00 0 3622 9 0 0
v_cancel_customer_reserve 1352 1352 0 0.00 0 895 4 0 0
v_cancel_payment_to_supplier 880 880 0 0.00 0 1464 7 0 0
v_cancel_supplier_invoice 784 768 16 2.04 0 2202 20 0 16
v_cancel_supplier_order 854 854 0 0.00 0 1754 8 0 0
v_cancel_write_off 1958 1958 0 0.00 0 6161 21 0 0
v_max_id_clo_ord 5348 5348 0 0.00 0 1403 2 0 0
v_max_id_clo_res 1022 1022 0 0.00 0 4270 16 0 0
v_max_id_ord_sup 5398 5398 0 0.00 0 5268 5 0 0
v_max_non_paid_invoice 1661 1661 0 0.00 0 190 2 0 0
v_max_non_paid_realizn 3732 3732 0 0.00 0 4545 5 0 0
v_min_id_clo_ord 5348 5348 0 0.00 0 12660 16 0 0
v_min_id_clo_res 1022 1022 0 0.00 0 5045 7 0 0
v_min_id_ord_sup 5398 5398 0 0.00 0 6411 11 0 0
v_min_non_paid_invoice 5820 5820 0 0.00 0 10313 33 0 0
v_min_non_paid_realizn 6981 6981 0 0.00 0 8567 26 0 0
v_our_firm 9812 9812 0 0.00 0 21 1 0 0
v_reserve_write_off 19616 19616 0 0.00 0 6633 9 0 0
x_lock_depdocs_on_canc_invoice 12289 12289 0 0.00 0 10611 108 0 0
x_lock_depdocs_on_canc_sup_ord 427 427 0 0.00 0 36317 420 0 0
x_make_qstorno_1000_1200 5349 5349 0 0.00 2 77830 1294 0 0
x_make_qstorno_1200_2000 5401 5401 0 0.00 3 97319 3464 0 0
x_make_qstorno_2100_3300 440503 440503 0 0.00 0 99988 163 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 29-03-2021 22:30:02 to 29-03-2021 22:30:06.

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:31 4 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:38 17399 8192000000 10224702192 10541391872 940196592 10.295 75 57 116 0 961793008 2616704 18979712
19:58:04 39441 8192000000 10352217296 10665680896 1386041376 14.471 100 87 172 2 1419427120 5188512 28197232
19:58:53 28676 8192000000 10392718112 10712666112 1442204592 14.969 100 92 184 1 1479642336 7134640 30303104
19:59:34 3281 8192000000 10395415328 10717970432 1451818736 15.054 100 91 182 0 1489744592 8047616 29878240
19:59:48 28130 8192000000 10415279632 10741768192 1464418320 15.165 100 90 180 0 1502243568 8577024 29248224
20:00:25 22445 8192000000 10432427920 10760609792 1480979104 15.310 100 91 182 0 1519364592 9207792 29177696
20:00:56 23456 8192000000 10447564624 10782674944 1495893760 15.440 100 87 174 1 1533707264 9654864 28158640
20:01:30 16029 8192000000 10457095216 10798137344 1519432816 15.645 100 82 165 0 1555474784 10134736 25907232
20:01:55 23839 8192000000 10497536288 10844712960 1556564704 15.967 100 82 164 1 1592454080 10393216 25496160
20:02:27 12281 8192000000 10526308176 10880135168 1584743920 16.209 100 76 152 1 1618693136 11106480 22842736
20:02:47 16248 8192000000 10554911376 10914406400 1613739136 16.457 100 81 162 1 1649377536 11287248 24351152
20:03:11 13650 8192000000 10580450864 10939564032 1635858032 16.645 100 86 172 1 1674114064 12032288 26223744
20:03:32 8094 8192000000 10591594688 10955833344 1646237088 16.733 100 77 152 0 1681406240 12167440 23001712
20:03:50 10039 8192000000 10621592400 10988380160 1673947120 16.966 100 70 138 0 1705525456 11639712 19938624
20:04:10 6558 8192000000 10632931152 11002335232 1698446032 17.172 100 76 152 0 1731741248 11815984 21479232
20:04:23 9970 8192000000 10655650048 11026092032 1712901584 17.293 100 76 152 1 1747091808 12669024 21521200
20:04:40 7376 8192000000 10673986608 11050045440 1736013968 17.486 100 80 160 1 1771390864 12742928 22633968
20:04:54 8068 8192000000 10688075472 11065982976 1747852416 17.584 100 83 165 1 1783363824 12485072 23026336
20:05:10 4149 8192000000 10703002672 11076378624 1760691888 17.690 100 81 163 0 1796563536 13053264 22818384
20:05:21 4927 8192000000 10710661312 11087892480 1769092304 17.760 100 81 161 2 1805434544 13792928 22549312
20:05:33 5345 8192000000 10721505600 11100409856 1779610816 17.846 100 87 175 2 1818169632 13668880 24889936
20:05:48 3563 8192000000 10727162880 11107295232 1788470128 17.919 100 84 164 0 1824956544 13517008 22969408
20:05:58 4002 8192000000 10722122032 11109052416 1789707904 17.929 100 80 160 1 1826728608 14485888 22534816
20:06:09 5242 8192000000 10731927856 11116924928 1792053504 17.949 100 75 150 1 1827729056 14683152 20992400
20:06:21 3967 8192000000 10754984848 11138834432 1800133648 18.015 100 84 169 1 1838533520 15056448 23343424
20:06:32 2648 8192000000 10759145408 11143249920 1816887664 18.152 100 90 180 1 1857566944 15860048 24819232
20:06:42 2233 8192000000 10765741616 11145105408 1820816464 18.184 100 89 176 1 1859385456 14346448 24222544
20:06:52 2322 8192000000 10766978176 11151851520 1825412192 18.222 100 89 177 3 1863474544 13497408 24564944
20:07:02 3812 8192000000 10773070112 11160862720 1832782416 18.282 100 85 172 3 1870656256 13729744 24144096
20:07:12 1918 8192000000 10781567936 11168972800 1840088544 18.342 100 88 177 1 1878608720 14085472 24434704
20:07:20 1557 8192000000 10788599872 11172859904 1843967680 18.373 100 88 176 1 1881754688 13195712 24591296
20:07:28 2437 8192000000 10788438112 11175297024 1845931104 18.389 100 93 188 1 1885843104 13671584 26240416
20:07:37 2048 8192000000 10793905344 11183513600 1851267200 18.432 100 84 170 0 1886892848 12279872 23345776
20:07:46 1969 8192000000 10801838592 11186933760 1855075536 18.463 100 97 195 2 1895332448 12848448 27408464
20:07:54 1345 8192000000 10805077936 11190439936 1859331744 18.498 100 95 186 2 1899932912 14152272 26448896
20:08:02 1795 8192000000 10808698672 11192516608 1861710112 18.517 100 90 180 0 1901341792 13383696 26247984
20:08:11 1685 8192000000 10801992656 11194621952 1864420496 18.539 100 84 169 0 1900673136 11986768 24265872
20:08:18 24243 8192000000 10792097696 11194257408 1867051632 18.560 100 73 146 0 1899417216 12145968 20219616
20:08:50 20573 8192000000 10815292176 11209248768 1873195072 18.610 100 71 141 5 1902327392 8285152 20847168
20:09:17 1858 8192000000 10826004272 11214610432 1875802416 18.631 100 87 175 0 1910725408 10196240 24726752
20:09:25 5238 8192000000 10813800080 11210022912 1874709536 18.622 100 81 161 2 1909295392 12200000 22385856
20:09:36 6032 8192000000 10783289456 11206668288 1869419360 18.580 100 45 90 2 1892349360 10360480 12569520
20:09:50 7759 8192000000 10792050288 11210240000 1870832560 18.591 100 42 84 3 1890802144 7638800 12330784
20:10:06 4363 8192000000 10782536848 11204063232 1870696560 18.590 100 34 68 0 1888046112 7526992 9822560
20:10:17 6262 8192000000 10799237824 11217330176 1874321312 18.619 100 35 70 4 1895536208 11460176 9754720
20:10:30 6559 8192000000 10789203552 11215507456 1876008000 18.633 100 30 57 2 1891308480 7376784 7923696
20:10:44 8555 8192000000 10796356144 11219480576 1880845088 18.672 100 27 53 1 1894696752 6593376 7258288
20:11:00 8595 8192000000 10800183120 11225354240 1882058288 18.682 100 26 50 0 1895386800 6154448 7174064
20:11:22 7585 8192000000 10793424688 11225214976 1888504816 18.734 100 19 38 1 1899978080 6497088 4976176
20:11:37 4873 8192000000 10799082624 11229700096 1888297568 18.732 100 14 28 1 1898513664 6419664 3796432
20:11:49 6489 8192000000 10817606960 11232071680 1892013344 18.762 100 24 47 3 1903911184 5363072 6534768
20:12:04 4304 8192000000 10823144144 11241975808 1897076752 18.803 100 37 74 1 1913581136 6302992 10201392
20:12:19 4663 8192000000 10817170320 11240628224 1895505360 18.790 100 27 54 1 1913833216 10981120 7346736
20:12:33 8317 8192000000 10799291264 11236827136 1899231664 18.820 100 18 36 1 1910775920 6570496 4973760
20:12:49 15645 8192000000 10814074128 11243098112 1901767360 18.841 100 31 63 1 1917716992 6145824 9803808
20:13:17 52469 8192000000 10836628480 11259789312 1904253632 18.860 100 34 68 2 1920682448 5757424 10671392
20:14:22 19590 8192000000 10822463936 11258580992 1910760288 18.913 100 21 42 1 1921919216 5691504 5467424
20:14:49 7273 8192000000 10820146576 11260145664 1912659328 18.928 100 32 65 0 1928779312 5875360 10244624
20:15:04 3178 8192000000 10847964064 11270402048 1918913408 18.978 100 44 88 1 1939503792 7534752 13055632
20:15:16 7788 8192000000 10839340000 11269029888 1917137824 18.964 100 34 68 1 1934819616 7818272 9863520
20:15:31 5846 8192000000 10832747472 11269337088 1918755600 18.977 100 36 72 1 1935500224 6040176 10704448
20:15:45 9361 8192000000 10840608096 11265343488 1911299552 18.917 100 25 50 1 1924598080 5825584 7472944
20:16:02 5416 8192000000 10829438896 11265519616 1912533504 18.927 100 27 52 1 1930421184 10176240 7711440
20:16:17 8659 8192000000 10826562144 11262865408 1917417648 18.966 100 31 62 0 1932138176 5372880 9347648
20:16:32 9601 8192000000 10799020128 11238879232 1888386544 18.733 99 18 36 3 1899866816 6184032 5296240
20:16:48 8753 8192000000 10824731424 11257114624 1911127184 18.916 100 30 60 1 1931014512 11007808 8879520
20:17:07 5135 8192000000 10794153216 11210870784 1839031216 18.333 97 24 48 3 1851449104 5090832 7327056
20:17:18 7470 8192000000 10786424432 11224072192 1854401024 18.458 98 21 42 0 1866368816 5613776 6354016
20:17:34 9579 8192000000 10774017584 11201961984 1788705872 17.921 95 14 28 0 1798260112 5373696 4180544
20:17:49 8215 8192000000 10755579344 11177746432 1768535616 17.755 95 15 29 2 1778323680 5790944 3997120
20:18:05 57768 8192000000 10752972000 11168088064 1711077376 17.278 92 45 86 3 1730085776 5246560 13761840
20:19:21 16663 8192000000 10688115408 11100225536 1584654176 16.208 87 21 42 2 1595776288 5862016 5260096
20:19:44 5054 8192000000 10696566576 11115061248 1773007360 17.792 99 30 60 0 1787211824 6321744 7882720
20:19:57 5911 8192000000 10692682144 11099217920 1731240976 17.446 97 27 54 1 1744601232 5884192 7476064
20:20:10 3654 8192000000 10702489584 11107803136 1746294368 17.571 98 45 90 1 1766914624 8027696 12592560
20:20:19 4457 8192000000 10709445504 11124776960 1792491568 17.952 100 37 74 2 1809426720 6026704 10908448
20:20:30 8299 8192000000 10701208480 11120181248 1767356176 17.745 98 32 64 1 1783042048 6465424 9220448
20:20:47 4036 8192000000 10683251536 11093495808 1702253984 17.204 95 36 72 3 1723185728 10033808 10897936
20:20:59 4733 8192000000 10704951872 11104120832 1727669968 17.416 97 37 71 2 1748119264 9235264 11214032
20:21:10 7763 8192000000 10691349200 11112894464 1766143344 17.735 99 28 56 0 1780381216 5731360 8506512
20:21:24 7513 8192000000 10705627712 11126480896 1767807008 17.749 98 24 48 1 1780906352 6321408 6777936
20:21:42 7435 8192000000 10697403232 11114102784 1776296672 17.819 98 30 59 4 1790605808 6534272 7774864
20:21:58 14352 8192000000 10730590160 11151425536 1799768992 18.012 99 24 46 2 1816366528 9912960 6684576
20:22:19 9418 8192000000 10753369840 11172368384 1823155904 18.203 100 18 35 2 1838415200 9862272 5397024
20:22:36 10341 8192000000 10740920608 11160215552 1809242592 18.090 99 32 64 2 1824135168 5086544 9806032
20:22:54 17458 8192000000 10739277024 11168206848 1829712016 18.257 100 35 71 3 1850657968 10227616 10718336
20:23:17 65327 8192000000 10730339792 11162501120 1798901120 18.005 98 16 32 1 1808351792 4761408 4689264
20:24:29 7930 8192000000 10751160240 11175153664 1832687600 18.281 100 22 44 1 1848905072 10322192 5895280
20:24:43 8554 8192000000 10771490928 11189473280 1842249680 18.359 100 30 60 0 1857853120 6560528 9042912
20:24:59 5341 8192000000 10780587984 11195662336 1848413152 18.409 100 46 93 4 1872707184 11224128 13069904
20:25:17 3589 8192000000 10790732032 11204739072 1857937104 18.487 100 50 100 1 1879281392 6130816 15213472
20:25:30 6639 8192000000 10773031648 11202957312 1859577136 18.500 100 33 64 2 1875968448 6907168 9484144
20:25:44 5876 8192000000 10775288624 11206479872 1860505328 18.507 100 27 54 0 1878744256 10351264 7887664
20:25:58 7943 8192000000 10768788944 11200479232 1861576704 18.516 100 34 68 1 1877952032 6338000 10037328
20:26:13 10850 8192000000 10774806192 11204874240 1860067776 18.504 100 16 32 0 1870645696 5760784 4817136
20:26:34 14231 8192000000 10777059472 11213266944 1865162080 18.545 100 26 53 0 1878322976 5052736 8108160
20:26:57 12736 8192000000 10793140800 11224408064 1878093936 18.650 100 21 42 0 1889193680 5036560 6063184
20:27:16 17136 8192000000 10813115072 11240050688 1893790688 18.776 100 20 40 1 1904886240 5012944 6082608
20:27:41 17776 8192000000 10828790944 11250380800 1901382512 18.837 100 33 64 3 1915453040 5290048 8780480
20:28:11 24135 8192000000 10844081776 11270217728 1915805200 18.953 100 38 75 0 1933014640 6839936 10369504
20:28:47 60908 8192000000 10857929024 11286310912 1925907008 19.034 100 47 95 1 1946286432 6625504 13753920
20:29:57 112105 8192000000 10872153824 11314819072 1943742704 19.177 100 39 78 2 1967334624 10693520 12898400
20:32:50 13794 8192000000 10889241712 11323072512 1942090688 19.163 99 40 77 2 1968133104 13790944 12251472
20:33:16 5568 8192000000 10906033600 11335856128 1965670480 19.351 100 52 103 2 1996530592 15834736 15025376
20:33:28 11045 8192000000 10915042176 11340820480 1970027312 19.386 100 65 128 0 2005614032 17531872 18054848
20:33:51 6042 8192000000 10917540256 11342925824 1965357344 19.349 100 58 117 0 2002400832 20518224 16525264
20:34:06 6093 8192000000 10926752208 11350052864 1978870272 19.456 100 76 152 3 2022699104 21703008 22125824
20:34:28 7003 8192000000 10933385088 11359514624 1983996032 19.496 100 68 137 2 2025484048 21771344 19716672
20:34:45 4378 8192000000 10927264144 11353767936 1979126512 19.458 100 67 132 1 2021353424 22012160 20214752
20:35:00 9470 8192000000 10932609760 11357396992 1980107904 19.466 100 52 104 0 2018379424 21780000 16491520
20:35:23 30424 8192000000 10929116288 11365482496 1984524864 19.501 100 45 89 2 2021378240 23008160 13845216
20:36:02 12351 8192000000 10944184720 11371659264 1989038128 19.536 100 49 98 3 2029258896 25082528 15138240
20:36:21 5053 8192000000 10947481888 11376136192 1994561200 19.580 100 59 115 4 2037534880 25651120 17322560
20:36:33 13153 8192000000 10950939360 11385864192 1997376048 19.602 100 65 129 0 2043458656 26598928 19483680
20:36:55 28074 8192000000 10941747520 11380535296 1993231488 19.569 100 51 102 2 2037544416 28478080 15834848
20:37:37 11645 8192000000 10952184944 11385380864 1997343104 19.602 100 47 94 0 2038047024 25978912 14725008
20:38:00 5652 8192000000 10940220384 11373989888 1988736784 19.534 100 57 114 2 2033974848 27399056 17839008
20:38:14 5776 8192000000 10941827488 11376082944 1986744144 19.518 100 61 120 2 2033472112 27842880 18885088
20:38:28 3018 8192000000 10941302864 11366825984 1973726448 19.415 99 79 158 2 2027466944 29782464 23958032
20:38:38 6273 8192000000 10942417488 11367952384 1984615360 19.501 100 67 134 1 2032923936 27499776 20808800
20:38:56 2775 8192000000 10953057264 11378479104 1988419712 19.531 100 73 145 1 2037244384 26798368 22026304
20:39:07 4008 8192000000 10960927920 11385483264 1997347680 19.602 100 78 156 3 2048327776 27723664 23256432
20:39:19 3176 8192000000 10956791856 11376250880 1983566512 19.493 100 80 160 0 2040918384 33116688 24235184
20:39:30 5124 8192000000 10945742352 11366191104 1985453328 19.508 100 83 165 1 2039472704 29679040 24340336
20:39:46 2804 8192000000 10939309888 11364876288 1981377504 19.476 100 71 143 1 2032606720 29660080 21569136
20:40:03 12481 8192000000 10921163232 11357876224 1962699280 19.327 99 53 106 0 2009772064 30639472 16433312
20:40:30 7074 8192000000 10936672224 11371884544 1976378704 19.436 100 45 90 2 2023468352 32435312 14654336
20:40:46 18834 8192000000 10934898672 11373391872 1976034544 19.433 100 56 110 1 2032227728 38062736 18130448
20:41:14 9565 8192000000 10943498592 11373879296 1975539216 19.429 100 51 101 2 2027269376 34666928 17063232
20:41:32 2687 8192000000 10956009936 11374317568 1978174464 19.450 100 73 144 3 2036803584 35472192 23156928
20:41:42 9160 8192000000 10939997920 11363373056 1972010656 19.401 100 72 142 1 2032986720 38653712 22322352
20:42:00 6030 8192000000 10922195056 11340926976 1947773648 19.209 100 62 124 1 2004062608 36682384 19606576
20:42:16 7469 8192000000 10933753248 11347918848 1956629184 19.279 100 76 147 2 2018755952 38295904 23830864
20:42:31 5084 8192000000 10934591808 11355525120 1957072928 19.283 100 69 138 3 2018719760 40069472 21577360
20:42:44 5344 8192000000 10963297904 11369619456 1958005648 19.290 99 81 161 0 2024481648 41346912 25129088
20:42:58 1856 8192000000 10950939168 11364761600 1973526336 19.413 100 86 169 1 2039223152 39326784 26370032
20:43:06 3016 8192000000 10952753184 11360706560 1964998672 19.346 100 85 170 1 2031184624 39914400 26271552
20:43:16 3956 8192000000 10930001600 11343704064 1947566640 19.207 100 75 150 2 2010444352 39880224 22997488
20:43:27 2174 8192000000 10933097952 11346173952 1944158176 19.180 99 72 144 0 2007702992 40929584 22615232
20:43:38 7389 8192000000 10935057056 11352436736 1956073504 19.275 100 72 144 1 2021222224 42883536 22265184
20:43:52 3914 8192000000 10920250784 11337519104 1927344224 19.046 99 67 134 2 1993334128 43829376 22160528
20:44:04 2539 8192000000 10935339808 11346436096 1948229920 19.212 100 79 158 2 2015567632 42919440 24418272
20:44:15 2602 8192000000 10932222640 11343556608 1946757168 19.201 100 87 174 2 2017682416 44497840 26427408
20:44:27 1954 8192000000 10926189296 11337125888 1943142624 19.172 100 82 163 1 2012013856 44240080 24631152
20:44:36 3686 8192000000 10934335616 11342888960 1945382848 19.190 100 86 172 2 2017213472 45375584 26455040
20:44:47 2984 8192000000 10946019728 11351035904 1937712480 19.128 99 91 182 2 2008376736 42109424 28554832
20:44:57 2642 8192000000 10963610336 11371077632 1965296000 19.348 100 93 186 3 2036470800 42213792 28961008
20:45:06 4371 8192000000 10913779536 11325538304 1916050624 18.955 99 69 138 0 1978003808 40560800 21392384
20:45:18 5712 8192000000 10897578144 11325923328 1929012960 19.059 100 45 90 1 1985780912 41573504 15194448
20:45:33 9053 8192000000 10903925104 11335290880 1920287824 18.989 99 44 88 1 1977664432 42574752 14801856
20:45:53 3958 8192000000 10912001664 11334053888 1931556608 19.079 100 59 119 1 1995288976 44860736 18871632
20:46:07 4011 8192000000 10924358816 11344551936 1942356624 19.166 100 66 131 2 2011468960 47134752 21977584
20:46:19 3261 8192000000 10948005088 11353411584 1949184512 19.220 100 93 183 2 2026044192 47938768 28920912
20:46:29 1680 8192000000 10941682016 11352375296 1945359168 19.189 100 82 165 1 2020686640 49006096 26321376
20:46:39 6599 8192000000 10929794784 11356729344 1947099856 19.203 100 67 134 3 2017134624 48554384 21480384
20:46:56 8860 8192000000 10925166448 11360948224 1950498080 19.230 100 44 87 1 2006902960 42717712 13687168
20:47:16 9320 8192000000 10927991472 11362488320 1954592608 19.263 100 42 83 0 2010790000 42636576 13560816
20:47:33 2094 8192000000 10947832112 11358928896 1956105904 19.275 100 76 148 3 2021589968 42920080 22563984
20:47:41 5750 8192000000 10939432160 11373494272 1961357136 19.317 100 55 108 3 2023985440 45589648 17038656
20:48:01 10553 8192000000 10947768752 11379585024 1965158384 19.347 100 44 88 1 2026590112 47006704 14425024
20:48:22 3646 8192000000 10972002672 11387850752 1972483248 19.405 100 83 160 2 2048156336 50659728 25013360
20:48:32 1782 8192000000 10985782752 11395809280 1975796992 19.431 100 86 172 3 2059061376 55996656 27267728
20:48:43 2111 8192000000 10982438832 11394932736 1984640336 19.501 100 87 171 0 2062626688 51120080 26866272
20:48:53 2479 8192000000 10979545456 11401940992 1981424992 19.476 100 73 146 0 2057572480 53308688 22838800
20:49:02 7366 8192000000 10962644544 11405406208 1977305552 19.443 100 49 98 0 2047213136 53743184 16164400
20:49:43 20297 8192000000 10927169792 11383685120 1926011952 19.035 98 26 52 3 1988362320 53375312 8975056
20:50:18 20369 8192000000 10926452720 11369091072 1933490320 19.095 99 26 52 3 1990982112 48818864 8672928
20:50:52 29242 8192000000 10914109024 11368501248 1936377024 19.118 99 30 60 2 1996689520 50244512 10067984
20:51:49 14951 8192000000 10926125536 11369406464 1948508464 19.215 100 36 72 1 2012462816 52180080 11774272
20:52:14 15627 8192000000 10920111792 11377618944 1935049456 19.107 99 28 56 1 1997858576 53233184 9575936
20:52:43 43231 8192000000 10909644544 11367927808 1915037824 18.947 98 25 50 2 1962756240 39920256 7798160
20:53:33 36286 8192000000 10901311616 11364319232 1927274208 19.045 99 18 36 2 1975247568 41725648 6247712
20:54:29 19352 8192000000 10905208416 11359584256 1935424640 19.110 100 16 32 0 1986428272 44755440 6248192
20:54:54 25102 8192000000 10894232064 11363393536 1919553072 18.983 99 22 43 1 1974469072 47682064 7233936
20:56:16 30249 8192000000 10899825936 11351146496 1943724272 19.176 100 11 23 0 1958583952 11403264 3456416
20:57:03 54630 8192000000 10908830192 11364589568 1960909536 19.313 100 37 75 3 1991883584 20538256 10435792
20:58:12 50773 8192000000 10896752640 11342082048 1889963104 18.745 96 26 50 2 1923730608 27170896 6596608
20:59:16 51984 8192000000 10896048144 11364884480 1947042880 19.203 100 12 24 0 1980355696 29494576 3818240
21:00:38 36480 8192000000 10899258080 11332218880 1914630944 18.944 98 34 66 0 1932750256 8632704 9486608
21:01:26 19067 8192000000 10870234992 11326775296 1926150016 19.036 99 12 24 0 1939413888 10268960 2994912
21:01:52 30063 8192000000 10883514544 11332202496 1919899600 18.986 99 26 53 1 1940527504 12244064 8383840
21:02:35 94173 8192000000 10900128368 11344818176 1927733632 19.049 99 27 54 0 1949665424 14434592 7497200
21:04:21 52912 8192000000 10893893952 11352387584 1919209680 18.981 98 31 62 2 1944548400 16925648 8413072
21:05:22 157257 8192000000 10904732528 11346182144 1895627984 18.791 97 27 54 2 1922758816 19194528 7936304
21:08:06 15291 8192000000 10926184480 11352027136 1952240160 19.244 99 54 106 5 1978468832 10490176 15738496
21:08:42 30093 8192000000 10917450224 11367399424 1974629888 19.422 100 44 89 1 2002345776 14018144 13697744
21:09:23 22090 8192000000 10912828000 11375226880 1978742512 19.455 100 43 85 2 2005213472 14584064 11886896
21:09:56 56753 8192000000 10904052688 11377377280 1971292080 19.396 100 19 38 2 1989452624 12566848 5593696
21:10:59 46636 8192000000 10896054768 11373432832 1974390960 19.420 100 8 16 0 1987033520 10374736 2267824
21:12:13 63700 8192000000 10912948320 11384733696 1984175152 19.498 100 26 52 0 2005474464 13574480 7724832
21:13:22 57039 8192000000 10914038336 11385634816 1979451040 19.460 100 13 24 3 2001534240 17806192 4277008
21:14:27 26748 8192000000 10907602672 11387256832 1980981712 19.472 100 4 8 0 1993201904 11160816 1059376
21:15:00 31599 8192000000 10896730976 11368087552 1963598112 19.335 99 7 14 1 1977267296 11608080 2061104
21:15:38 92487 8192000000 10913099088 11397058560 1964493728 19.342 99 21 42 1 1985719760 14823552 6402480
21:17:21 69981 8192000000 10904698320 11377745920 1963855216 19.337 99 20 41 0 1979122928 9697648 5570064
21:18:38 21910 8192000000 10914618224 11383885824 1986726784 19.518 100 27 53 0 2003396304 9319968 7349552
21:19:08 30543 8192000000 10922946128 11396833280 1993145264 19.569 100 32 64 1 2015193280 12790960 9257056
21:19:46 54571 8192000000 10911217984 11391922176 1993383728 19.571 100 13 26 1 2007132176 10075296 3673152
21:20:55 81257 8192000000 10897189776 11375296512 1936924864 19.122 97 14 28 1 1950663488 9563648 4174976
21:22:32 66885 8192000000 10892748992 11372208128 1958079232 19.291 99 14 28 1 1977185680 14199248 4907200
21:23:49 68634 8192000000 10909920880 11384770560 1928928656 19.058 98 10 20 1 1946118848 14650368 2539824
21:25:04 41544 8192000000 10890818192 11367555072 1937211600 19.124 98 21 42 1 1955428096 11936592 6279904
21:25:52 73205 8192000000 10877226656 11332157440 1840414352 18.344 93 22 44 1 1862421248 16346880 5660016
21:27:11 60316 8192000000 10855643008 11329921024 1865422496 18.547 96 26 53 2 1884619344 11703232 7493616
21:28:18 53541 8192000000 10871131408 11338481664 1909613296 18.904 98 14 28 1 1922637200 9433040 3590864
21:29:18 79198 8192000000 10878571200 11358064640 1919928432 18.986 98 17 34 0 1942427552 18002176 4496944
21:30:43 42736 8192000000 10901543824 11367919616 1961557152 19.318 100 19 38 1 1974837488 8315072 4965264
21:31:32 43249 8192000000 10909079232 11369934848 1917858992 18.970 97 15 30 2 1930395040 9032112 3503936
21:32:22 58442 8192000000 10885029808 11344044032 1873106448 18.609 95 20 40 3 1888718736 10031568 5580720
21:33:28 54517 8192000000 10889577232 11340996608 1889389008 18.741 96 45 90 0 1915874400 13721056 12764336
21:34:34 61578 8192000000 10869582608 11343654912 1883548272 18.694 97 11 22 0 1904067472 17634144 2885056
21:35:41 118545 8192000000 10831103536 11309563904 1821578288 18.191 94 19 38 0 1839061664 11950016 5533360
21:37:47 86200 8192000000 10835842528 11311210496 1795796272 17.979 93 12 24 1 1813233264 14401760 3035232
21:39:19 156197 8192000000 10861090640 11318484992 1841239872 18.351 96 22 44 0 1857314752 9300944 6773936
21:42:07 67724 8192000000 10866613280 11329597440 1893116432 18.771 98 34 68 1 1925658448 22994384 9547632
21:43:31 12619 8192000000 10863697408 11323150336 1905768496 18.873 99 33 66 2 1931740048 16448880 9522672
21:43:55 51491 8192000000 10856143376 11335532544 1917473600 18.967 100 28 56 2 1945798432 20279824 8045008
21:46:28 37613 8192000000 10865539056 11325632512 1903032320 18.851 98 40 80 1 1927527264 13330944 11164000
21:47:12 56977 8192000000 10854241552 11333423104 1918727776 18.977 99 8 16 0 1929209744 8283408 2198560
21:48:16 64108 8192000000 10831244416 11310174208 1895981776 18.794 98 10 20 0 1907480480 8780688 2718016
21:49:26 52205 8192000000 10842603696 11321634816 1914100128 18.940 99 14 28 2 1927270192 9291872 3878192
21:50:25 61320 8192000000 10848082640 11325534208 1901669632 18.840 98 16 32 1 1917925344 11366272 4889440
21:51:32 47576 8192000000 10853116096 11337805824 1937843392 19.130 100 8 16 0 1952632352 12359808 2429152
21:52:56 40641 8192000000 10862517920 11357356032 1926341856 19.038 99 8 16 0 1947989984 19242656 2405472
21:53:47 51002 8192000000 10859409152 11346673664 1905677376 18.872 98 15 30 2 1923033472 13239152 4116944
21:54:44 81112 8192000000 10870423344 11341959168 1891102032 18.755 97 23 46 0 1908892768 11119104 6671632
21:56:14 65310 8192000000 10900807216 11370016768 1960268384 19.308 100 24 48 3 1981727552 13997360 7461808
21:57:26 58396 8192000000 10893276768 11375235072 1954640688 19.263 99 23 46 0 1973397664 11870928 6886048
21:58:33 106921 8192000000 10874824384 11348279296 1831999280 18.276 93 13 26 0 1843727968 8300752 3427936
22:00:26 55321 8192000000 10918142160 11385430016 1970336000 19.388 100 31 62 0 1988099744 9042000 8721744
22:01:33 44858 8192000000 10913271168 11367960576 1939277744 19.141 98 44 88 2 1965862688 14512624 12072320
22:02:24 43373 8192000000 10913605440 11375026176 1954696560 19.264 99 29 58 1 1975362864 13070304 7596000
22:03:20 16618 8192000000 10920429712 11371458560 1962704256 19.328 99 47 94 2 1986824016 11180560 12939200
22:03:45 37605 8192000000 10930286064 11389300736 1963094064 19.331 99 38 76 0 1986523264 12649200 10780000
22:04:31 102825 8192000000 10915927296 11400278016 1954348800 19.261 99 17 34 1 1974531056 15787776 4394480
22:06:19 67745 8192000000 10916700912 11387965440 1966184624 19.355 99 24 48 2 1985712288 13203120 6324544
22:07:35 15113 8192000000 10903781040 11350036480 1922057792 19.003 97 38 77 2 1939334880 6736240 10540848
22:07:59 22139 8192000000 10930672576 11376816128 1977456928 19.445 100 60 119 0 2002877600 9143696 16276976
22:08:28 92612 8192000000 10920105728 11385876480 1978180816 19.450 100 34 68 2 1997058384 9106784 9770784
22:10:08 44235 8192000000 10908044672 11393167360 1959767264 19.304 99 18 36 0 1976623520 12191152 4665104
22:11:03 40265 8192000000 10895241120 11382407168 1942356912 19.166 98 12 24 0 1958090224 12666112 3067200
22:12:20 49960 8192000000 10902172496 11382214656 1936224304 19.117 98 6 12 0 1949358016 11030176 2103536
22:13:23 49062 8192000000 10888804656 11390201856 1972937680 19.409 100 6 12 0 1988949888 14323520 1688688
22:14:19 27148 8192000000 10911369568 11397238784 1961138688 19.315 99 19 38 0 1983081440 15721200 6221552
22:14:52 81662 8192000000 10923644544 11410694144 1984656000 19.502 100 14 28 1 2000688800 12329968 3702832
22:16:21 83152 8192000000 10880695440 11365654528 1874743664 18.623 94 18 36 2 1894764160 15291856 4728640
22:17:56 93739 8192000000 10907606256 11385978880 1921137440 18.996 97 21 43 0 1937249104 10326608 5785056
22:19:52 43284 8192000000 10904699552 11378757632 1943169520 19.172 98 25 50 2 1966635408 16025584 7440304
22:20:52 61905 8192000000 10913358032 11399610368 1971709744 19.399 100 12 22 0 1992667744 17761792 3196208
22:22:04 61889 8192000000 10914277296 11397222400 1948942816 19.218 98 17 34 2 1972201328 18104112 5154400
22:23:27 91142 8192000000 10910737152 11381391360 1858896448 18.494 94 14 28 1 1880444176 17609776 3937952
22:25:04 87945 8192000000 10849888480 11318288384 1836982928 18.316 94 16 32 0 1863023392 21691456 4349008
22:26:38 42868 8192000000 10916777456 11359793152 1938313360 19.133 99 50 100 1 1964375024 12160464 13901200

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 131 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 29-03-2021 22:30:40 to 29-03-2021 22:30:41.

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          239852
MON$OLDEST_ACTIVE               243392
MON$OLDEST_SNAPSHOT             243392
MON$NEXT_TRANSACTION            243392
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                       2044704
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.33429 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33429 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33429 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33429 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 ---
:164: 
:165: mscs-test-161.budzdorov.ru    Mon Mar 29 22:28:14 2021
:166:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:167: 
--- end of diff output ---

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

29.03.21 22:30:42. 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-29 22:30:45 No severe PSQL-related problems occured
29.03.21 22:30:46. End of report.