explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2c2H : test

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.010 ↑ 1.0 10 1

Limit (cost=0.00..0.22 rows=10 width=64) (actual time=0.008..0.010 rows=10 loops=1)

  • Output: table_schema, table_name, table_rows, data_size, has_primary, has_unique
  • Buffers: shared hit=1
2. 0.008 0.008 ↑ 24,467.2 10 1

Seq Scan on public.test2 (cost=0.00..5,449.72 rows=244,672 width=64) (actual time=0.007..0.008 rows=10 loops=1)

  • Output: table_schema, table_name, table_rows, data_size, has_primary, has_unique
  • Buffers: shared hit=1