explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mMTe : Optimization for: plan #yoYJ

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Update on pulse_survey_results (cost=7,601.3..7,609.38 rows=1 width=351) (never executed)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=7,601.3..7,609.38 rows=1 width=351) (never executed)

3. 0.000 0.000 ↓ 0.0

Aggregate (cost=7,600.87..7,600.88 rows=1 width=32) (never executed)

4. 0.000 0.000 ↓ 0.0

Subquery Scan on ANY_subquery (cost=7,600.86..7,600.87 rows=1 width=32) (never executed)

5. 0.000 0.000 ↓ 0.0

Sort (cost=7,600.86..7,600.86 rows=1 width=4) (never executed)

  • Sort Key: pulse_survey_results_1.id
6. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on pulse_survey_results pulse_survey_results_1 (cost=853.8..7,600.85 rows=1 width=4) (never executed)

  • Filter: (("audienceGroupIds")::character varying[] && '{}'::character varying[])
7. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on pulse_survey_results_boxid_userid_tagid_unique (cost=0..853.8 rows=1,894 width=0) (never executed)

  • Index Cond: (("boxId" = '5dde9d986793f5001a0786ce'::bpchar) AND ("tagId" IS NULL))
8. 0.000 0.000 ↓ 0.0

Index Scan using pulse_survey_results_pkey on pulse_survey_results pulse_survey_results (cost=0.42..8.44 rows=1 width=1,284) (never executed)

  • Index Cond: (id = "ANY_subquery".id)