explain.depesz.com

PostgreSQL's explain analyze made readable

Result: o8Q5

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

Sort (cost=79,479.33..79,479.52 rows=76 width=264) (actual rows= loops=)

  • Sort Key: "PC0".pxupdatedatetime DESC
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.40..79,476.96 rows=76 width=264) (actual rows= loops=)

  • -> Index Scan using pk_tindividual on tindividual "Reviewee" (cost=0.29..1.62 rows=1 width=66)" Index Cond: (individual_id = "Review".reviewee_id)
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.12..79,353.15 rows=76 width=206) (actual rows= loops=)

  • Join Filter: ("ReviewGrp".qstnr_template_group_id = "QstnrTmpltGrp".qstnr_template_group_id)
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.12..79,295.83 rows=76 width=177) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.84..79,272.84 rows=76 width=146) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.41..79,233.39 rows=76 width=137) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.99..78,618.03 rows=76 width=137) (actual rows= loops=)

  • Join Filter: ("Review".questionnaire_id = "Questionnaire".questionnaire_id)
8. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.71..78,590.75 rows=76 width=110) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..78,559.13 rows=76 width=108) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on treview "Review" (cost=0.00..71,946.43 rows=793 width=48) (actual rows= loops=)

  • Filter: ((reviewer_id = 8,057) AND (status_cd = 'C'::bpchar))
11. 0.000 0.000 ↓ 0.0

Index Scan using pk_tgq_work on tgq_work "PC0" (cost=0.43..8.33 rows=1 width=88) (actual rows= loops=)

  • Index Cond: ((pzinskey)::text = ("Review".pzinskey)::text)
  • Filter: (((pxobjclass)::text ~~ 'Chartis-FW-GQ-Work%'::text) AND ((pyid)::text ~~ 'R-%'::text) AND ((pystatuswork)::text <> 'In-Progress'::text) AND ((pystatuswork)::text <> 'New'::text) AND (pxupdatedatetime >= '2019-06-24 04:33:57.417'::timestamp without time zone) AND (pxupdatedatetime <= '2020-06-22 04:33:57.417'::timestamp without time zone))
12. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_tqstnr_version on tqstnr_version "QuestionnaireVer" (cost=0.28..0.41 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((questionnaire_id = "Review".questionnaire_id) AND (qstnr_version_no = "Review".qstnr_version_no))
13. 0.000 0.000 ↓ 0.0

Index Scan using pk_tquestionnaire on tquestionnaire "Questionnaire" (cost=0.28..0.35 rows=1 width=33) (actual rows= loops=)

  • Index Cond: (questionnaire_id = "QuestionnaireVer".questionnaire_id)
14. 0.000 0.000 ↓ 0.0

Index Scan using relatedreview on trelated_review "RelatedReview" (cost=0.43..8.09 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (review_id = "Review".review_id)
15. 0.000 0.000 ↓ 0.0

Index Scan using pk_treview_subject on treview_subject "ReviewSubject" (cost=0.43..0.51 rows=1 width=17) (actual rows= loops=)

  • Index Cond: (review_subject_id = "RelatedReview".review_subject_id)
16. 0.000 0.000 ↓ 0.0

Index Scan using pk_treivew_grp on treivew_grp "ReviewGrp" (cost=0.28..0.29 rows=1 width=35) (actual rows= loops=)

  • Index Cond: (review_group_id = "ReviewSubject".review_group_id)
17. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..2.72 rows=48 width=33) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Seq Scan on tqstnr_template_group "QstnrTmpltGrp" (cost=0.00..2.48 rows=48 width=33) (actual rows= loops=)