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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-20 16:27:14
DTS_END                         2021-02-20 16:27:14.8000
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/56328
TRN_ID                          237988
ATT_ID                          697
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: 9287.13 16611 1114456
customer order: creation 172.26 375 20671
customer order: refuse 14.97 346 1796
order to supplier: creation 45.89 1224 5507
order to supplier: removal 3.52 106302 422
invoice (draft): creation 45.37 3217 5444
invoice (draft): removal 53.07 836 6368
invoice accept: apply 41.37 19501 4964
invoice accept: cancel 47.66 775 5719
customer reserve: creation 3871.33 192 464559
customer reserve: removal 4694.69 62 563363
realization accept: apply 84.72 195 10166
realization accept: cancel 82.10 115 9852
payment from customer: creation 59.70 126 7164
payment from customer: removal 5.83 93 700
payment to supplier: creation 49.42 128 5930
payment to supplier: removal 3.49 77 419
service: total inventory turnovers 4.88 1155 585
service: total monetary turnovers 6.13 24 736
service: aggregate perf. data 0.73 25016 87
service: refresh index statistics 0.03 172461 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 20-02-2021 16:29:48 to 20-02-2021 16:29:50.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5691
TEST_TIME 2 4837
TEST_TIME 3 4828
TEST_TIME 4 5345
TEST_TIME 5 4816
TEST_TIME 6 4709
TEST_TIME 7 5226
TEST_TIME 8 5901
TEST_TIME 9 6034
TEST_TIME 10 6022
TEST_TIME 11 5905
TEST_TIME 12 6190
TEST_TIME 13 6283
TEST_TIME 14 6587
TEST_TIME 15 6601
TEST_TIME 16 6642
TEST_TIME 17 6902
TEST_TIME 18 7035
TEST_TIME 19 7215
TEST_TIME 20 7642
TEST_TIME 21 7822
TEST_TIME 22 7853
TEST_TIME 23 7861
TEST_TIME 24 7942
TEST_TIME 25 8613
TEST_TIME 26 8945
TEST_TIME 27 9558
TEST_TIME 28 10606
TEST_TIME 29 10389
TEST_TIME 30 10666
TEST_TIME 31 10521
TEST_TIME 32 10364
TEST_TIME 33 10340
TEST_TIME 34 10240
TEST_TIME 35 10078
TEST_TIME 36 9875
TEST_TIME 37 9919
TEST_TIME 38 9976
TEST_TIME 39 9842
TEST_TIME 40 9785
TEST_TIME 41 9826
TEST_TIME 42 9696
TEST_TIME 43 9798
TEST_TIME 44 9662
TEST_TIME 45 9559
TEST_TIME 46 9679
TEST_TIME 47 9659
TEST_TIME 48 9667
TEST_TIME 49 9586
TEST_TIME 50 9556
TEST_TIME 51 9501
TEST_TIME 52 9548
TEST_TIME 53 9563
TEST_TIME 54 9482
TEST_TIME 55 9509
TEST_TIME 56 9590
TEST_TIME 57 9615
TEST_TIME 58 9608
TEST_TIME 59 9678
TEST_TIME 60 9765
TEST_TIME 61 9804
TEST_TIME 62 9746
TEST_TIME 63 9804
TEST_TIME 64 9891
TEST_TIME 65 9791
TEST_TIME 66 9736
TEST_TIME 67 9728
TEST_TIME 68 9684
TEST_TIME 69 9629
TEST_TIME 70 9718
TEST_TIME 71 9655
TEST_TIME 72 9622
TEST_TIME 73 9608
TEST_TIME 74 9567
TEST_TIME 75 9528
TEST_TIME 76 9487
TEST_TIME 77 9431
TEST_TIME 78 9391
TEST_TIME 79 9432
TEST_TIME 80 9377
TEST_TIME 81 9378
TEST_TIME 82 9386
TEST_TIME 83 9364
TEST_TIME 84 9345
TEST_TIME 85 9348
TEST_TIME 86 9376
TEST_TIME 87 9391
TEST_TIME 88 9429
TEST_TIME 89 9459
TEST_TIME 90 9496
TEST_TIME 91 9509
TEST_TIME 92 9541
TEST_TIME 93 9529
TEST_TIME 94 9542
TEST_TIME 95 9566
TEST_TIME 96 9503
TEST_TIME 97 9445
TEST_TIME 98 9398
TEST_TIME 99 9382
TEST_TIME 100 9370
TEST_TIME 101 9373
TEST_TIME 102 9345
TEST_TIME 103 9338
TEST_TIME 104 9341
TEST_TIME 105 9357
TEST_TIME 106 9367
TEST_TIME 107 9345
TEST_TIME 108 9343
TEST_TIME 109 9358
TEST_TIME 110 9324
TEST_TIME 111 9441
TEST_TIME 112 9404
TEST_TIME 113 9412
TEST_TIME 114 9453
TEST_TIME 115 9450
TEST_TIME 116 9447
TEST_TIME 117 9409
TEST_TIME 118 9377
TEST_TIME 119 9365
TEST_TIME 120 9295

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 20-02-2021 16:29:51 to 20-02-2021 16:29:55.

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 1545273 1545273 0 0.00 0 16463 7 0 0
doc_list_biud 1545270 1545270 0 0.00 0 34319 29 0 0
sp_add_invoice_to_stock 5088 4964 124 2.43 44 215317 19502 0 124
sp_cancel_adding_invoice 5719 5719 0 0.00 3 75806 775 0 0
sp_cancel_client_order 1796 1796 0 0.00 4 9391 346 0 0
sp_cancel_customer_reserve 563363 563363 0 0.00 1 34321 62 0 0
sp_cancel_pay_from_customer 700 700 0 0.00 3 8437 93 0 0
sp_cancel_pay_to_supplier 419 419 0 0.00 2 4422 78 0 0
sp_cancel_supplier_invoice 6379 6368 11 0.17 1 20591 836 0 11
sp_cancel_supplier_order 422 422 0 0.00 7 1117089 106303 0 0
sp_cancel_write_off 9852 9852 0 0.00 1 8468 116 0 0
sp_client_order 20671 20671 0 0.00 4 46601 376 0 0
sp_customer_reserve 464559 464559 0 0.00 0 97858 193 0 0
sp_fill_shopping_cart 31612 31612 0 0.00 1 17616 37 0 0
sp_fill_shopping_cart_clo_res 464552 464552 0 0.00 0 14434 12 0 0
sp_get_clo_for_invoice 4953 4953 0 0.00 0 17628 262 0 0
sp_kill_cost_storno 16690 16690 0 0.00 0 8432 60 0 0
sp_kill_qstorno_ret_qs2qd 1143368 1143368 0 0.00 0 34316 34 0 0
sp_kill_qty_storno 602639 602639 0 0.00 0 34318 73 0 0
sp_lock_selected_doc 20991 20991 0 0.00 0 10365 7 0 0
sp_make_cost_storno 28213 28213 0 0.00 0 16455 51 0 0
sp_multiply_rows_for_pdistr 28213 28213 0 0.00 0 8840 31 0 0
sp_multiply_rows_for_qdistr 20671 20671 0 0.00 0 32922 155 0 0
sp_pay_from_customer 7164 7164 0 0.00 4 15625 127 0 0
sp_pay_to_supplier 5930 5930 0 0.00 5 10982 128 0 0
sp_payment_common 13093 13093 0 0.00 1 15619 36 0 0
sp_qd_handle_on_cancel_clo 1796 1796 0 0.00 0 8412 312 0 0
sp_qd_handle_on_invoice_upd_sts 10672 10672 0 0.00 0 27051 340 0 0
sp_qd_handle_on_reserve_upd_sts 10166 10166 0 0.00 0 25487 66 0 0
sp_reserve_write_off 10166 10166 0 0.00 6 25514 195 0 0
sp_supplier_invoice 5444 5444 0 0.00 7 91763 3217 0 0
sp_supplier_order 5507 5507 0 0.00 5 29653 1224 0 0
srv_aggregate_perf_data 87 87 0 0.00 2640 551456 25017 0 0
srv_fill_mon_cache_memory 167 167 0 0.00 1249 139342 32295 0 0
srv_find_qd_qs_mism 1066856 1066856 0 0.00 0 13787 6 0 0
srv_make_invnt_saldo 585 585 0 0.00 53 63843 1156 0 0
srv_make_money_saldo 736 736 0 0.00 1 1439 24 0 0
srv_recalc_idx_stat 4 4 0 0.00 92916 239062 172461 0 0
t$perf-abend:sp_add_invoice_to_stock 124 124 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-norm:sp_add_invoice_to_stock 4964 4964 0 0.00 0 11388 158 0 0
t$perf-norm:sp_cancel_adding_invoice 389 389 0 0.00 0 3990 74 0 0
t$perf-norm:sp_cancel_client_order 1796 1796 0 0.00 0 1162 8 0 0
t$perf-norm:sp_cancel_customer_reserve 688 688 0 0.00 0 2592 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 700 700 0 0.00 0 13642 28 0 0
t$perf-norm:sp_cancel_pay_to_supplier 419 419 0 0.00 0 2104 11 0 0
t$perf-norm:sp_cancel_supplier_invoice 407 407 0 0.00 0 4009 32 0 0
t$perf-norm:sp_cancel_supplier_order 422 422 0 0.00 0 24908 1845 0 0
t$perf-norm:sp_cancel_write_off 1052 1052 0 0.00 0 2701 11 0 0
t$perf-norm:sp_client_order 20671 20671 0 0.00 0 11580 21 0 0
t$perf-norm:sp_customer_reserve 1028 1028 0 0.00 0 1800 6 0 0
t$perf-norm:sp_pay_from_customer 7164 7164 0 0.00 0 7306 14 0 0
t$perf-norm:sp_pay_to_supplier 5930 5930 0 0.00 0 7227 14 0 0
t$perf-norm:sp_reserve_write_off 10166 10166 0 0.00 0 7196 11 0 0
t$perf-norm:sp_supplier_invoice 5444 5444 0 0.00 0 5698 20 0 0
t$perf-norm:sp_supplier_order 5507 5507 0 0.00 0 5214 17 0 0
t$perf-norm:srv_aggregate_perf_data 87 87 0 0.00 0 146 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 167 167 0 0.00 0 3841 25 0 0
t$perf-norm:srv_make_invnt_saldo 585 585 0 0.00 0 3505 33 0 0
t$perf-norm:srv_make_money_saldo 736 736 0 0.00 0 945 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 4 0 0
v_add_invoice_to_stock 10150 9902 248 2.44 0 11757 19 0 248
v_all_customers 37776 37776 0 0.00 0 36 1 0 0
v_all_suppliers 30702 30702 0 0.00 0 20 1 0 0
v_all_wares 41340 41340 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 778 778 0 0.00 0 1007 10 0 0
v_cancel_client_order 3592 3592 0 0.00 0 8629 8 0 0
v_cancel_customer_prepayment 1400 1400 0 0.00 0 317 2 0 0
v_cancel_customer_reserve 1376 1376 0 0.00 0 4195 9 0 0
v_cancel_payment_to_supplier 838 838 0 0.00 0 563 4 0 0
v_cancel_supplier_invoice 836 814 22 2.63 0 528 15 0 22
v_cancel_supplier_order 844 844 0 0.00 0 890 7 0 0
v_cancel_write_off 2104 2104 0 0.00 0 2602 12 0 0
v_max_id_clo_ord 5507 5507 0 0.00 0 463 1 0 0
v_max_id_clo_res 1028 1028 0 0.00 0 7413 22 0 0
v_max_id_ord_sup 5435 5435 0 0.00 0 7043 4 0 0
v_max_non_paid_invoice 1521 1521 0 0.00 0 2879 8 0 0
v_max_non_paid_realizn 3748 3748 0 0.00 0 1241 4 0 0
v_min_id_clo_ord 5507 5507 0 0.00 0 12123 8 0 0
v_min_id_clo_res 1028 1028 0 0.00 0 9102 23 0 0
v_min_id_ord_sup 5435 5435 0 0.00 0 5604 7 0 0
v_min_non_paid_invoice 5930 5930 0 0.00 0 8030 19 0 0
v_min_non_paid_realizn 7163 7163 0 0.00 0 8490 25 0 0
v_our_firm 10394 10394 0 0.00 0 18 1 0 0
v_reserve_write_off 20332 20332 0 0.00 0 12019 7 0 0
x_lock_depdocs_on_canc_invoice 11680 11680 0 0.00 0 19153 117 0 0
x_lock_depdocs_on_canc_sup_ord 422 422 0 0.00 0 20280 442 0 0
x_make_qstorno_1000_1200 5507 5507 0 0.00 1 29640 1142 0 0
x_make_qstorno_1200_2000 5444 5444 0 0.00 3 87811 3088 0 0
x_make_qstorno_2100_3300 464559 464559 0 0.00 0 97856 178 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 20-02-2021 16:29:56 to 20-02-2021 16:30:00.

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
13:57:18 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:24 24495 8192000000 10278275776 10585636864 1054680976 11.406 83 59 119 1 1077761184 2831472 20248736
13:57:55 22676 8192000000 10339463120 10652979200 1384254000 14.455 100 82 164 1 1415460576 4774736 26431840
13:58:30 28296 8192000000 10384289024 10705997824 1431685184 14.876 100 91 182 0 1467832416 6087296 30059936
13:59:08 25848 8192000000 10409381616 10735783936 1465879440 15.178 100 94 187 0 1503832592 7226672 30726480
13:59:41 14671 8192000000 10422911392 10747785216 1476897584 15.274 100 90 180 0 1514276704 7696960 29682160
14:00:06 25554 8192000000 10441150176 10772176896 1494115024 15.425 100 90 179 0 1531649248 8382144 29152080
14:00:44 29126 8192000000 10454178624 10794422272 1510982304 15.572 100 86 172 1 1547611120 8843184 27785632
14:01:21 10955 8192000000 10465272640 10806775808 1527131216 15.712 100 85 170 0 1562959472 8923840 26904416
14:01:43 17916 8192000000 10498714128 10846461952 1554810256 15.951 100 77 152 1 1587920528 9221424 23888848
14:02:17 13343 8192000000 10524881840 10877501440 1583878112 16.201 100 77 152 1 1616335728 9069472 23388144
14:02:46 12344 8192000000 10556912880 10917707776 1613959120 16.458 100 80 157 3 1647452848 9494288 23999440
14:03:08 9278 8192000000 10588545888 10950488064 1645810960 16.729 100 75 149 1 1678160368 10524928 21824480
14:03:29 14081 8192000000 10614726032 10982080512 1675878000 16.983 100 76 152 5 1708950416 11255392 21817024
14:03:50 9629 8192000000 10640700672 11011899392 1698466160 17.172 100 77 153 2 1732358896 11779440 22113296
14:04:09 10714 8192000000 10661026176 11033485312 1717932976 17.335 100 79 158 1 1753210800 12424432 22853392
14:04:29 8373 8192000000 10674042640 11056082944 1736138800 17.487 100 75 150 0 1769832080 12131152 21562128
14:04:45 7249 8192000000 10693500144 11069227008 1750767552 17.608 100 72 144 1 1783388656 12060688 20560416
14:05:03 6342 8192000000 10702910944 11078844416 1761849936 17.700 100 77 153 1 1796717488 13099856 21767696
14:05:18 6097 8192000000 10717312656 11091873792 1775100864 17.809 100 85 171 1 1812585152 14021296 23462992
14:05:32 5079 8192000000 10711384272 11089506304 1779233184 17.843 100 77 154 0 1814750592 14144304 21373104
14:05:53 5313 8192000000 10718082624 11101990912 1780186096 17.851 100 74 147 2 1814528816 13958032 20384688
14:06:06 3715 8192000000 10737708608 11123281920 1794935392 17.972 100 73 146 1 1829509760 13322496 21251872
14:06:20 5187 8192000000 10747470144 11133358080 1804373376 18.050 100 77 152 1 1838789376 13171360 21244640
14:06:33 3274 8192000000 10755753440 11141025792 1817363696 18.156 100 83 166 1 1853496304 11325344 24807264
14:06:42 2457 8192000000 10763163920 11153207296 1826377344 18.230 100 82 156 2 1860094336 11987760 21729232
14:06:52 2891 8192000000 10774899104 11164160000 1835265184 18.302 100 86 169 1 1871069952 11990272 23814496
14:07:02 2522 8192000000 10783952320 11172204544 1844812720 18.380 100 87 175 1 1881571376 12786848 23971808
14:07:12 2249 8192000000 10785745920 11175247872 1848279600 18.408 100 92 184 1 1887562608 13283024 25999984
14:07:21 1832 8192000000 10799201696 11186270208 1853789408 18.453 100 91 183 1 1892548560 12924064 25835088
14:07:29 1560 8192000000 10800176048 11190185984 1853350112 18.449 100 87 178 0 1892179440 13648272 25181056
14:07:37 1535 8192000000 10792921200 11183648768 1857889856 18.486 100 87 174 0 1894829120 12993168 23946096
14:07:45 1637 8192000000 10807489776 11195199488 1862683968 18.525 100 93 188 0 1902930896 14317088 25929840
14:07:53 1907 8192000000 10808605664 11197755392 1863529520 18.532 100 92 184 1 1904825216 15894720 25400976
14:08:01 1850 8192000000 10808739936 11199193088 1864922416 18.543 100 87 175 3 1903042720 13459648 24660656
14:08:09 1868 8192000000 10813241488 11202621440 1869987920 18.584 100 94 189 0 1909812368 13167392 26657056
14:08:18 1463 8192000000 10818380304 11207778304 1871195952 18.594 100 95 188 2 1911239008 13401600 26641456
14:08:25 20008 8192000000 10781309120 11200143360 1867700128 18.566 100 64 127 2 1896480224 10225744 18554352
14:08:53 5516 8192000000 10789016208 11198611456 1869004352 18.576 100 40 80 1 1893863216 12883120 11975744
14:09:07 3927 8192000000 10790784464 11204149248 1871876848 18.599 100 54 108 0 1895856128 8522464 15456816
14:09:18 5038 8192000000 10787238944 11207106560 1870723136 18.590 100 35 70 1 1888752592 7998992 10030464
14:09:31 4875 8192000000 10799029376 11210907648 1873058464 18.609 100 37 74 0 1891510960 8244624 10207872
14:09:45 7268 8192000000 10781316016 11207929856 1876027504 18.633 100 32 64 0 1891828224 7063040 8737680
14:10:00 6199 8192000000 10782936688 11206918144 1873670768 18.614 100 22 44 1 1886001280 5566848 6763664
14:10:13 10230 8192000000 10782688240 11212992512 1873588448 18.613 100 18 36 0 1885187936 6815904 4783584
14:10:33 10753 8192000000 10787529616 11215884288 1879069856 18.658 100 15 30 0 1889001952 5990288 3941808
14:10:51 9820 8192000000 10781485584 11216752640 1882291824 18.684 100 31 62 1 1897236880 5994864 8950192
14:11:09 16934 8192000000 10800222304 11222941696 1885746736 18.711 100 28 56 1 1900530320 6278640 8504944
14:11:34 58696 8192000000 10834021760 11240607744 1891749504 18.760 100 47 95 1 1910231632 4917008 13565120
14:12:39 4320 8192000000 10816092016 11244285952 1897166992 18.804 100 38 76 1 1917289104 9490256 10631856
14:12:52 4940 8192000000 10813981424 11243376640 1899509520 18.822 100 37 74 1 1917370176 7255168 10605488
14:13:04 5747 8192000000 10822376576 11249319936 1900275408 18.829 100 35 70 0 1917837616 7303280 10258928
14:13:17 4502 8192000000 10837186688 11254140928 1903626864 18.855 100 45 87 1 1923609664 7319136 12663664
14:13:30 3484 8192000000 10821662160 11249242112 1902963968 18.850 100 39 78 1 1921251536 7371008 10916560
14:13:41 7231 8192000000 10820530128 11247284224 1903651456 18.856 100 31 63 1 1920233696 7942064 8640176
14:13:56 5832 8192000000 10830419936 11255611392 1906195936 18.876 100 40 78 0 1924168976 5344160 12628880
14:14:11 7240 8192000000 10818079792 11253182464 1904716448 18.864 100 19 38 3 1916304480 5915120 5672912
14:14:24 6225 8192000000 10814835568 11252101120 1909348672 18.901 100 31 62 0 1923970544 5396752 9225120
14:14:38 5825 8192000000 10822499824 11256573952 1907229136 18.884 100 22 43 1 1920367840 6333968 6804736
14:14:51 7745 8192000000 10829424624 11262296064 1911479152 18.919 100 23 46 4 1924271744 6812304 5980288
14:15:05 5369 8192000000 10830750784 11264434176 1912667424 18.928 100 29 58 2 1930957760 9838144 8452192
14:15:16 19513 8192000000 10818988096 11258540032 1912238352 18.925 100 29 56 4 1926283744 5969968 8075424
14:16:13 30895 8192000000 10830674096 11266764800 1917138176 18.964 100 26 52 0 1930095520 5196464 7760880
14:16:53 6721 8192000000 10817044288 11251019776 1901948896 18.842 99 28 56 1 1915851280 5524224 8378160
14:17:10 4712 8192000000 10839817008 11265982464 1901696240 18.840 99 40 80 2 1921151664 8199056 11256368
14:17:23 3942 8192000000 10827078400 11259736064 1905957056 18.874 100 31 62 1 1926102624 11381488 8764080
14:17:33 6831 8192000000 10827102272 11252039680 1902140016 18.844 100 38 76 1 1920242160 7518176 10583968
14:17:48 2795 8192000000 10815783488 11234910208 1886487216 18.717 100 45 89 3 1909293488 9609008 13197264
14:18:00 6806 8192000000 10782921136 11204907008 1853183568 18.448 99 37 74 0 1870327360 7100224 10043568
14:18:16 5389 8192000000 10801199776 11210731520 1858901744 18.494 99 34 69 2 1875426704 6942368 9582592
14:18:29 8388 8192000000 10782395408 11207380992 1837540160 18.321 98 25 50 0 1851158880 6606928 7011792
14:18:50 4244 8192000000 10767424768 11186835456 1848048656 18.406 100 38 75 3 1866393520 8153664 10191200
14:19:00 4578 8192000000 10711619408 11127152640 1758676528 17.673 96 30 60 1 1774534512 7139776 8718208
14:19:11 5419 8192000000 10721262496 11129004032 1782301920 17.868 99 32 65 0 1799006832 6833904 9871008
14:19:24 7961 8192000000 10696498032 11100438528 1689888288 17.100 94 30 60 2 1704386960 5783744 8714928
14:19:38 7532 8192000000 10678887824 11086114816 1664437888 16.886 93 23 46 0 1676290992 5140704 6712400
14:19:52 5069 8192000000 10658677680 11052535808 1731113872 17.445 98 36 71 1 1746589120 4488080 10987168
14:20:04 30173 8192000000 10679934336 11105202176 1741511152 17.531 97 24 48 0 1754114400 5790080 6813168
14:20:55 16239 8192000000 10730679520 11124596736 1749980832 17.601 97 71 144 2 1777075632 6064608 21030192
14:21:21 9176 8192000000 10684129824 11095994368 1734056656 17.469 97 21 42 2 1745837808 6000608 5780544
14:21:43 6621 8192000000 10726534272 11140382720 1797840832 17.996 99 33 66 0 1813271632 5057328 10373472
14:21:56 7100 8192000000 10714365296 11131109376 1745546032 17.565 96 27 54 2 1759825280 6541664 7737584
14:22:10 6512 8192000000 10730277328 11142795264 1780683616 17.855 98 36 72 0 1798047456 7063488 10300352
14:22:24 5653 8192000000 10732578480 11140485120 1790365104 17.935 99 41 80 1 1809139872 7233504 11541264
14:22:39 7035 8192000000 10724374288 11140673536 1785733616 17.897 98 33 67 2 1802403360 6385664 10284080
14:22:58 8160 8192000000 10741832464 11160633344 1808654800 18.085 99 26 52 3 1822385680 6286208 7444672
14:23:12 6677 8192000000 10750883104 11167633408 1831390400 18.271 100 36 73 2 1848268832 6017120 10861312
14:23:27 10211 8192000000 10766149536 11180785664 1838625200 18.330 100 30 59 1 1852426720 4620192 9181328
14:23:43 5656 8192000000 10765167456 11180048384 1843439872 18.369 100 36 72 2 1859465856 5375056 10650928
14:23:56 7697 8192000000 10760528672 11188420608 1847044352 18.398 100 25 50 0 1860462928 5260336 8158240
14:24:11 7694 8192000000 10774885056 11192193024 1853234976 18.448 100 35 71 2 1869195312 5712848 10247488
14:24:26 7141 8192000000 10776731792 11196076032 1853486208 18.450 100 29 57 2 1867312256 5728656 8097392
14:24:42 3971 8192000000 10766686176 11194380288 1853858720 18.453 100 22 44 1 1866837056 6752576 6225760
14:24:53 66120 8192000000 10791705520 11204046848 1857454848 18.483 100 24 46 1 1870465120 5402992 7607280
14:26:13 6278 8192000000 10767492384 11201523712 1863362368 18.531 100 24 48 1 1876651152 5446944 7841840
14:26:26 9601 8192000000 10772920832 11205009408 1864325776 18.538 100 22 42 2 1875964432 5261584 6377072
14:26:43 5067 8192000000 10783199680 11209748480 1870176224 18.586 100 35 69 2 1887507984 7558544 9773216
14:26:55 9118 8192000000 10789344832 11214057472 1872073088 18.601 100 27 54 2 1885439952 6124080 7242784
14:27:15 25736 8192000000 10826557696 11238858752 1892551840 18.766 100 28 56 2 1905244528 5277616 7415072
14:27:57 7516 8192000000 10841104704 11259019264 1907777488 18.889 100 42 84 3 1930503280 10080880 12644912
14:28:12 32321 8192000000 10837925408 11267399680 1916265168 18.957 100 44 86 1 1936517376 7936576 12315632
14:29:03 11054 8192000000 10855283504 11270262784 1926012176 19.035 100 48 95 1 1947062992 8423120 12627696
14:29:22 13584 8192000000 10858661216 11282452480 1926356144 19.038 100 48 94 0 1948352272 8878464 13117664
14:29:52 10850 8192000000 10877244864 11294294016 1935080800 19.107 100 61 122 3 1963078528 11226224 16771504
14:30:11 12793 8192000000 10875571824 11292504064 1943337632 19.173 100 73 147 0 1977250672 13155424 20757616
14:30:44 29529 8192000000 10881428112 11304239104 1946955104 19.202 100 61 122 1 1977331488 13041776 17334608
14:31:24 49346 8192000000 10868807328 11311878144 1943818496 19.177 100 25 48 2 1959387824 8536528 7032800
14:32:22 46758 8192000000 10883626656 11322068992 1955487680 19.270 100 28 56 1 1977785456 13951696 8346080
14:33:22 21448 8192000000 10901358432 11336577024 1965408240 19.349 100 42 84 3 1994778048 17058640 12311168
14:33:52 8948 8192000000 10907338960 11338665984 1967711568 19.367 100 49 96 0 2000527984 19228256 13588160
14:34:08 8041 8192000000 10913818832 11345596416 1971792928 19.400 100 59 118 2 2010579360 21127104 17659328
14:34:23 8923 8192000000 10917851056 11345317888 1969172416 19.379 100 70 139 1 2012543184 22475584 20895184
14:34:39 4198 8192000000 10923828064 11350511616 1976486224 19.437 100 63 126 1 2017740112 23173440 18080448
14:34:50 2599 8192000000 10942185264 11357622272 1977981792 19.449 100 78 151 3 2024503904 23830384 22691728
14:35:02 4329 8192000000 10927081456 11354865664 1978051600 19.449 100 67 134 3 2019106864 21906864 19148400
14:35:14 7582 8192000000 10925639760 11356352512 1978891280 19.456 100 59 117 3 2018932496 22665392 17375824
14:35:28 26397 8192000000 10924526288 11350835200 1959735312 19.304 99 58 113 0 1994893824 19219424 15939088
14:36:08 18215 8192000000 10925816176 11361120256 1983687696 19.494 100 51 102 1 2020499760 21956672 14855392
14:36:33 2816 8192000000 10936016768 11368353792 1987356768 19.523 100 51 103 0 2024433648 21870336 15206544
14:36:43 4238 8192000000 10932923744 11369676800 1987472448 19.524 100 46 92 2 2022163936 21481024 13210464
14:36:55 4034 8192000000 10929965952 11367395328 1985955936 19.512 100 50 100 1 2025281984 24370576 14955472
14:37:06 33178 8192000000 10925683168 11370758144 1973112672 19.410 99 51 101 0 2012873808 24524112 15237024
14:37:48 2538 8192000000 10934557088 11369635840 1987468160 19.524 100 56 107 3 2029848736 26108944 16271632
14:37:59 9771 8192000000 10939332912 11375013888 1989492816 19.540 100 53 106 1 2032079472 26821264 15765392
14:38:18 11437 8192000000 10930664480 11368701952 1972479920 19.405 99 49 98 0 2013615632 26437008 14698704
14:38:38 3069 8192000000 10955043296 11377934336 1991002656 19.552 100 68 136 1 2039379712 27910064 20466992
14:38:56 14349 8192000000 10959815488 11389857792 2000136832 19.624 100 63 126 1 2050060368 30643376 19280160
14:39:17 3541 8192000000 10974993600 11395489792 2005189200 19.664 100 72 144 0 2058722976 31061072 22472704
14:39:30 4745 8192000000 10975551808 11402002432 2009744352 19.700 100 70 140 1 2063578928 32290736 21543840
14:39:43 3585 8192000000 10980681840 11404627968 2013821232 19.732 100 84 168 0 2070705488 31621520 25262736
14:39:53 5520 8192000000 10985438432 11407769600 2017502688 19.761 100 84 168 0 2075747936 33423520 24821728
14:40:09 2367 8192000000 10986925856 11408400384 2020059568 19.781 100 81 160 1 2078960944 35261760 23639616
14:40:18 3843 8192000000 10993353440 11419918336 2022664384 19.801 100 71 142 0 2080432912 36586544 21181984
14:40:31 4062 8192000000 10992941104 11425439744 2022117776 19.797 100 65 128 3 2076740752 35308816 19314160
14:40:44 6359 8192000000 10971573536 11393896448 1983477456 19.492 98 83 163 1 2043668880 36069456 24121968
14:40:58 6879 8192000000 10982663008 11404963840 2009129856 19.695 100 70 141 2 2067423088 37476608 20816624
14:41:14 2529 8192000000 10989496752 11410460672 2009372352 19.697 100 78 156 1 2072048656 38825552 23850752
14:41:23 4532 8192000000 10976882928 11400331264 2003608944 19.651 100 72 144 0 2063783856 36965136 23209776
14:41:36 4172 8192000000 10985787200 11409223680 2009918288 19.701 100 76 152 3 2071237952 37766528 23553136
14:41:49 2734 8192000000 10978071904 11408826368 2014811072 19.739 100 76 152 2 2075593216 37092512 23689632
14:42:00 4890 8192000000 10981871696 11407196160 1993130352 19.569 99 64 127 1 2048984656 36355120 19499184
14:42:13 3279 8192000000 10978822704 11400130560 1992036752 19.560 99 82 162 1 2053718176 37106768 24574656
14:42:25 3262 8192000000 10979010960 11401920512 2001705472 19.636 100 78 157 0 2063819456 38551024 23562960
14:42:36 8405 8192000000 10978334704 11402928128 1999417024 19.618 100 76 152 0 2062854480 39827712 23609744
14:42:55 2847 8192000000 10961486240 11385663488 1987937232 19.527 100 80 156 1 2052921456 39472976 25511248
14:43:07 5217 8192000000 10974142608 11394052096 1992688976 19.565 100 79 158 1 2061149440 43934496 24525968
14:43:20 1313 8192000000 10963038576 11373178880 1961803856 19.320 99 79 159 0 2026509520 39690656 25015008
14:43:29 3210 8192000000 10971547104 11381530624 1982766896 19.487 100 81 160 1 2048469968 41099904 24603168
14:43:38 1247 8192000000 10985178864 11398705152 1993238064 19.569 100 94 187 0 2065771312 42508528 30024720
14:43:48 7616 8192000000 10971677232 11389497344 1987605296 19.525 100 84 168 2 2060114240 46709024 25799920
14:44:06 6122 8192000000 10980278048 11396714496 1983802832 19.495 100 81 163 2 2060070352 50520544 25746976
14:44:26 5672 8192000000 10969352864 11393916928 1985037744 19.505 100 67 132 0 2055379600 49356768 20985088
14:44:39 2851 8192000000 10951942992 11369299968 1950673440 19.232 98 75 150 2 2024628368 49521264 24433664
14:44:50 4058 8192000000 10956392144 11371745280 1960826000 19.313 99 81 162 1 2035872896 49684896 25362000
14:45:02 4368 8192000000 10974814352 11388637184 1980113440 19.466 100 72 144 3 2051197600 48691936 22392224
14:45:17 3880 8192000000 10981031248 11402145792 1986824608 19.519 100 73 145 3 2059567472 49695952 23046912
14:45:32 2482 8192000000 10977969344 11387310080 1975605888 19.430 99 89 178 0 2055285504 51148736 28530880
14:45:41 4394 8192000000 10946308864 11365548032 1951529072 19.239 99 74 146 0 2024826528 50353664 22943792
14:45:56 1523 8192000000 10969497360 11381407744 1971391568 19.396 100 85 167 1 2050785184 52586080 26807536
14:46:06 2950 8192000000 10964445920 11376738304 1964554544 19.342 100 82 164 2 2045797568 55526704 25716320
14:46:16 3783 8192000000 10962173712 11374354432 1959458816 19.302 99 86 172 2 2043287136 56318064 27510256
14:46:27 2066 8192000000 10983880208 11389554688 1974714656 19.423 100 89 179 5 2060358544 57573264 28070624
14:46:36 3755 8192000000 10956283664 11387904000 1968025616 19.370 100 69 138 0 2053479904 62592784 22861504
14:46:57 2770 8192000000 10934342352 11360874496 1929080896 19.060 98 54 108 1 2004512032 57440112 17991024
14:47:07 3038 8192000000 10936051008 11348729856 1944184256 19.180 100 76 152 1 2026099344 56739104 25175984
14:47:18 2541 8192000000 10968810736 11375423488 1967080672 19.362 100 83 165 0 2044063344 50387328 26595344
14:47:28 2212 8192000000 10970869792 11383574528 1971469712 19.397 100 81 163 1 2050622416 52550272 26602432
14:47:37 7160 8192000000 10944420656 11387899904 1969308528 19.380 100 47 92 0 2033876176 49462272 15105376
14:47:53 11390 8192000000 10947617136 11383693312 1955889696 19.273 99 41 80 2 2019102224 49257440 13955088
14:48:12 11635 8192000000 10955855872 11387334656 1958468512 19.294 99 45 90 1 2028006944 54459632 15078800
14:48:31 3764 8192000000 10969174992 11391856640 1980132752 19.466 100 60 119 2 2051473360 51862656 19477952
14:48:42 15009 8192000000 10946137232 11387035648 1972303728 19.404 100 50 100 0 2041721600 52685040 16732832
14:49:04 13500 8192000000 10956972400 11388776448 1975420112 19.428 100 50 100 0 2037255712 45395792 16439808
14:49:32 6420 8192000000 10952601840 11388989440 1983528096 19.493 100 47 94 0 2044776608 45588624 15659888
14:49:45 12717 8192000000 10947042352 11384242176 1958341936 19.293 99 42 84 0 2021450336 48468016 14640384
14:50:10 9768 8192000000 10961277600 11390119936 1975641056 19.430 100 54 105 1 2045326560 51572752 18112752
14:50:41 13443 8192000000 10956951920 11392536576 1969522656 19.382 100 54 108 0 2041586208 53591344 18472208
14:51:14 9152 8192000000 10963810848 11400810496 1976049904 19.433 100 44 87 3 2049252016 58015472 15186640
14:51:31 2598 8192000000 10964759856 11394801664 1972715728 19.407 100 52 104 2 2047708320 56554256 18438336
14:51:40 9933 8192000000 10966126352 11405123584 1974763024 19.423 100 40 81 0 2047232576 58379040 14090512
14:51:57 31929 8192000000 10940506992 11409395712 1977052576 19.441 100 36 72 2 2051422064 61584176 12785312
14:52:36 9545 8192000000 10940933568 11393212416 1949763792 19.225 99 39 79 1 2011366208 47981152 13621264
14:53:04 17409 8192000000 10935666320 11386048512 1955185312 19.268 100 26 52 1 2018905536 53903088 9817136
14:53:29 20820 8192000000 10930213856 11393433600 1952799168 19.249 100 22 44 0 2020495888 58820128 8876592
14:54:02 21902 8192000000 10914363728 11394023424 1948173056 19.212 100 19 38 1 2011785264 56218704 7393504
14:54:37 24539 8192000000 10918140960 11379990528 1939480640 19.143 100 13 24 0 1991818896 47620016 4718240
14:55:08 19376 8192000000 10903891488 11378053120 1942308736 19.165 100 14 28 1 1998121248 50679344 5133168
14:55:33 20170 8192000000 10897254864 11395076096 1937744368 19.129 100 8 16 0 1975263040 34907616 2611056
14:56:08 54183 8192000000 10868869296 11330007040 1895773296 18.792 97 13 26 2 1911837280 12759616 3304368
14:57:09 69447 8192000000 10870485968 11336863744 1886238560 18.715 97 17 32 1 1904995984 14257728 4499696
14:58:26 63358 8192000000 10883078128 11314466816 1893221424 18.772 97 31 65 3 1909413520 7739152 8452944
14:59:36 79187 8192000000 10855310240 11315511296 1874052720 18.617 96 33 67 1 1902543488 19412784 9077984
15:01:10 65648 8192000000 10890011440 11338399744 1892667072 18.767 97 32 56 0 1906795456 7207472 6920912
15:03:03 115535 8192000000 10891590784 11353088000 1916929680 18.962 98 37 75 1 1936644960 9052672 10662608
15:05:15 118084 8192000000 10903285248 11350061056 1917253456 18.965 98 21 42 0 1936426160 13588000 5584704
15:07:20 51039 8192000000 10894520336 11359784960 1947885920 19.210 99 11 22 0 1965137024 13774160 3476944
15:08:17 28277 8192000000 10902102912 11368620032 1949953920 19.226 99 15 30 0 1973454864 18695968 4804976
15:08:57 55895 8192000000 10915281056 11383513088 1979063504 19.457 100 44 88 1 2011754944 20029584 12661856
15:10:17 46611 8192000000 10915454720 11394461696 1978321040 19.451 100 15 27 1 2003677888 20810432 4546416
15:11:14 41063 8192000000 10901471776 11374891008 1969955760 19.385 100 13 26 0 1992471072 18760064 3755248
15:12:01 24574 8192000000 10907372096 11381825536 1975252912 19.427 100 9 18 1 1993609568 15571520 2785136
15:12:32 53865 8192000000 10915325104 11400769536 1982594096 19.485 100 13 26 1 2002303296 15750736 3958464
15:13:32 8246 8192000000 10908833440 11403202560 1982419392 19.484 100 7 14 1 2003507328 18776960 2310976
15:13:51 53381 8192000000 10927685856 11395653632 1987448320 19.524 100 24 48 1 2011649504 16935680 7265504
15:14:54 43656 8192000000 10900709296 11388772352 1946099760 19.195 98 10 20 0 1966147296 17026400 3021136
15:15:44 34361 8192000000 10871818336 11343994880 1936209888 19.117 98 13 25 0 1950868944 10886832 3772224
15:16:27 65871 8192000000 10886076096 11362996224 1950754992 19.232 99 18 36 0 1971224752 15231984 5237776
15:17:44 29120 8192000000 10881012000 11369549824 1960047456 19.306 100 7 14 0 1972634720 10847520 1739744
15:18:29 94274 8192000000 10896449248 11374714880 1892698272 18.768 96 11 22 1 1908794912 12950320 3146320
15:20:10 37960 8192000000 10900069792 11370745856 1975540144 19.429 100 29 58 2 1993671440 9176928 8954368
15:20:57 69713 8192000000 10939568144 11404324864 1994512192 19.579 100 30 59 0 2010942976 8441632 7989152
15:22:57 67272 8192000000 10933080096 11408523264 1976399712 19.436 99 13 26 0 1990223248 10341456 3482080
15:24:12 67025 8192000000 10925143680 11395768320 1967338592 19.364 98 29 58 1 1988114032 13006368 7769072
15:25:25 71531 8192000000 10905137168 11380936704 1892600976 18.767 95 9 18 1 1913399232 17957536 2840720
15:26:56 97107 8192000000 10897003440 11360137216 1859280752 18.497 94 15 30 0 1875558576 12579728 3698096
15:28:40 63739 8192000000 10919273216 11370799104 1917240592 18.965 97 22 42 0 1931814912 8451424 6122896
15:29:53 46282 8192000000 10897797408 11368914944 1916153648 18.956 97 31 62 1 1936614432 11583856 8876928
15:30:45 59730 8192000000 10911318672 11386839040 1943432800 19.174 99 13 26 0 1965610944 18338256 3839888
15:31:51 139342 8192000000 10866467440 11335626752 1876228384 18.635 95 22 43 1 1905861744 23019408 6613952
15:34:17 62397 8192000000 10898272864 11353935872 1883396080 18.693 96 28 56 2 1904163648 13040432 7727136
15:35:32 58434 8192000000 10873112704 11331284992 1921695648 19.000 98 40 80 0 1949005392 15153984 12155760
15:36:46 40054 8192000000 10874261120 11342282752 1931644976 19.080 99 36 72 0 1959110048 17040336 10424736
15:37:40 62190 8192000000 10858799344 11342700544 1906048720 18.875 98 14 28 3 1931855520 21989360 3817440
15:39:49 46102 8192000000 10871119168 11331956736 1911260144 18.917 98 20 40 1 1930320256 13284864 5775248
15:40:44 81243 8192000000 10857625456 11340754944 1925579744 19.032 99 15 30 1 1938764336 8387472 4797120
15:42:11 53940 8192000000 10851416880 11314233344 1889364208 18.741 97 9 18 0 1899515200 7519296 2631696
15:43:16 93216 8192000000 10862246624 11333459968 1908451808 18.894 98 23 46 1 1921963136 6738928 6772400
15:45:01 51075 8192000000 10865593232 11340898304 1909477984 18.902 98 11 20 1 1925474176 12571360 3424832
15:46:37 42533 8192000000 10849204128 11336585216 1897062720 18.803 98 10 18 1 1910285760 11090832 2132208
15:47:26 101175 8192000000 10864877632 11345367040 1921148096 18.996 99 9 18 0 1933169248 9561248 2459904
15:49:45 56108 8192000000 10860137536 11326795776 1850820336 18.429 95 16 30 2 1863020000 8383104 3816560
15:50:47 40259 8192000000 10881023088 11329249280 1908622432 18.896 98 44 88 1 1930906048 9543648 12739968
15:51:33 54701 8192000000 10868970384 11342000128 1934166784 19.100 100 28 56 0 1956385872 14493984 7725104
15:52:35 27545 8192000000 10880860544 11341066240 1930203072 19.069 99 40 80 2 1952380992 11001664 11176256
15:53:34 70853 8192000000 10871473856 11325579264 1863844208 18.534 96 13 26 1 1876532080 9331552 3356320
15:54:51 28500 8192000000 10873534992 11335958528 1924667760 19.024 99 32 65 2 1944363872 11287856 8408256
15:55:28 60745 8192000000 10883835776 11335536640 1900679776 18.832 98 27 54 2 1919817104 11480608 7656720
15:56:40 72592 8192000000 10874054480 11353354240 1922727328 19.009 99 17 34 1 1937781328 10686080 4367920
15:58:05 79677 8192000000 10902642096 11371819008 1942147552 19.164 99 11 22 1 1961214128 15088656 3977920
15:59:31 56896 8192000000 10894493008 11362914304 1922743952 19.009 98 25 50 1 1940351280 10496896 7110432
16:00:40 51624 8192000000 10909780080 11380604928 1970928144 19.393 100 32 62 1 1992488928 12820944 8739840
16:01:42 100589 8192000000 10881105840 11365752832 1910653744 18.912 97 15 30 0 1927443104 12477104 4312256
16:03:28 116535 8192000000 10905749072 11378077696 1968323376 19.372 100 14 28 0 1982271120 10435232 3512512
16:05:32 38802 8192000000 10914208112 11382620160 1963691712 19.335 99 30 59 1 1985625488 13589440 8344336
16:06:26 75874 8192000000 10896458416 11390578688 1975790544 19.431 100 16 32 0 2000027152 19909008 4327600
16:07:48 37253 8192000000 10895798224 11389689856 1972548384 19.406 100 6 11 0 1986557936 12310048 1699504
16:08:32 28318 8192000000 10883176912 11363766272 1938637440 19.136 98 17 34 0 1953828976 10392048 4799488
16:09:09 27104 8192000000 10886904368 11366342656 1954092576 19.259 99 30 61 2 1971743536 8425536 9225424
16:10:03 72236 8192000000 10885462864 11372044288 1931593152 19.080 98 28 55 0 1952037888 12644560 7800176
16:11:21 64990 8192000000 10871129856 11337986048 1873048224 18.609 95 21 43 1 1888007536 9288848 5670464
16:12:34 90822 8192000000 10860267280 11342430208 1862829520 18.526 95 18 36 0 1879452768 11458960 5164288
16:14:12 25476 8192000000 10888569200 11357376512 1936278960 19.117 99 34 67 1 1963582880 17709520 9594400
16:14:44 36384 8192000000 10874623664 11341795328 1912077696 18.923 98 13 26 0 1931513728 14795456 4640576
16:15:32 59720 8192000000 10861099904 11341250560 1873703440 18.614 96 28 56 0 1892901760 11681120 7517200
16:16:38 32827 8192000000 10875591648 11320344576 1868656496 18.573 96 30 60 2 1887470464 10836032 7977936
16:17:21 65653 8192000000 10861311232 11336163328 1858314864 18.490 96 32 65 0 1885826992 18443840 9068288
16:18:49 48056 8192000000 10846557648 11303424000 1847977360 18.406 96 20 40 0 1863771248 10433568 5360320
16:19:48 30180 8192000000 10885266928 11340017664 1929131840 19.060 100 43 84 1 1958452192 17928080 11392272
16:20:27 44732 8192000000 10863830384 11320221696 1879033488 18.657 97 37 74 0 1909850800 20873136 9944176
16:21:30 43054 8192000000 10859839840 11315961856 1872455296 18.604 97 16 32 1 1885733664 9112128 4166240
16:22:20 22130 8192000000 10884744656 11338190848 1937929616 19.130 100 61 122 2 1965582480 9644416 18008448
16:22:58 117066 8192000000 10837672352 11309785088 1859106112 18.496 96 17 34 0 1880295392 15932736 5256544
16:25:01 68497 8192000000 10840639168 11312160768 1839403872 18.336 96 21 42 3 1861321616 16048656 5869088
16:26:16 30737 8192000000 10818043408 11302264832 1852935616 18.446 97 7 14 0 1865970544 11463296 1571632
16:26:59 26491 8192000000 9749827888 10104569856 894791040 9.847 47 4 8 0 899787888 4159744 837104

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 20-02-2021 16:30:01 to 20-02-2021 16:30:33.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 124 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 20-02-2021 16:30:34 to 20-02-2021 16:30:36.

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          237692
MON$OLDEST_ACTIVE               238210
MON$OLDEST_SNAPSHOT             238210
MON$NEXT_TRANSACTION            238210
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                       2023104
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.33420 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33420 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33420 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33420 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 ---
:54: 
:55: mscs-test-161.budzdorov.ru    Sat Feb 20 16:27:28 2021
:56:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:57: 
--- end of diff output ---

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

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