>From Ritik Raj <[email protected]>: Ritik Raj has uploaded a new patch set (#2). ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21688?usp=email )
Change subject: [NO ISSUE][RT][STO] Instrument ANALYZE sampling phases and page reads ...................................................................... [NO ISSUE][RT][STO] Instrument ANALYZE sampling phases and page reads ANALYZE surfaced no buffer-cache figures: it is DDL, so it never reaches updateJobStats. The sampling job already collected them and nothing reported them, leaving elapsed time as the only signal. - Report pinned pages, cold reads and hit ratio on the ANALYZE response. - Add liveness, PK-seek and materialize counters to IOperatorStats, logged as a per-phase DEBUG breakdown. - Move SampleCursorStats to hyracks-storage-am-common and add ISampleCursorStatsReceiver so the row cursor can be instrumented. - Gate the breakdown on LOGGER.isDebugEnabled(), not a system property read once at class initialization. - Harness knobs for leaf size, tuple count and cache budget, with pin-cost and residency tests. - Condense the sampling comments from the parent commit. Ext-ref: MB-73172 Co-Authored-By: Claude Opus 5 <[email protected]> Change-Id: Ica90673813691c728d5c96b699b0363679af3813 --- M asterixdb/asterix-app/src/main/java/org/apache/asterix/app/translator/QueryTranslator.java M asterixdb/asterix-app/src/test/resources/runtimets/metrics.xml A asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/metrics/analyze-buffer-cache/analyze-buffer-cache.1.ddl.sqlpp A asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/metrics/analyze-buffer-cache/analyze-buffer-cache.2.update.sqlpp A asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/metrics/analyze-buffer-cache/analyze-buffer-cache.3.metrics.sqlpp A asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/metrics/analyze-buffer-cache/analyze-buffer-cache.4.ddl.sqlpp A asterixdb/asterix-app/src/test/resources/runtimets/results/metrics/analyze-buffer-cache/analyze-buffer-cache.3.regexadm M asterixdb/asterix-column/src/test/java/org/apache/asterix/column/test/sample/ColumnSampleBenchHarness.java M asterixdb/asterix-column/src/test/java/org/apache/asterix/column/test/sample/ColumnSampleBenchHarnessResidencyTest.java M asterixdb/asterix-column/src/test/java/org/apache/asterix/column/test/sample/ColumnSampleBenchHarnessTest.java M asterixdb/asterix-column/src/test/java/org/apache/asterix/column/test/sample/ColumnSampleCostBaselineTest.java A asterixdb/asterix-column/src/test/java/org/apache/asterix/column/test/sample/ColumnSamplePinCostTest.java A asterixdb/asterix-column/src/test/java/org/apache/asterix/column/test/sample/ColumnSampleResidencyBenchTest.java M asterixdb/asterix-column/src/test/java/org/apache/asterix/column/test/sample/ColumnSampleUniformityTest.java M asterixdb/asterix-runtime/src/main/java/org/apache/asterix/runtime/operators/DatasetStreamStatsOperatorDescriptor.java M hyracks-fullstack/hyracks/hyracks-api/src/main/java/org/apache/hyracks/api/job/profiling/IOperatorStats.java M hyracks-fullstack/hyracks/hyracks-api/src/main/java/org/apache/hyracks/api/job/profiling/NoOpOperatorStats.java M hyracks-fullstack/hyracks/hyracks-api/src/main/java/org/apache/hyracks/api/job/profiling/OperatorStats.java M hyracks-fullstack/hyracks/hyracks-storage-am-btree/src/main/java/org/apache/hyracks/storage/am/btree/impls/DiskBTreeSampleCursor.java A hyracks-fullstack/hyracks/hyracks-storage-am-common/src/main/java/org/apache/hyracks/storage/am/common/api/ISampleCursorStatsReceiver.java R hyracks-fullstack/hyracks/hyracks-storage-am-common/src/main/java/org/apache/hyracks/storage/am/common/api/SampleCursorStats.java M hyracks-fullstack/hyracks/hyracks-storage-am-lsm-btree-column/src/main/java/org/apache/hyracks/storage/am/lsm/btree/column/impls/btree/ColumnBTreeExistencePointSearchCursor.java M hyracks-fullstack/hyracks/hyracks-storage-am-lsm-btree-column/src/main/java/org/apache/hyracks/storage/am/lsm/btree/column/impls/btree/ColumnBtreeSampleCursor.java M hyracks-fullstack/hyracks/hyracks-storage-am-lsm-btree/src/main/java/org/apache/hyracks/storage/am/lsm/btree/dataflow/BTreeSampleCollectorOperatorDescriptorNodePushable.java M hyracks-fullstack/hyracks/hyracks-storage-am-lsm-btree/src/main/java/org/apache/hyracks/storage/am/lsm/btree/impls/LSMIndexSampleCursor.java M hyracks-fullstack/hyracks/hyracks-tests/hyracks-storage-am-lsm-btree-test/pom.xml M hyracks-fullstack/hyracks/hyracks-tests/hyracks-storage-am-lsm-btree-test/src/test/java/org/apache/hyracks/storage/am/lsm/btree/SampleCursorStatsTest.java 27 files changed, 879 insertions(+), 311 deletions(-) git pull ssh://asterix-gerrit.ics.uci.edu:29418/asterixdb refs/changes/88/21688/2 -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21688?usp=email To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings?usp=email Gerrit-MessageType: newpatchset Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ica90673813691c728d5c96b699b0363679af3813 Gerrit-Change-Number: 21688 Gerrit-PatchSet: 2 Gerrit-Owner: Ritik Raj <[email protected]>
