explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Sk1r

Settings
# exclusive inclusive rows x rows loops node
1. 1,443.682 14,377.705 ↑ 2.0 793,858 1

Merge Join (cost=20.20..487,709.64 rows=1,593,158 width=3,489) (actual time=0.078..14,377.705 rows=793,858 loops=1)

  • Merge Cond: (c.id = s.customer)
2. 1,799.659 1,799.659 ↑ 2.0 488,097 1

Index Scan using customer_pk on customer c (cost=0.42..185,794.96 rows=976,242 width=963) (actual time=0.054..1,799.659 rows=488,097 loops=1)

  • Filter: active
  • Rows Removed by Filter: 488,153
3. 11,134.364 11,134.364 ↑ 1.0 1,587,600 1

Index Scan using solution_customer_idx on solution s (cost=0.43..281,349.99 rows=1,593,158 width=2,526) (actual time=0.014..11,134.364 rows=1,587,600 loops=1)

Planning time : 12.241 ms
Execution time : 14,442.177 ms