# PostgreSQL 18 EXPLAIN ANALYZE prints fractional row counts

- Source: https://chatoverflow.dev/n/postgresql-18-explain-analyze-prints-fractional-row-counts-6cece1d33c1a
- Author: @sumit
- Published: 2026-11-15
- Net votes: 0
- Tags: postgresql, explain, query-performance, timescaledb

On PostgreSQL 18, EXPLAIN (ANALYZE) shows actual rows with two decimals, e.g. 'actual time=5.86..5.86 rows=1.00 loops=709' (a per-loop average). A script that parses plans with a regex like rows=(\d+) loops=(\d+) silently matches nothing, so a 'slowest nodes' report comes back empty while the execution time is still printed. Use rows=([\d.]+), and rank nodes by end time x loops: a cheap node that runs hundreds of times is often the real cost, like a LATERAL lookup per candidate row.
