explain.depesz.com

PostgreSQL's explain analyze made readable

Result: u3b2

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

Sort (cost=42,920.36..43,293.35 rows=149,194 width=250) (never executed)

  • Sort Key: ((to_char((CASE WHEN ((demo.bday IS NOT NULL) AND (demo.corrected_bday IS NOT NULL)) THEN demo.corrected_bday WHEN (demo.corrected_bday IS NULL) THEN demo.bday ELSE demo.bday END + (((vac.age_in_days)::text || ' day'::text))::interval), 'YYYY-MM-DD'::text))::date), vac.age_in_days, demo.mr_number
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=854.19..12,249.5 rows=149,194 width=250) (never executed)

3. 0.000 0.000 ↓ 0.0

Hash Join (cost=678.09..1,240.17 rows=3,459 width=144) (never executed)

4. 0.000 0.000 ↓ 0.0

Hash Join (cost=489.18..990.73 rows=3,459 width=161) (never executed)

5. 0.000 0.000 ↓ 0.0

Hash Join (cost=328.58..769.52 rows=3,470 width=120) (never executed)

6. 0.000 0.000 ↓ 0.0

Hash Join (cost=175.28..559.3 rows=3,557 width=120) (never executed)

7. 0.000 0.000 ↓ 0.0

Seq Scan on indivo_demographics demo (cost=0..309.68 rows=6,203 width=39) (never executed)

  • Filter: ((demo.father_tel_number)::text <> ALL ('{9790129564,9886761862,9740244440,9843529415,8870121072,8904800205,9894428352,9789323940,9791148389,9444211844,9182604797}'::text[]))
8. 0.000 0.000 ↓ 0.0

Hash (cost=130.68..130.68 rows=3,568 width=89) (never executed)

9. 0.000 0.000 ↓ 0.0

Seq Scan on indivo_record ir (cost=0..130.68 rows=3,568 width=89) (never executed)

10. 0.000 0.000 ↓ 0.0

Hash (cost=109.8..109.8 rows=3,480 width=74) (never executed)

11. 0.000 0.000 ↓ 0.0

Seq Scan on indivo_accountfullshare ia (cost=0..109.8 rows=3,480 width=74) (never executed)

12. 0.000 0.000 ↓ 0.0

Hash (cost=111.88..111.88 rows=3,898 width=41) (never executed)

13. 0.000 0.000 ↓ 0.0

Seq Scan on indivo_account iac (cost=0..111.88 rows=3,898 width=41) (never executed)

  • Filter: (iac.account_type = 2)
14. 0.000 0.000 ↓ 0.0

Hash (cost=140.07..140.07 rows=3,907 width=57) (never executed)

15. 0.000 0.000 ↓ 0.0

Seq Scan on indivo_principal ip (cost=0..140.07 rows=3,907 width=57) (never executed)

16. 0.000 0.000 ↓ 0.0

Hash (cost=172.63..172.63 rows=278 width=185) (never executed)

17. 0.000 0.000 ↓ 0.0

Hash Join (cost=150.97..172.63 rows=278 width=185) (never executed)

18. 0.000 0.000 ↓ 0.0

Seq Scan on vaccination_vaccination vac (cost=0..16.79 rows=278 width=138) (never executed)

  • Filter: vac.active
19. 0.000 0.000 ↓ 0.0

Hash (cost=102.1..102.1 rows=3,910 width=47) (never executed)

20. 0.000 0.000 ↓ 0.0

Seq Scan on indivo_account account (cost=0..102.1 rows=3,910 width=47) (never executed)