explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 64Ts

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 0.023 ↑ 1.0 2 1

Nested Loop (cost=0..2.06 rows=2 width=76) (actual time=0.021..0.023 rows=2 loops=1)

  • Buffers: shared hit=2
2. 0.005 0.005 ↑ 1.0 2 1

Seq Scan on test t (cost=0..1.02 rows=2 width=40) (actual time=0.005..0.005 rows=2 loops=1)

  • Buffers: shared hit=1
3. 0.006 0.010 ↑ 1.0 1 2

Materialize (cost=0..1.01 rows=1 width=36) (actual time=0.005..0.005 rows=1 loops=2)

  • Buffers: shared hit=1
4. 0.004 0.004 ↑ 1.0 1 1

Seq Scan on test_oids toi (cost=0..1.01 rows=1 width=36) (actual time=0.004..0.004 rows=1 loops=1)

  • Buffers: shared hit=1