explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YVEq

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

Update on pulse_survey_results (cost=7,601.55..7,677.67 rows=9 width=351) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=7,601.55..7,677.67 rows=9 width=351) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=7,601.13..7,601.22 rows=9 width=32) (actual rows= loops=)

  • Group Key: "ANY_subquery".id
4. 0.000 0.000 ↓ 0.0

Subquery Scan on ANY_subquery (cost=7,600.99..7,601.10 rows=9 width=32) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Sort (cost=7,600.99..7,601.01 rows=9 width=4) (actual rows= loops=)

  • 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.80..7,600.85 rows=9 width=4) (actual rows= loops=)

  • Recheck Cond: (("boxId" = '5dde9d986793f5001a0786ce'::bpchar) AND ("tagId" IS NULL))
  • Filter: (("audienceGroupIds")::character varying[] && '{5bb3a3fd850c750019e9ebc0}'::character varying[])
7. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on pulse_survey_results_boxid_userid_tagid_unique (cost=0.00..853.80 rows=1,894 width=0) (actual rows= loops=)

  • 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 (cost=0.42..8.44 rows=1 width=1,284) (actual rows= loops=)

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