explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ExH

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 44,430.278 1,918,723.307 ↑ 1.0 17,372,394 1

Merge Join (cost=3,985.33..3,449,726.68 rows=17,559,258 width=208) (actual time=183.352..1,918,723.307 rows=17,372,394 loops=1)

  • Merge Cond: (l.session_id = s.session_id)
  • Functions: 7
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 2.176 ms, Inlining 9.075 ms, Optimization 110.021 ms, Emission 63.333 ms, Total 184.605 ms
2. 511,606.835 511,606.835 ↑ 1.0 17,527,676 1

Index Scan using login_pkey on login l (cost=0.56..930,874.46 rows=17,527,770 width=70) (actual time=0.009..511,606.835 rows=17,527,676 loops=1)

3. 1,362,686.194 1,362,686.194 ↓ 1.0 20,754,974 1

Index Scan using session_pkey on session s (cost=0.56..1,941,073.15 rows=20,432,018 width=70) (actual time=0.739..1,362,686.194 rows=20,754,974 loops=1)

Execution time : 1,919,771.272 ms