Observation and diagnostics · Intermediate
Reading EXPLAIN ANALYZE
Separate estimates from measurements and interpret row counts, loops, and buffers when investigating PostgreSQL query plans.
Read and check your understanding →LAVACS KNOWLEDGE
Learn measurement tools, interpret their output, and understand what the numbers cannot establish.
25 articles · page 1 of 2
Observation and diagnostics · Intermediate
Separate estimates from measurements and interpret row counts, loops, and buffers when investigating PostgreSQL query plans.
Read and check your understanding →Observation and diagnostics · Intermediate
Follow requests across the application–kernel boundary to investigate file access, network waits, and error returns.
Read and check your understanding →Observation and diagnostics · Intermediate
Interpret instructions, cycles, context switches, and faults alongside elapsed time when comparing Linux workloads.
Read and check your understanding →Observation and diagnostics · Intermediate
Inspect listening sockets, connection states, and queues to narrow down where a Linux communication problem occurs.
Read and check your understanding →Observation and diagnostics · Intermediate
Distinguish free memory, reclaimable uses, and process residency when investigating memory pressure on Linux.
Read and check your understanding →Observation and diagnostics · Intermediate
Read device request rates, delay and activity over matched windows and relate them to application latency and storage layers.
Read and check your understanding →Observation and diagnostics · Intermediate
Align vmstat time windows and units, distinguish memory occupancy from movement, and use host-wide signals to choose a focused follow-up measurement.
Read and check your understanding →Observation and diagnostics · Intermediate
Align process identity and sampling windows, then use CPU, fault and I/O observations to choose the next execution path to investigate.
Read and check your understanding →Observation and diagnostics · Intermediate
Compare retained activity observations with aligned times and units, recognizing the limits of averages and missing collection.
Read and check your understanding →Observation and diagnostics · Intermediate
Read per-node placement and allocation statistics while distinguishing them from CPU execution location and actual memory accesses.
Read and check your understanding →Observation and diagnostics · Intermediate
Separate connection, statement and transaction state and clocks, then use wait events and blockers to investigate current backend work.
Read and check your understanding →Observation and diagnostics · Intermediate
Read lock targets, modes and granted state, then trace blocking with mode compatibility and queue dependencies in view.
Read and check your understanding →Observation and diagnostics · Intermediate
Compare normalized SQL counts and execution-time deltas over a matched interval to distinguish accumulated workload cost from individual-request latency.
Read and check your understanding →Observation and diagnostics · Intermediate
Separate vacuum activity, phase progress and reclaimability while considering retained snapshots and transaction-ID protection.
Read and check your understanding →Observation and diagnostics · Intermediate
Interpret index counters with their windows and units, evaluating retrieval, writes, constraints and infrequent operational work.
Read and check your understanding →Observation and diagnostics · Intermediate
Limit capture scope and use packet sequences while accounting for encryption, observation location and capture loss.
Read and check your understanding →Observation and diagnostics · Intermediate
Fix the DNS name, record type and server, then distinguish authoritative data, recursive answers, negative caching and DNSSEC indicators.
Read and check your understanding →Observation and diagnostics · Intermediate
Separate resolution, connection, TLS and HTTP stages, preserving request conditions and interpreting status independently from curl exit codes.
Read and check your understanding →Observation and diagnostics · Intermediate
Compare hop responses with destination results while accounting for control-plane rate limits, path differences and round-trip measurements.
Read and check your understanding →Observation and diagnostics · Intermediate
Align SNI, destination, verification name and trust settings, separating TLS negotiation from certificate validation and application success.
Read and check your understanding →Observation and diagnostics · Intermediate
Interpret stack-sample widths and hierarchy without confusing inclusive cost, elapsed time, or visual position with execution chronology.
Read and check your understanding →Observation and diagnostics · Intermediate
Use Python tracemalloc to distinguish retained traced memory, peak usage, process RSS, allocation origins, and retention causes.
Read and check your understanding →Observation and diagnostics · Intermediate
Separate cumulative allocation traffic from retained memory when investigating garbage-collection work, repeated copies, and allocation counts.
Read and check your understanding →Observation and diagnostics · Intermediate
Read W3C traceparent identifiers and diagnose propagation gaps without treating tracing metadata as authentication or automatic causal proof.
Read and check your understanding →Use the knowledge map to find prerequisites, or follow a learning path in order.