explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mOYe

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.016 ↑ 25,538.0 1 1

Nested Loop (cost=0.00..76,684.85 rows=25,538 width=16) (actual time=0.015..0.016 rows=1 loops=1)

  • Join Filter: (tab1.id = tab2.id)
  • Rows Removed by Join Filter: 8
2. 0.005 0.005 ↑ 753.3 3 1

Seq Scan on tab1 (cost=0.00..32.60 rows=2,260 width=8) (actual time=0.005..0.005 rows=3 loops=1)

3. 0.004 0.006 ↑ 753.3 3 3

Materialize (cost=0.00..43.90 rows=2,260 width=8) (actual time=0.001..0.002 rows=3 loops=3)

4. 0.002 0.002 ↑ 753.3 3 1

Seq Scan on tab2 (cost=0.00..32.60 rows=2,260 width=8) (actual time=0.002..0.002 rows=3 loops=1)

Planning time : 0.045 ms
Execution time : 0.032 ms