explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uauk : Plan 1

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Merge Join (cost=43.83..12,394,079.64 rows=17,582,998 width=40) (actual rows= loops=)

  • Merge Cond: (t1.id = t2.id)
2. 0.000 0.000 ↓ 0.0

Index Scan using pk_t1 on t1 (cost=0.57..666,228.59 rows=18,598,858 width=30) (actual rows= loops=)

  • Index Cond: (id > (-9223372036513411363)::bigint)
3. 0.000 0.000 ↓ 0.0

Index Scan using pk_t2 on t2 (cost=0.57..10,657,140.69 rows=339,691,008 width=10) (actual rows= loops=)