explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hZbt

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

Subquery Scan on net_promoter_score (cost=318,817.04..325,536.91 rows=2,240 width=32) (actual rows= loops=)

  • Filter: ((net_promoter_score.ord_obj_guid)::text = 'd9e3265b-3c3f-fc20-eb41-22abcce22973'::text)
2. 0.000 0.000 ↓ 0.0

Sort (cost=318,817.04..319,937.02 rows=447,991 width=58) (actual rows= loops=)

  • Sort Key: "*SELECT* 1".date_added
3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=272,286.21..276,766.12 rows=447,991 width=58) (actual rows= loops=)

  • Group Key: "*SELECT* 1".ord_obj_guid, "*SELECT* 1".survey_date, "*SELECT* 1".survey_number, "*SELECT* 1".score, "*SELECT* 1".date_added
4. 0.000 0.000 ↓ 0.0

Append (cost=16,877.86..266,686.32 rows=447,991 width=58) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 1 (cost=16,877.86..17,112.49 rows=15,630 width=112) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Unique (cost=16,877.86..16,956.19 rows=15,630 width=112) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Sort (cost=16,877.86..16,917.02 rows=15,667 width=112) (actual rows= loops=)

  • Sort Key: survey_monkey_results.ord_obj_guid
8. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,355.88..15,786.22 rows=15,667 width=112) (actual rows= loops=)

  • Hash Cond: ((survey_monkey_survey_answers.survey_monkey_results_guid)::text = (survey_monkey_results.survey_monkey_results_guid)::text)
9. 0.000 0.000 ↓ 0.0

Seq Scan on survey_monkey_survey_answers (cost=0.00..12,175.76 rows=15,667 width=87) (actual rows= loops=)

  • Filter: nps_question
10. 0.000 0.000 ↓ 0.0

Hash (cost=3,160.44..3,160.44 rows=15,635 width=99) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Seq Scan on survey_monkey_results (cost=0.00..3,160.44 rows=15,635 width=99) (actual rows= loops=)

  • Filter: ((survey_type)::text = 'nps'::text)
12. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 2 (cost=243,088.42..249,573.83 rows=432,361 width=56) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Unique (cost=243,088.42..245,250.22 rows=432,361 width=56) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Sort (cost=243,088.42..244,169.32 rows=432,361 width=56) (actual rows= loops=)

  • Sort Key: ord_ivr.ord_obj_guid
15. 0.000 0.000 ↓ 0.0

Hash Join (cost=79,341.20..202,615.37 rows=432,361 width=56) (actual rows= loops=)

  • Hash Cond: ((ord_ivr_survey_results.ord_ivr_guid)::text = (ord_ivr.ord_ivr_guid)::text)
16. 0.000 0.000 ↓ 0.0

Seq Scan on ord_ivr_survey_results (cost=0.00..116,248.30 rows=432,361 width=45) (actual rows= loops=)

  • Filter: ((question_result <> ''::text) AND (question_number = 4))
17. 0.000 0.000 ↓ 0.0

Hash (cost=62,952.20..62,952.20 rows=1,311,120 width=85) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Seq Scan on ord_ivr (cost=0.00..62,952.20 rows=1,311,120 width=85) (actual rows= loops=)