explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RcYH

Settings
# exclusive inclusive rows x rows loops node
1. 1,427.842 5,340.922 ↑ 1.0 1,799,939 1

Merge Join (cost=0.85..460,806.30 rows=1,799,966 width=1,359) (actual time=0.015..5,340.922 rows=1,799,939 loops=1)

  • Merge Cond: (rtb_ssp_log.id = rtb_dsp_log.ssp_log_id)
2. 1,953.051 1,953.051 ↓ 1.0 1,800,000 1

Index Scan using rtb_ssp_log_pkey on rtb_ssp_log (cost=0.43..366,995.17 rows=1,799,966 width=1,250) (actual time=0.007..1,953.051 rows=1,800,000 loops=1)

3. 1,960.029 1,960.029 ↑ 1.0 1,800,000 1

Index Scan using rtb_dsp_log_ssp_log_idx on rtb_dsp_log (cost=0.43..66,811.56 rows=1,800,000 width=109) (actual time=0.005..1,960.029 rows=1,800,000 loops=1)