explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Arum

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

Merge Join (cost=20.20..487,709.79 rows=1,593,158 width=3,489) (actual time=0.047..14,526.230 rows=793,858 loops=1)

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

Index Scan using customer_pk on customer c (cost=0.42..185,795.08 rows=976,250 width=963) (actual time=0.025..1,809.240 rows=488,097 loops=1)

  • Filter: active
  • Rows Removed by Filter: 488,153
3. 11,276.403 11,276.403 ↑ 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.012..11,276.403 rows=1,587,600 loops=1)

Planning time : 5.082 ms
Execution time : 14,591.757 ms