explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UxcW

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

Merge Join (cost=317.01..711.38 rows=25,538 width=16) (actual time=0.016..0.016 rows=1 loops=1)

  • Merge Cond: (tab1.id = tab2.id)
2. 0.004 0.010 ↑ 753.3 3 1

Sort (cost=158.51..164.16 rows=2,260 width=8) (actual time=0.009..0.010 rows=3 loops=1)

  • Sort Key: tab1.id
  • Sort Method: quicksort Memory: 25kB
3. 0.006 0.006 ↑ 753.3 3 1

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

4. 0.002 0.004 ↑ 1,130.0 2 1

Sort (cost=158.51..164.16 rows=2,260 width=8) (actual time=0.004..0.004 rows=2 loops=1)

  • Sort Key: tab2.id
  • Sort Method: quicksort Memory: 25kB
5. 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.001..0.002 rows=3 loops=1)

Planning time : 0.047 ms
Execution time : 0.030 ms