explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EJKv

Settings
# exclusive inclusive rows x rows loops node
1. 0.037 30.626 ↑ 1.0 100 1

Merge Join (cost=5.80..10.77 rows=100 width=4) (actual time=30.523..30.626 rows=100 loops=1)

  • Merge Cond: (t2.c1 = t3.c1)
  • Buffers: shared hit=9 read=1
  • I/O Timings: read=30.449
2. 0.050 0.050 ↑ 9,901.0 101 1

Index Only Scan using t2_pkey on t2 (cost=0.42..30,408.42 rows=1,000,000 width=4) (actual time=0.012..0.050 rows=101 loops=1)

  • Heap Fetches: 101
  • Buffers: shared hit=5
3. 0.061 30.539 ↑ 1.0 100 1

Sort (cost=5.32..5.57 rows=100 width=4) (actual time=30.507..30.539 rows=100 loops=1)

  • Sort Key: t3.c1
  • Sort Method: quicksort Memory: 29kB
  • Buffers: shared hit=4 read=1
  • I/O Timings: read=30.449
4. 30.478 30.478 ↑ 1.0 100 1

Seq Scan on t3 (cost=0.00..2.00 rows=100 width=4) (actual time=30.472..30.478 rows=100 loops=1)

  • Buffers: shared read=1
  • I/O Timings: read=30.449
Planning time : 0.143 ms
Execution time : 30.672 ms