explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Dmv : Optimization for: plan #9me4

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.001 0.037 ↓ 0.0 0 1

Limit (cost=0.43..38.75 rows=1 width=3,922) (actual time=0.037..0.037 rows=0 loops=1)

2. 0.036 0.036 ↓ 0.0 0 1

Index Scan using lower_case_replacementmakename on audience (cost=0.43..190,565.77 rows=4,974 width=3,922) (actual time=0.036..0.036 rows=0 loops=1)

  • Index Cond: (lower((replacementmakename)::text) = 'cdjr'::text)
  • 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))
Planning time : 1.694 ms