explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tVzn

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

Limit (cost=62.91..96.35 rows=5 width=1,209) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=49.53..116.41 rows=10 width=1,209) (actual rows= loops=)

  • -> Index Scan using lead_source_pkey on lead_source "x.LeadSource" (cost=0.15..3.77 rows=1 width=36)" Index Cond: (id = x.lead_source_id)
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=49.38..78.68 rows=10 width=1,178) (actual rows= loops=)

  • Hash Cond: (x.sales_consultant_id = "x.SalesConsultant".id)
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=30.83..60.11 rows=10 width=1,050) (actual rows= loops=)

  • Hash Cond: ("x.LeadType".id = x.lead_type_id)
5. 0.000 0.000 ↓ 0.0

Seq Scan on lead_type "x.LeadType" (cost=0.00..21.80 rows=1,180 width=36) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=30.71..30.71 rows=10 width=1,018) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash Join (cost=14.56..30.71 rows=10 width=1,018) (actual rows= loops=)

  • Hash Cond: ("x.Address".id = x.address_id)
8. 0.000 0.000 ↓ 0.0

Seq Scan on address "x.Address" (cost=0.00..14.40 rows=440 width=156) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Hash (cost=14.43..14.43 rows=10 width=866) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Hash Join (cost=2.82..14.43 rows=10 width=866) (actual rows= loops=)

  • Hash Cond: ("x.ContactPerson".id = x.contact_person_id)
11. 0.000 0.000 ↓ 0.0

Seq Scan on contact_person "x.ContactPerson" (cost=0.00..11.10 rows=110 width=692) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Hash (cost=2.69..2.69 rows=10 width=178) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=1.23..2.69 rows=10 width=178) (actual rows= loops=)

  • Hash Cond: ("x.Appointment".id = x.appointment_id)
14. 0.000 0.000 ↓ 0.0

Seq Scan on appointment "x.Appointment" (cost=0.00..1.29 rows=29 width=90) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Hash (cost=1.10..1.10 rows=10 width=92) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Seq Scan on lead x (cost=0.00..1.10 rows=10 width=92) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Hash (cost=13.80..13.80 rows=380 width=144) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Seq Scan on user_account "x.SalesConsultant" (cost=0.00..13.80 rows=380 width=144) (actual rows= loops=)