explain.depesz.com

PostgreSQL's explain analyze made readable

Result: P9BV

Settings
# exclusive inclusive rows x rows loops node
1. 900.325 57,264.890 ↑ 4.1 30,201 1

Seq Scan on cp_offer (cost=0.00..677,190.97 rows=123,707 width=497) (actual time=385.231..57,264.890 rows=30,201 loops=1)

  • Filter: (((safedelete_dt IS NULL) AND (create_userid = 1)) OR (SubPlan 1))
  • Rows Removed by Filter: 217,206
  • Functions: 14
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 2.679 ms, Inlining 8.469 ms, Optimization 251.638 ms, Emission 124.418 ms, Total 387.204 ms"Execution Time: 57,291.254 ms
2.          

SubPlan (for Seq Scan)

3. 56,364.565 56,364.565 ↓ 0.0 0 235,835

Index Scan using cp_offer_idx29 on cp_offer o2 (cost=0.42..2.70 rows=1 width=0) (actual time=0.239..0.239 rows=0 loops=235,835)

  • Index Cond: ((create_userid = 1) AND (person_accountid = cp_offer.person_accountid))
  • Filter: ((create_dt)::date >= (cp_offer.create_dt - '14 days'::interval))
  • Rows Removed by Filter: 1