explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uQd : Plan 2

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

Merge Join (cost=43.83..1,362,200.10 rows=911,341 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..596,391.78 rows=17,606,469 width=10) (actual rows= loops=)

  • Index Cond: (id > (-9223372036513411363)::bigint)