Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 07.01.2021 19:27
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 17333452 kB
MemAvailable 31376536 kB
Buffers 0 kB
Cached 14345064 kB
SwapCached 4864 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-01-07 19:27:12
DTS_END                         2021-01-07 19:27:12.0890
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/60088
TRN_ID                          239160
ATT_ID                          674
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: 9381.41 18813 1125769
customer order: creation 175.33 349 21039
customer order: refuse 15.15 386 1818
order to supplier: creation 45.88 1359 5506
order to supplier: removal 3.46 97352 415
invoice (draft): creation 46.48 3596 5578
invoice (draft): removal 53.23 755 6388
invoice accept: apply 41.73 17190 5007
invoice accept: cancel 48.78 806 5854
customer reserve: creation 3848.04 169 461765
customer reserve: removal 4802.98 55 576358
realization accept: apply 85.30 178 10236
realization accept: cancel 83.78 100 10054
payment from customer: creation 59.88 129 7185
payment from customer: removal 5.64 87 677
payment to supplier: creation 49.46 154 5935
payment to supplier: removal 3.30 57 396
service: total inventory turnovers 4.99 871 599
service: total monetary turnovers 7.02 31 842
service: aggregate perf. data 0.94 15924 113
service: refresh index statistics 0.03 236720 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 07-01-2021 19:28:10 to 07-01-2021 19:28:12.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4815
TEST_TIME 2 4128
TEST_TIME 3 4018
TEST_TIME 4 4075
TEST_TIME 5 4549
TEST_TIME 6 4637
TEST_TIME 7 4371
TEST_TIME 8 4563
TEST_TIME 9 5876
TEST_TIME 10 6073
TEST_TIME 11 6324
TEST_TIME 12 6821
TEST_TIME 13 7015
TEST_TIME 14 7159
TEST_TIME 15 7878
TEST_TIME 16 8262
TEST_TIME 17 8384
TEST_TIME 18 8861
TEST_TIME 19 9286
TEST_TIME 20 9452
TEST_TIME 21 9740
TEST_TIME 22 9753
TEST_TIME 23 9811
TEST_TIME 24 9972
TEST_TIME 25 10414
TEST_TIME 26 11114
TEST_TIME 27 11014
TEST_TIME 28 11217
TEST_TIME 29 11106
TEST_TIME 30 10996
TEST_TIME 31 10813
TEST_TIME 32 10567
TEST_TIME 33 10425
TEST_TIME 34 10451
TEST_TIME 35 10295
TEST_TIME 36 10304
TEST_TIME 37 10156
TEST_TIME 38 10096
TEST_TIME 39 10120
TEST_TIME 40 9940
TEST_TIME 41 9842
TEST_TIME 42 9862
TEST_TIME 43 9784
TEST_TIME 44 9794
TEST_TIME 45 9934
TEST_TIME 46 9933
TEST_TIME 47 9892
TEST_TIME 48 9888
TEST_TIME 49 9995
TEST_TIME 50 10019
TEST_TIME 51 10027
TEST_TIME 52 9929
TEST_TIME 53 10009
TEST_TIME 54 9950
TEST_TIME 55 10023
TEST_TIME 56 10163
TEST_TIME 57 10279
TEST_TIME 58 10128
TEST_TIME 59 10042
TEST_TIME 60 9987
TEST_TIME 61 9949
TEST_TIME 62 9854
TEST_TIME 63 9950
TEST_TIME 64 9865
TEST_TIME 65 9841
TEST_TIME 66 9753
TEST_TIME 67 9626
TEST_TIME 68 9610
TEST_TIME 69 9635
TEST_TIME 70 9608
TEST_TIME 71 9595
TEST_TIME 72 9612
TEST_TIME 73 9614
TEST_TIME 74 9645
TEST_TIME 75 9675
TEST_TIME 76 9694
TEST_TIME 77 9655
TEST_TIME 78 9734
TEST_TIME 79 9774
TEST_TIME 80 9775
TEST_TIME 81 9725
TEST_TIME 82 9662
TEST_TIME 83 9627
TEST_TIME 84 9548
TEST_TIME 85 9559
TEST_TIME 86 9511
TEST_TIME 87 9444
TEST_TIME 88 9438
TEST_TIME 89 9475
TEST_TIME 90 9454
TEST_TIME 91 9422
TEST_TIME 92 9514
TEST_TIME 93 9520
TEST_TIME 94 9551
TEST_TIME 95 9540
TEST_TIME 96 9569
TEST_TIME 97 9549
TEST_TIME 98 9642
TEST_TIME 99 9629
TEST_TIME 100 9621
TEST_TIME 101 9668
TEST_TIME 102 9758
TEST_TIME 103 9697
TEST_TIME 104 9629
TEST_TIME 105 9579
TEST_TIME 106 9555
TEST_TIME 107 9507
TEST_TIME 108 9492
TEST_TIME 109 9454
TEST_TIME 110 9441
TEST_TIME 111 9380
TEST_TIME 112 9344
TEST_TIME 113 9397
TEST_TIME 114 9453
TEST_TIME 115 9440
TEST_TIME 116 9410
TEST_TIME 117 9426
TEST_TIME 118 9450
TEST_TIME 119 9450
TEST_TIME 120 9384

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 07-01-2021 19:28:13 to 07-01-2021 19:28:17.

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 1554327 1554327 0 0.00 0 29626 6 0 0
doc_list_biud 1554324 1554324 0 0.00 0 53035 26 0 0
sp_add_invoice_to_stock 5130 5007 123 2.39 17 154540 17190 0 123
sp_cancel_adding_invoice 5854 5854 0 0.00 5 79736 806 0 0
sp_cancel_client_order 1818 1818 0 0.00 4 19645 387 0 0
sp_cancel_customer_reserve 576358 576358 0 0.00 1 19212 55 0 0
sp_cancel_pay_from_customer 677 677 0 0.00 2 8087 88 0 0
sp_cancel_pay_to_supplier 396 396 0 0.00 3 1353 57 0 0
sp_cancel_supplier_invoice 6398 6388 10 0.15 1 53052 755 0 10
sp_cancel_supplier_order 415 415 0 0.00 6 1071356 97353 0 0
sp_cancel_write_off 10054 10054 0 0.00 1 13390 101 0 0
sp_client_order 21039 21039 0 0.00 4 16589 350 0 0
sp_customer_reserve 461765 461765 0 0.00 0 62370 170 0 0
sp_fill_shopping_cart 32117 32117 0 0.00 1 19322 39 0 0
sp_fill_shopping_cart_clo_res 461757 461757 0 0.00 0 14713 14 0 0
sp_get_clo_for_invoice 4999 4999 0 0.00 0 22851 303 0 0
sp_kill_cost_storno 16981 16981 0 0.00 0 9281 51 0 0
sp_kill_qstorno_ret_qs2qd 1169573 1169573 0 0.00 0 53029 30 0 0
sp_kill_qty_storno 616122 616122 0 0.00 0 53033 65 0 0
sp_lock_selected_doc 21071 21071 0 0.00 0 8259 5 0 0
sp_make_cost_storno 28355 28355 0 0.00 0 29616 59 0 0
sp_multiply_rows_for_pdistr 28355 28355 0 0.00 0 8321 30 0 0
sp_multiply_rows_for_qdistr 21039 21039 0 0.00 0 15476 159 0 0
sp_pay_from_customer 7185 7185 0 0.00 4 11426 129 0 0
sp_pay_to_supplier 5935 5935 0 0.00 5 29637 155 0 0
sp_payment_common 13120 13120 0 0.00 1 10558 36 0 0
sp_qd_handle_on_cancel_clo 1818 1818 0 0.00 0 19637 354 0 0
sp_qd_handle_on_invoice_upd_sts 10853 10853 0 0.00 0 25001 324 0 0
sp_qd_handle_on_reserve_upd_sts 10236 10236 0 0.00 0 16519 59 0 0
sp_reserve_write_off 10236 10236 0 0.00 6 16533 178 0 0
sp_supplier_invoice 5578 5578 0 0.00 7 93621 3596 0 0
sp_supplier_order 5506 5506 0 0.00 6 69373 1360 0 0
srv_aggregate_perf_data 114 113 1 0.87 2539 133154 15924 0 1
srv_fill_mon_cache_memory 160 160 0 0.00 1191 141173 32828 0 0
srv_find_qd_qs_mism 1078132 1078132 0 0.00 0 13758 5 0 0
srv_make_invnt_saldo 599 599 0 0.00 31 18786 872 0 0
srv_make_money_saldo 842 842 0 0.00 0 4863 32 0 0
srv_recalc_idx_stat 4 4 0 0.00 184429 336964 236720 0 0
t$perf-abend:sp_add_invoice_to_stock 123 123 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5007 5007 0 0.00 0 17277 198 0 0
t$perf-norm:sp_cancel_adding_invoice 420 420 0 0.00 0 8721 135 0 0
t$perf-norm:sp_cancel_client_order 1818 1818 0 0.00 0 11650 21 0 0
t$perf-norm:sp_cancel_customer_reserve 700 700 0 0.00 0 1308 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 677 677 0 0.00 0 7175 17 0 0
t$perf-norm:sp_cancel_pay_to_supplier 396 396 0 0.00 0 2711 9 0 0
t$perf-norm:sp_cancel_supplier_invoice 387 387 0 0.00 0 2317 16 0 0
t$perf-norm:sp_cancel_supplier_order 415 415 0 0.00 0 36654 1760 0 0
t$perf-norm:sp_cancel_write_off 1023 1023 0 0.00 0 5362 11 0 0
t$perf-norm:sp_client_order 21039 21039 0 0.00 0 12340 18 0 0
t$perf-norm:sp_customer_reserve 1035 1035 0 0.00 0 1971 9 0 0
t$perf-norm:sp_pay_from_customer 7185 7185 0 0.00 0 7813 9 0 0
t$perf-norm:sp_pay_to_supplier 5935 5935 0 0.00 0 11049 15 0 0
t$perf-norm:sp_reserve_write_off 10236 10236 0 0.00 0 13067 14 0 0
t$perf-norm:sp_supplier_invoice 5578 5578 0 0.00 0 6673 26 0 0
t$perf-norm:sp_supplier_order 5506 5506 0 0.00 0 4714 17 0 0
t$perf-norm:srv_aggregate_perf_data 113 113 0 0.00 0 1249 30 0 0
t$perf-norm:srv_fill_mon_cache_memory 160 160 0 0.00 0 393 12 0 0
t$perf-norm:srv_make_invnt_saldo 599 599 0 0.00 0 5205 37 0 0
t$perf-norm:srv_make_money_saldo 842 842 0 0.00 0 10522 27 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 10 4 0 0
v_add_invoice_to_stock 10244 9998 246 2.40 0 4293 19 0 246
v_all_customers 38484 38484 0 0.00 0 292 1 0 0
v_all_suppliers 30616 30616 0 0.00 0 22 1 0 0
v_all_wares 42078 42078 0 0.00 0 131 1 0 0
v_cancel_adding_invoice 840 840 0 0.00 0 1795 7 0 0
v_cancel_client_order 3636 3636 0 0.00 0 3929 7 0 0
v_cancel_customer_prepayment 1354 1354 0 0.00 0 2245 8 0 0
v_cancel_customer_reserve 1400 1400 0 0.00 0 2366 7 0 0
v_cancel_payment_to_supplier 792 792 0 0.00 0 1344 4 0 0
v_cancel_supplier_invoice 794 774 20 2.51 0 2485 18 0 20
v_cancel_supplier_order 830 830 0 0.00 0 2163 8 0 0
v_cancel_write_off 2046 2046 0 0.00 0 8335 17 0 0
v_max_id_clo_ord 5505 5505 0 0.00 0 134 1 0 0
v_max_id_clo_res 1035 1035 0 0.00 0 2181 12 0 0
v_max_id_ord_sup 5573 5573 0 0.00 0 8831 5 0 0
v_max_non_paid_invoice 1705 1705 0 0.00 0 4566 5 0 0
v_max_non_paid_realizn 3803 3803 0 0.00 0 7768 7 0 0
v_min_id_clo_ord 5505 5505 0 0.00 0 4532 8 0 0
v_min_id_clo_res 1035 1035 0 0.00 0 1098 6 0 0
v_min_id_ord_sup 5573 5573 0 0.00 0 7144 12 0 0
v_min_non_paid_invoice 5935 5935 0 0.00 0 9122 20 0 0
v_min_non_paid_realizn 7185 7185 0 0.00 0 7963 21 0 0
v_our_firm 10358 10358 0 0.00 0 14 1 0 0
v_reserve_write_off 20472 20472 0 0.00 0 4145 7 0 0
x_lock_depdocs_on_canc_invoice 11855 11855 0 0.00 0 17306 115 0 0
x_lock_depdocs_on_canc_sup_ord 415 415 0 0.00 0 20114 356 0 0
x_make_qstorno_1000_1200 5506 5506 0 0.00 2 69306 1272 0 0
x_make_qstorno_1200_2000 5578 5578 0 0.00 3 89100 3457 0 0
x_make_qstorno_2100_3300 461765 461765 0 0.00 0 62368 153 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 07-01-2021 19:28:18 to 07-01-2021 19:28:22.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:15 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:21 9919 8192000000 10185344320 10481594368 790352160 8.798 64 49 101 0 809159088 2328832 16478096
16:57:41 30770 8192000000 10339746160 10659868672 1374474720 14.367 100 78 156 1 1403612800 4538544 24599536
16:58:21 28992 8192000000 10377427632 10702761984 1437645248 14.929 100 90 180 0 1472737904 6191472 28901184
16:59:04 27545 8192000000 10415870144 10742063104 1465932176 15.178 100 92 184 0 1502349488 7015952 29401360
16:59:41 27003 8192000000 10431600416 10763038720 1480729952 15.308 100 87 174 0 1516700208 8134720 27835536
17:00:18 17272 8192000000 10458837504 10791628800 1507710304 15.543 100 90 180 1 1548855856 13092448 28053104
17:00:58 13978 8192000000 10477329776 10813845504 1530354624 15.740 100 92 184 1 1568716720 9381760 28980336
17:01:23 25197 8192000000 10504117712 10847547392 1548938464 15.901 100 84 168 1 1584628304 9750224 25939616
17:01:57 18117 8192000000 10521181824 10869960704 1573344864 16.111 100 85 170 1 1609903360 10627808 25930688
17:02:23 13942 8192000000 10541498112 10898477056 1592554928 16.276 100 80 159 0 1627359232 10775888 24028416
17:02:46 13490 8192000000 10570310960 10930470912 1624316448 16.547 100 76 152 0 1657541648 10910848 22314352
17:03:07 9884 8192000000 10583764816 10944196608 1645945184 16.730 100 74 148 0 1679011488 11303536 21762768
17:03:25 9590 8192000000 10597640176 10962067456 1656977568 16.823 100 79 158 2 1692712480 12113008 23621904
17:03:43 9160 8192000000 10596890432 10969169920 1665461744 16.895 100 76 153 1 1700779472 11803360 23514368
17:04:00 11894 8192000000 10622370624 10996125696 1678794320 17.007 100 68 134 0 1709309776 11201712 19313744
17:04:20 6555 8192000000 10645492480 11016691712 1705670848 17.233 100 71 142 0 1736987152 11131312 20184992
17:04:40 6115 8192000000 10659490144 11039363072 1729874368 17.434 100 76 152 0 1763007104 11729056 21403680
17:04:54 8267 8192000000 10676382416 11053330432 1741279456 17.529 100 76 151 0 1773478352 10952400 21246496
17:05:09 5500 8192000000 10690523888 11065958400 1752209040 17.620 100 82 164 0 1787764672 12304048 23251584
17:05:23 6743 8192000000 10707495424 11083661312 1765105424 17.727 100 76 152 0 1799366896 13014816 21246656
17:05:36 6471 8192000000 10706527936 11089829888 1771127104 17.776 100 80 161 2 1807442208 13549056 22766048
17:05:52 4444 8192000000 10713195456 11096592384 1781869200 17.865 100 83 165 2 1817362976 12798880 22694896
17:06:05 10498 8192000000 10729631984 11111882752 1788593632 17.920 100 68 136 1 1819974720 12834064 18547024
17:06:23 2357 8192000000 10735372848 11123994624 1802119424 18.031 100 79 159 1 1838069056 13129728 22819904
17:06:33 4593 8192000000 10745762048 11131789312 1809318368 18.090 100 80 160 1 1844256576 11740784 23197424
17:06:45 2723 8192000000 10759004544 11146489856 1818073952 18.162 100 85 170 1 1854308752 12765536 23469264
17:06:55 3260 8192000000 10771421104 11155472384 1826215344 18.228 100 83 165 0 1862459488 13354832 22889312
17:07:05 3486 8192000000 10764153184 11152519168 1831823136 18.274 100 82 165 1 1867851904 13358848 22669920
17:07:16 4346 8192000000 10772245920 11159859200 1833259936 18.286 100 92 184 2 1872965536 14001504 25704096
17:07:27 2085 8192000000 10783090864 11168968704 1840263680 18.343 100 90 181 1 1879312128 14263264 24785184
17:07:36 2646 8192000000 10788507056 11173900288 1843229968 18.367 100 93 186 3 1883373616 14288464 25855184
17:07:45 1697 8192000000 10783866704 11171938304 1843881824 18.372 100 81 163 0 1880677168 14003008 22792336
17:07:53 2120 8192000000 10788274464 11180859392 1852070480 18.439 100 90 180 0 1890457440 13287632 25099328
17:08:02 1230 8192000000 10788740912 11177836544 1848524736 18.410 100 90 180 0 1886551488 13042304 24984448
17:08:10 2331 8192000000 10793934448 11184197632 1853906736 18.454 100 86 171 0 1890288320 12545456 23836128
17:08:19 2135 8192000000 10799129648 11188789248 1858007376 18.487 100 88 176 0 1896890256 13693712 25189168
17:08:28 2286 8192000000 10801161376 11191361536 1858765408 18.493 100 88 174 0 1896414128 13329648 24319072
17:08:37 1709 8192000000 10800911216 11191259136 1862794800 18.526 100 95 188 1 1904819776 15483312 26541664
17:08:45 2268 8192000000 10805933728 11196481536 1862179280 18.521 100 93 184 1 1901658592 14105904 25373408
17:08:55 2778 8192000000 10808482000 11198054400 1865164912 18.545 100 93 184 0 1906150864 14193856 26792096
17:09:05 9863 8192000000 10812075120 11199803392 1865840848 18.551 100 92 185 2 1907129056 15391584 25896624
17:09:21 1914 8192000000 10811640288 11201622016 1866546720 18.556 100 95 190 0 1908278384 14975952 26755712
17:09:30 1740 8192000000 10812090080 11201470464 1869144000 18.577 100 96 193 1 1910037552 12945856 27947696
17:09:38 1563 8192000000 10811953936 11201052672 1866646320 18.557 100 91 182 0 1905843664 12464256 26733088
17:09:46 1663 8192000000 10815848304 11203723264 1867146256 18.561 100 90 183 0 1906073440 12611552 26315632
17:09:54 2092 8192000000 10803711072 11203092480 1868035312 18.568 100 70 139 0 1900183664 12320704 19827648
17:10:03 25379 8192000000 10791546432 11194617856 1866310544 18.554 100 43 84 3 1886250640 7606560 12333536
17:10:34 3022 8192000000 10787103568 11202752512 1867570976 18.565 100 46 92 0 1891307024 9298608 14437440
17:10:45 2379 8192000000 10800657696 11204481024 1870944368 18.592 100 54 107 1 1896512656 9906976 15661312
17:10:54 3842 8192000000 10784413392 11208749056 1870334336 18.587 100 42 84 1 1891917744 10259552 11323856
17:11:06 3807 8192000000 10792198032 11210047488 1870959088 18.592 100 37 75 1 1889523584 8021936 10542560
17:11:17 5266 8192000000 10797074352 11208970240 1873300624 18.611 100 42 82 2 1892487136 6280528 12905984
17:11:31 8643 8192000000 10796963312 11212697600 1881061888 18.674 100 37 73 1 1897777520 6032560 10683072
17:11:46 6072 8192000000 10787148256 11216846848 1880228128 18.667 100 33 66 1 1897432080 7644128 9559824
17:11:59 4484 8192000000 10791576176 11216535552 1883892080 18.697 100 33 66 1 1899784576 6720432 9172064
17:12:11 4161 8192000000 10792419152 11223756800 1885818736 18.712 100 25 50 1 1900110480 7071376 7220368
17:12:22 8582 8192000000 10789097216 11224379392 1885810544 18.712 100 25 50 0 1899322848 6960896 6551408
17:12:40 13627 8192000000 10797413904 11228807168 1891850544 18.761 100 28 57 0 1905765760 5919536 7995680
17:13:00 52843 8192000000 10806042752 11238993920 1897533216 18.806 100 37 73 2 1915120560 5400880 12186464
17:14:02 10479 8192000000 10813334128 11241295872 1891992672 18.762 100 20 40 1 1903957120 6446128 5518320
17:14:21 9983 8192000000 10802512656 11237535744 1894691136 18.784 100 15 31 1 1904246448 4711248 4844064
17:14:39 5408 8192000000 10829952240 11246407680 1901547408 18.839 100 42 83 1 1920943792 7016176 12380208
17:14:51 5359 8192000000 10811870720 11243057152 1899203824 18.820 100 34 67 0 1920445376 11375728 9865824
17:15:05 6967 8192000000 10816713808 11246608384 1900540320 18.831 100 35 70 3 1917809920 7001104 10268496
17:15:18 6464 8192000000 10810193424 11243163648 1903112208 18.851 100 35 70 0 1920563760 7088224 10363328
17:15:33 5207 8192000000 10823382368 11246428160 1901364768 18.837 100 19 37 2 1912230464 4778864 6086832
17:15:44 2858 8192000000 10837424768 11258318848 1906531728 18.879 100 48 96 4 1929569728 7857568 15180432
17:15:54 5641 8192000000 10825514688 11256410112 1907517296 18.887 100 45 91 1 1929953600 9562656 12873648
17:16:07 7917 8192000000 10812263504 11240353792 1875902192 18.632 99 25 47 2 1888280304 5808960 6569152
17:16:21 5361 8192000000 10810165408 11240452096 1896519456 18.798 100 32 64 2 1912658128 6926240 9212432
17:16:34 8895 8192000000 10804180672 11233026048 1873660416 18.614 99 20 39 0 1884579120 5538912 5379792
17:16:53 5840 8192000000 10798524512 11224748032 1868947440 18.576 99 30 58 2 1883789008 6578848 8262720
17:17:04 9329 8192000000 10790935536 11216478208 1813472496 18.124 96 29 58 1 1832817424 11247904 8097024
17:17:20 71609 8192000000 10813729408 11224453120 1843117008 18.366 98 33 67 2 1858110048 5257440 9735600
17:18:38 5984 8192000000 10792467584 11218550784 1874275104 18.619 100 48 94 2 1898494912 10242528 13977280
17:18:51 5617 8192000000 10766984480 11188744192 1833217648 18.286 98 35 68 1 1849047056 6187200 9642208
17:19:04 7398 8192000000 10769621264 11197857792 1853990768 18.455 100 21 42 2 1866284848 6143152 6150928
17:19:18 5293 8192000000 10755245408 11174367232 1813836240 18.127 98 46 92 1 1838830672 10964240 14030192
17:19:29 3722 8192000000 10770171392 11190693888 1848131216 18.407 100 40 81 0 1871578544 11446192 12001136
17:19:39 5382 8192000000 10767868912 11184197632 1831552000 18.272 99 27 54 1 1845619904 6182048 7885856
17:19:51 6128 8192000000 10713740032 11134947328 1726882768 17.410 94 29 59 1 1741333184 6262624 8187792
17:20:05 6516 8192000000 10722687712 11147956224 1808693648 18.085 99 19 38 3 1819850704 5775296 5381760
17:20:19 4538 8192000000 10718762288 11120697344 1758770496 17.674 97 30 59 3 1771949024 4998336 8180192
17:20:31 13367 8192000000 10707460016 11125010432 1776396528 17.820 98 33 64 1 1791558496 6306688 8855280
17:21:07 21918 8192000000 10705517408 11122913280 1725940976 17.402 95 34 68 2 1741706176 5316240 10448960
17:21:41 9812 8192000000 10699558544 11116806144 1730933840 17.443 96 27 54 1 1747949200 9904064 7111296
17:21:59 5198 8192000000 10719522880 11132592128 1801079456 18.023 100 40 80 0 1820370016 8095872 11194688
17:22:10 6745 8192000000 10706303824 11114643456 1744187072 17.553 97 29 58 1 1758305360 5831568 8286720
17:22:26 4756 8192000000 10726901824 11136663552 1808675888 18.085 100 34 69 2 1829065264 11082032 9307344
17:22:37 5656 8192000000 10698927568 11108851712 1756913808 17.659 98 41 82 1 1780532192 11677296 11941088
17:22:52 6341 8192000000 10723904976 11139854336 1794153984 17.966 99 37 73 4 1814940128 10337872 10448272
17:23:05 8817 8192000000 10728260016 11142733824 1808447808 18.083 100 22 45 3 1820879952 6189376 6242768
17:23:20 8230 8192000000 10716871344 11141029888 1779494704 17.845 98 23 44 2 1791677728 5993088 6189936
17:23:36 8182 8192000000 10743442944 11162808320 1824150768 18.212 100 27 54 1 1838620000 5587568 8881664
17:23:54 6661 8192000000 10742720176 11159937024 1814785040 18.135 99 24 48 2 1827169888 5488592 6896256
17:24:07 10871 8192000000 10737386448 11163762688 1824666672 18.216 100 21 42 1 1835756720 5163600 5926448
17:24:25 9446 8192000000 10751569552 11175481344 1837039056 18.317 100 28 56 2 1850514672 5530080 7945536
17:24:43 49082 8192000000 10770109008 11189170176 1844867312 18.380 100 32 64 4 1859964416 6247600 8849504
17:25:38 20803 8192000000 10768397184 11192410112 1849258512 18.416 100 23 46 2 1862106512 6148704 6699296
17:26:07 6270 8192000000 10759014176 11192123392 1854455104 18.458 100 30 59 2 1868191824 5106928 8629792
17:26:20 8411 8192000000 10770149040 11196530688 1855706656 18.468 100 35 69 3 1871284816 5898400 9679760
17:26:35 5947 8192000000 10770365552 11192619008 1854758896 18.461 100 20 40 0 1866485728 5292704 6434128
17:26:47 6401 8192000000 10761961056 11195842560 1856502416 18.475 100 21 42 1 1869291296 6678832 6110048
17:27:00 5725 8192000000 10775942656 11207147520 1862333280 18.522 100 19 37 1 1872249760 5111056 4805424
17:27:12 20047 8192000000 10812898720 11230556160 1881814096 18.680 100 37 75 1 1898717872 5578576 11325200
17:27:58 13279 8192000000 10819275216 11242459136 1897160848 18.803 100 40 80 2 1914620336 6325456 11134032
17:28:24 19446 8192000000 10837283056 11259514880 1912693472 18.928 100 38 76 1 1935560992 12019840 10847680
17:28:56 12570 8192000000 10846298704 11271778304 1920066944 18.987 100 47 94 2 1943189248 10098080 13024224
17:29:17 22262 8192000000 10859352400 11283533824 1926877616 19.042 100 48 96 1 1957386080 16594576 13913888
17:29:51 16190 8192000000 10863020256 11286519808 1929584560 19.064 100 43 86 1 1954138192 12468384 12085248
17:30:15 20560 8192000000 10871567136 11297144832 1937721936 19.129 100 44 88 2 1963558320 13213520 12622864
17:30:49 12763 8192000000 10891462672 11309887488 1948762976 19.217 100 51 99 1 1976381040 13850272 13767792
17:31:19 86762 8192000000 10892108672 11333431296 1956094272 19.275 100 45 90 0 1988151680 18773440 13283968
17:33:40 50032 8192000000 10913349840 11347935232 1968943328 19.377 100 31 62 1 2000747088 21554848 10248912
17:34:38 23253 8192000000 10924797440 11359903744 1974569984 19.422 100 45 90 2 2014519952 26049712 13900256
17:35:13 24245 8192000000 10921082368 11354353664 1957016624 19.282 99 39 78 0 1996977504 27599296 12361584
17:35:46 7161 8192000000 10929505952 11359559680 1976940656 19.440 100 44 88 1 2017448464 26927600 13580208
17:36:02 8762 8192000000 10946509632 11370119168 1986163552 19.513 100 61 120 3 2033320928 28578784 18578592
17:36:30 5426 8192000000 10953813808 11377733632 1991640880 19.557 100 71 142 0 2041049088 27100752 22307456
17:36:43 3508 8192000000 10932726528 11359772672 1965196368 19.347 99 59 114 0 2013040160 30627056 17216736
17:36:53 2749 8192000000 10934634688 11359948800 1980981840 19.472 100 72 145 1 2024824080 22938096 20904144
17:37:03 7679 8192000000 10935196128 11366699008 1984858032 19.503 100 58 114 2 2026054224 23989760 17206432
17:37:20 3772 8192000000 10955620384 11374804992 1997459488 19.603 100 80 156 1 2044906176 23722992 23723696
17:37:32 1655 8192000000 10963115600 11378241536 1997334464 19.602 100 80 157 0 2046240608 24921216 23984928
17:37:40 3487 8192000000 10958256864 11377803264 1993507808 19.572 100 67 133 2 2038814480 25562096 19744576
17:37:54 6512 8192000000 10959204656 11384467456 1996831232 19.598 100 73 145 0 2046267600 27451696 21984672
17:38:08 1290 8192000000 10966278624 11385049088 1999440544 19.618 100 78 156 0 2051020416 28543360 23036512
17:38:17 2586 8192000000 10974005472 11393282048 2001912736 19.638 100 79 158 1 2057082400 31738160 23431504
17:38:28 3143 8192000000 10970508080 11390230528 1997931904 19.606 100 78 155 1 2054354752 32970864 23451984
17:38:38 1191 8192000000 10976567840 11388600320 2004851776 19.661 100 89 180 1 2065261600 33222832 27186992
17:38:46 1704 8192000000 10990873392 11402186752 2009493280 19.698 100 91 182 0 2070896016 33968176 27434560
17:38:56 1880 8192000000 10983876048 11405742080 2011474320 19.713 100 83 167 2 2069308336 33549216 24284800
17:39:05 3591 8192000000 10994339648 11411038208 2011690640 19.715 100 91 179 2 2071595488 32292032 27612816
17:39:16 2423 8192000000 10967194848 11389943808 1987543328 19.524 99 85 170 1 2046901536 32035920 27322288
17:39:26 2078 8192000000 10975843040 11396063232 2006921008 19.677 100 75 148 1 2061260512 32345024 21994480
17:39:36 17760 8192000000 10978867712 11404042240 2007108304 19.679 100 73 146 0 2061658496 31952528 22597664
17:40:01 3921 8192000000 10995634368 11413381120 2016483184 19.753 100 83 166 3 2077356720 35024112 25849424
17:40:16 5216 8192000000 10987003360 11414732800 2017865744 19.763 100 71 140 1 2076349088 36651552 21831792
17:40:30 3823 8192000000 10992327840 11418431488 2016869648 19.756 100 74 148 2 2077875520 37815152 23190720
17:40:42 3506 8192000000 10980679968 11410264064 1996001952 19.591 99 64 128 0 2052736800 36790304 19944544
17:40:54 4357 8192000000 10988844352 11420024832 2018064016 19.765 100 78 154 2 2080373680 38223184 24086480
17:41:06 1606 8192000000 10974701696 11396284416 1994264704 19.577 99 82 165 0 2059000608 39308896 25427008
17:41:26 2168 8192000000 10980915776 11402309632 1986347808 19.515 99 82 161 2 2054117344 42216112 25553424
17:41:36 4811 8192000000 10968897936 11387318272 1981850416 19.479 100 75 148 0 2046695808 40957536 23887856
17:41:48 1579 8192000000 10978036048 11393576960 1990419296 19.547 100 82 164 0 2059621744 42534864 26667584
17:41:58 1460 8192000000 10994681440 11407806464 1998925456 19.614 100 79 157 0 2065890784 42319152 24646176
17:42:08 1866 8192000000 10978671776 11400413184 1995543776 19.588 100 82 165 0 2064437008 42796192 26097040
17:42:18 1563 8192000000 10995639472 11408723968 2003184240 19.648 100 94 189 0 2074526048 42059504 29282304
17:42:25 2078 8192000000 10963710288 11387179008 1982670800 19.486 100 83 165 2 2051553168 42627632 26254736
17:42:37 4383 8192000000 10952619904 11372699648 1961772656 19.320 99 80 158 1 2024628144 38255552 24599936
17:42:48 2459 8192000000 10958618560 11374166016 1947544720 19.207 98 84 166 0 2013820192 41257104 25018368
17:42:58 3343 8192000000 10942555248 11362222080 1963201056 19.331 100 78 156 3 2029291936 41626112 24464768
17:43:09 4784 8192000000 10924745824 11344216064 1943743088 19.177 99 67 131 0 2006594080 42346624 20504368
17:43:23 3871 8192000000 10946863056 11365433344 1965795296 19.352 100 75 149 0 2029550992 40499456 23256240
17:43:35 3440 8192000000 10957708400 11375820800 1976921056 19.440 100 77 154 1 2041259536 40595392 23743088
17:43:45 2285 8192000000 10965535088 11373821952 1961457664 19.318 99 90 177 1 2031319600 42288496 27573440
17:43:56 3717 8192000000 10961453408 11375214592 1974136752 19.418 100 78 153 3 2038711248 40428480 24146016
17:44:07 3317 8192000000 10964416368 11379855360 1976977408 19.441 100 79 156 2 2045573984 44537920 24058656
17:44:19 2438 8192000000 10986868496 11397873664 1983754208 19.494 100 87 174 2 2056629424 45732240 27142976
17:44:31 5220 8192000000 10972874560 11395158016 1986550208 19.517 100 76 152 2 2056868288 46322592 23995488
17:44:43 3347 8192000000 10987620208 11400962048 1990113472 19.545 100 75 148 0 2062933216 49738896 23080848
17:44:54 3762 8192000000 10969055824 11393273856 1971433648 19.397 99 65 129 1 2041030832 49364752 20232432
17:45:05 2612 8192000000 10978469072 11399725056 1975760880 19.431 99 91 179 0 2054631040 50680976 28189184
17:45:15 1893 8192000000 10986021824 11404111872 1987660528 19.525 100 73 146 0 2064346336 53433280 23252528
17:45:30 3624 8192000000 11001315760 11420160000 1998211024 19.609 100 83 164 1 2080559088 56627232 25720832
17:45:42 4252 8192000000 10984498416 11418603520 1992211696 19.561 100 65 130 2 2070889744 57518688 21159360
17:45:58 3533 8192000000 10961817296 11399372800 1981289760 19.475 100 47 94 2 2046443040 49743360 15409920
17:46:12 14891 8192000000 10900152608 11338936320 1898353152 18.813 96 33 66 1 1956999280 47096576 11549552
17:46:35 8491 8192000000 10935364720 11370045440 1954660624 19.264 100 47 94 3 2013615472 43228416 15726432
17:46:50 17130 8192000000 10915214368 11357827072 1938283712 19.133 99 32 64 2 1993967664 45040880 10643072
17:47:14 12489 8192000000 10925922672 11368615936 1941799344 19.161 99 36 72 2 1998816384 44611248 12405792
17:47:39 17215 8192000000 10907231200 11356160000 1928107184 19.052 99 35 70 2 1984812256 45055616 11649456
17:48:09 14364 8192000000 10914642912 11367923712 1946978272 19.202 100 27 54 1 2006248672 50076112 9194288
17:48:50 10157 8192000000 10917527712 11363741696 1952376480 19.245 100 35 70 4 2004719920 41314240 11029200
17:49:11 21712 8192000000 10907983712 11356504064 1936311152 19.117 99 31 62 2 1985867536 38827312 10729072
17:49:40 15114 8192000000 10908352224 11348353024 1914966656 18.946 98 28 56 0 1961767312 37311296 9489360
17:50:03 14814 8192000000 10903532848 11355639808 1944799504 19.185 100 36 72 1 1997188464 40705104 11683856
17:50:27 22408 8192000000 10897589456 11348656128 1924416352 19.022 99 18 36 1 1967837216 37122384 6298480
17:51:17 23464 8192000000 10894062688 11349200896 1935680896 19.112 100 24 48 0 1987366960 43483056 8203008
17:51:47 19210 8192000000 10884238688 11342114816 1906517568 18.879 99 24 48 0 1956394368 41692528 8184272
17:52:17 25724 8192000000 10877990960 11337150464 1902665376 18.848 99 16 30 2 1958675408 49545360 6464672
17:52:49 14283 8192000000 10878220384 11337736192 1907155728 18.884 99 23 46 0 1952042528 37752096 7134704
17:53:18 24867 8192000000 10847246048 11298107392 1892960672 18.770 98 20 40 2 1905876304 6977392 5938240
17:53:56 44415 8192000000 10876416400 11316436992 1913859072 18.938 99 38 76 2 1938153520 12900944 11393504
17:54:47 53640 8192000000 10859117648 11331174400 1908559152 18.895 99 15 30 0 1925871296 12820112 4492032
17:55:47 113517 8192000000 10845056848 11303559168 1832623392 18.281 95 15 30 0 1849654384 13094480 3936512
17:57:48 118308 8192000000 10877091872 11326709760 1901236736 18.836 98 26 52 0 1916294256 8562496 6495024
18:00:04 31681 8192000000 10880548240 11330617344 1914085200 18.939 98 39 77 1 1935436880 10159568 11192112
18:00:55 87246 8192000000 10874304448 11345305600 1930623408 19.072 99 19 38 0 1947474192 11981728 4869056
18:02:31 7320 8192000000 10908109664 11338170368 1945731968 19.192 99 75 150 1 1974313936 6666272 21915696
18:02:44 5701 8192000000 10916999328 11344826368 1962124256 19.323 100 76 149 1 1991128624 8346304 20658064
18:02:57 95941 8192000000 10884568592 11337490432 1864956608 18.543 95 20 40 0 1879307968 8264784 6086576
18:04:39 23374 8192000000 10912983120 11343069184 1963198384 19.331 100 38 73 2 1985627200 11994656 10434160
18:05:10 52610 8192000000 10894160528 11361120256 1960952912 19.314 100 29 56 0 1983299680 14041920 8304848
18:06:10 47759 8192000000 10882499392 11350327296 1921657872 19.000 98 12 24 0 1939439376 13937200 3844304
18:07:58 45350 8192000000 10884751424 11344723968 1953649456 19.256 99 17 34 2 1974193760 15513808 5030496
18:09:54 83470 8192000000 10908866032 11379347456 1982886608 19.488 100 20 40 2 2005008288 15589104 6532576
18:11:24 98462 8192000000 10900107328 11367170048 1950067248 19.227 99 12 24 0 1971194960 17676704 3451008
18:13:09 71868 8192000000 10909981344 11369152512 1960736096 19.312 99 12 24 2 1972973936 9183648 3054192
18:14:29 29926 8192000000 10906630624 11360980992 1943320928 19.173 98 34 68 0 1961191008 8466064 9404016
18:15:08 29509 8192000000 10917464096 11382468608 1985950752 19.512 100 41 81 3 2007437744 9475296 12011696
18:16:02 54069 8192000000 10907757920 11385659392 1947250528 19.205 98 23 46 1 1968411840 14318064 6843248
18:17:03 93834 8192000000 10912431648 11388043264 1939801072 19.145 98 7 14 1 1957761600 16166048 1794480
18:18:43 52332 8192000000 10927874336 11376082944 1944571728 19.183 98 32 64 2 1966176976 12090880 9514368
18:19:43 62134 8192000000 10899856080 11372752896 1959463936 19.302 99 19 38 1 1976598576 12008768 5125872
18:20:52 59961 8192000000 10916613792 11373957120 1905772096 18.873 96 22 44 2 1922384656 10933984 5678576
18:22:02 58901 8192000000 10897874832 11367358464 1886634080 18.719 95 15 30 1 1909219920 18088672 4497168
18:24:06 45695 8192000000 10891343392 11359457280 1919401280 18.982 98 12 24 0 1940691584 18109984 3180320
18:25:28 101183 8192000000 10896163856 11362963456 1948568688 19.215 99 19 38 0 1960156896 6666096 4922112
18:27:15 73728 8192000000 10896785888 11371667456 1938184240 19.132 98 19 38 0 1957622912 14454208 4984464
18:28:35 20710 8192000000 10871303984 11344523264 1911797584 18.921 97 16 32 0 1929238944 13262272 4179088
18:29:03 1825 8192000000 10915666416 11357634560 1970854880 19.392 100 46 87 2 1990957200 7869648 12232672
18:29:11 5124 8192000000 10901900336 11350396928 1952483312 19.246 99 46 89 3 1972470128 7978640 12008176
18:29:23 31828 8192000000 10906541168 11353460736 1956480224 19.278 100 43 86 1 1978241152 9850512 11910416
18:30:16 34080 8192000000 10863205056 11330801664 1921589024 19.000 98 22 45 1 1933342944 6019440 5734480
18:30:57 52243 8192000000 10878394304 11350110208 1964320784 19.340 100 14 27 0 1974775328 6784032 3670512
18:31:56 60959 8192000000 10848031312 11323645952 1914330656 18.941 97 16 32 0 1928347680 8663856 5353168
18:33:11 94231 8192000000 10881098080 11350777856 1954765552 19.264 100 13 26 0 1966363424 7748576 3849296
18:35:45 20535 8192000000 10864586736 11319160832 1911552432 18.919 98 22 45 3 1925436944 7316480 6568032
18:36:12 38883 8192000000 10876939648 11334090752 1914849904 18.946 98 28 56 2 1933299120 10147952 8301264
18:37:02 39103 8192000000 10868689088 11341647872 1912103920 18.924 98 19 38 0 1930329280 13018800 5206560
18:37:52 73346 8192000000 10854338112 11325370368 1852999424 18.446 95 11 22 1 1864892112 8855408 3037280
18:39:12 25152 8192000000 10870911856 11331092480 1922044784 19.003 99 28 56 1 1937909392 8376384 7488224
18:39:44 31414 8192000000 10842679168 11303956480 1886843840 18.720 97 31 62 2 1905380208 10109584 8426784
18:40:25 39454 8192000000 10886755456 11342491648 1915371392 18.950 98 29 57 1 1931620960 8435472 7814096
18:41:15 33721 8192000000 10859348400 11321262080 1904317136 18.861 98 25 50 3 1922283216 10806304 7159776
18:41:55 29743 8192000000 10861313376 11325939712 1893097376 18.771 98 13 27 2 1911585024 14794368 3693280
18:42:30 60587 8192000000 10864796176 11333332992 1881255904 18.675 97 18 36 0 1902490784 16189360 5045520
18:43:43 53371 8192000000 10868121232 11329843200 1879650928 18.662 97 20 40 2 1899007440 13823632 5532880
18:44:52 59561 8192000000 10874930416 11327258624 1906771312 18.881 98 21 42 0 1926086640 13703424 5611904
18:46:01 141173 8192000000 10854739888 11326169088 1874665856 18.622 96 24 46 0 1898672768 17856224 6150688
18:48:29 21057 8192000000 10876843360 11329052672 1938884896 19.138 100 39 77 0 1958096688 7867264 11344528
18:49:00 74315 8192000000 10887130208 11339276288 1946624736 19.200 100 44 88 3 1971126432 12236976 12264720
18:51:05 44748 8192000000 10860770400 11330740224 1928403312 19.054 99 20 40 1 1944755488 9765984 6586192
18:52:06 23355 8192000000 10868632064 11345080320 1949450464 19.222 100 15 28 2 1964900048 11023488 4426096
18:52:36 32869 8192000000 10859023216 11336892416 1931440080 19.078 99 11 22 0 1946773408 12384928 2948400
18:54:23 32465 8192000000 10875959344 11353387008 1950839392 19.233 100 13 26 0 1965082864 10774384 3469088
18:55:02 89730 8192000000 10874543280 11350749184 1915310240 18.949 98 7 14 0 1928474704 11354080 1810384
18:56:42 46061 8192000000 10865090736 11338166272 1919473648 18.983 98 14 27 1 1932178416 8573424 4131344
18:57:39 47284 8192000000 10896487456 11366985728 1950418048 19.230 99 12 24 0 1964579248 10693712 3467488
18:58:38 82183 8192000000 10891406336 11363332096 1914573824 18.943 97 17 34 0 1931722288 12311952 4836512
19:00:06 83854 8192000000 10910267728 11375931392 1970697760 19.391 100 8 16 1 1982752288 10020448 2034080
19:01:42 23203 8192000000 10925415168 11381182464 1985953600 19.512 100 34 66 1 2001923056 6659536 9309920
19:02:21 38389 8192000000 10924564624 11390939136 1992946320 19.567 100 33 66 1 2011713152 9575216 9191616
19:03:19 76165 8192000000 10903233680 11342196736 1839415184 18.336 93 25 50 1 1855928384 9146912 7366288
19:04:50 92669 8192000000 10894642672 11378462720 1942519200 19.167 99 17 34 3 1961529760 14523152 4487408
19:06:29 78160 8192000000 10892211280 11336122368 1828409632 18.246 93 13 26 0 1841572848 9487536 3675680
19:07:54 14015 8192000000 10888432432 11344506880 1952051760 19.243 100 36 72 0 1973617968 11284336 10281872
19:08:14 46774 8192000000 10892992928 11372359680 1952057088 19.243 100 21 42 1 1973045840 15229168 5759584
19:09:10 111779 8192000000 10890707856 11372597248 1936507184 19.119 99 6 12 1 1959224528 21238560 1478784
19:11:19 67048 8192000000 10888507792 11356725248 1929360592 19.062 98 35 70 1 1951708944 12026992 10321360
19:12:32 13354 8192000000 10892502320 11360149504 1958326416 19.293 100 33 64 3 1980788880 13298656 9163808
19:12:53 52774 8192000000 10889750720 11366416384 1926729456 19.041 98 21 42 1 1952019584 19954272 5335856
19:13:54 56845 8192000000 10876505776 11354992640 1928690368 19.056 98 9 18 0 1940765312 9701840 2373104
19:14:57 60671 8192000000 10875970624 11353501696 1923719632 19.017 98 9 18 0 1939232784 12800096 2713056
19:16:04 68823 8192000000 10869450208 11346309120 1896921776 18.802 97 11 23 1 1914156096 14004992 3229328
19:17:19 96003 8192000000 10884469632 11360673792 1926839264 19.042 98 14 25 0 1945822992 14921792 4061936
19:19:05 89249 8192000000 10865667088 11337515008 1899567936 18.823 97 15 30 2 1924321712 19205680 5548096
19:21:15 65149 8192000000 10870075504 11343003648 1913888192 18.938 98 13 26 0 1925826832 8184064 3754576
19:22:27 52031 8192000000 10853568864 11322449920 1870531376 18.589 96 16 32 2 1884215664 9123952 4560336
19:23:26 48445 8192000000 10854920512 11314089984 1879125056 18.658 97 36 72 0 1900636848 11456880 10054912
19:24:37 45590 8192000000 10851698224 11305807872 1871156192 18.594 97 26 52 0 1889210784 10465680 7588912
19:25:29 61722 8192000000 10876732432 11340152832 1934628816 19.104 100 17 34 0 1949422016 10208000 4585200
19:26:45 40111 8192000000 8892751232 9034723328 68126400 0.824 4 2 4 0 70843280 2565040 151840

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 07-01-2021 19:28:23 to 07-01-2021 19:28:55.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 123 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 07-01-2021 19:28:56 to 07-01-2021 19:28:58.

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          239469
MON$OLDEST_ACTIVE               239470
MON$OLDEST_SNAPSHOT             239470
MON$NEXT_TRANSACTION            239470
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                       2019840
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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 ---
--- end of diff output ---

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

07.01.21 19:28:59. 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-01-07 19:29:02 No severe PSQL-related problems occured
07.01.21 19:29:03. End of report.