explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iI7a

Settings
# exclusive inclusive rows x rows loops node
1. 20.870 20.870 ↓ 1.0 27,303 1

(postgres@[local]:7432)[scm] # EXPLAIN (ANALYZE, BUFFERS, VERBOSE) select dbmetric0_.METRIC_ID as METRIC1_25_, dbmetric0_.OPTIMISTIC_LOCK_VERSION as OPTIMIST2_25_, dbmetric0_.METRIC_IDENTIFIER as METRIC3_25_, dbmetric0_.NAME as NAME4_25_, dbmetric0_.METRIC as METRIC5_25_ from METRICS dbmetric0_;Seq Scan on public.metrics dbmetric0_ (cost=0.00..4,395.14 rows=26,914 width=1,160) (actual time=0.010..20.870 rows=27,303 loops=1)

Planning time : 0.468 ms
Execution time : 22.111 ms