explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9me4

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.002 348,551.564 ↓ 0.0 0 1

Limit (cost=0.00..521.58 rows=1 width=3,922) (actual time=348,551.564..348,551.564 rows=0 loops=1)

2. 348,551.562 348,551.562 ↓ 0.0 0 1

Seq Scan on audience (cost=0.00..2,592,780.74 rows=4,971 width=3,922) (actual time=348,551.562..348,551.562 rows=0 loops=1)

  • Filter: ((currentmodelname IS NOT NULL) AND (replacementchromestyleid IS NOT NULL) AND (currentmodelname IS NOT NULL) AND (currentmodelyear IS NOT NULL) AND (paymentdifferencepercent < '0'::numeric) AND (replacementmodelyear = '2018'::bpchar) AND (lower((replacementmakename)::text) = 'cdjr'::text))
  • Rows Removed by Filter: 9540747
Planning time : 5.084 ms