explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cvOP

Settings
# exclusive inclusive rows x rows loops node
1. 3.321 63.619 ↓ 2.3 122 1

Sort (cost=171.08..171.21 rows=54 width=705) (actual time=62.356..63.619 rows=122 loops=1)

  • Sort Key: t13."Id0", "l.Divisions.DivisionPhones"."Division_Id
  • Sort Method: quicksort Memory: 57kB
2. 4.768 60.298 ↓ 2.3 122 1

Nested Loop (cost=52.15..169.52 rows=54 width=705) (actual time=30.492..60.298 rows=122 loops=1)

  • Join Filter: ("d.Phone"."TypeOfPhoneRefId" = "d.Phone.TypeOfPhoneRef"."Id")
  • Rows Removed by Join Filter: 78
3. 4.195 53.212 ↓ 2.3 122 1

Nested Loop (cost=52.15..167.15 rows=54 width=35) (actual time=30.389..53.212 rows=122 loops=1)

4. 8.477 45.235 ↓ 2.3 122 1

Hash Join (cost=51.86..63.93 rows=54 width=16) (actual time=29.544..45.235 rows=122 loops=1)

  • Hash Cond: ("l.Divisions.DivisionPhones"."Division_Id" = t13."Id")
5. 7.475 7.475 ↑ 1.0 620 1

Seq Scan on "PhoneDivisions" "l.Divisions.DivisionPhones" (cost=0.00..9.20 rows=620 width=8) (actual time=0.029..7.475 rows=620 loops=1)

6. 1.443 29.283 ↓ 2.0 104 1

Hash (cost=51.23..51.23 rows=51 width=8) (actual time=29.275..29.283 rows=104 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
7. 1.961 27.840 ↓ 2.0 104 1

Subquery Scan on t13 (cost=50.21..51.23 rows=51 width=8) (actual time=24.882..27.840 rows=104 loops=1)

8. 2.183 25.879 ↓ 2.0 104 1

HashAggregate (cost=50.21..50.72 rows=51 width=8) (actual time=24.865..25.879 rows=104 loops=1)

  • Group Key: "l.Divisions3"."Id", l4."Id
9. 7.891 23.696 ↓ 2.0 104 1

Hash Join (cost=2.67..49.95 rows=51 width=8) (actual time=8.697..23.696 rows=104 loops=1)

  • Hash Cond: ("l.Divisions3"."LegalEntityId" = l4."Id")
10. 15.111 15.111 ↑ 1.0 731 1

Seq Scan on "Divisions" "l.Divisions3" (cost=0.00..45.31 rows=731 width=18) (actual time=0.018..15.111 rows=731 loops=1)

11. 0.105 0.694 ↑ 1.0 10 1

Hash (cost=2.54..2.54 rows=10 width=4) (actual time=0.686..0.694 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
12. 0.288 0.589 ↑ 1.0 10 1

Unique (cost=0.28..2.44 rows=10 width=4) (actual time=0.059..0.589 rows=10 loops=1)

13. 0.173 0.301 ↑ 1.0 10 1

Limit (cost=0.28..2.32 rows=10 width=4) (actual time=0.042..0.301 rows=10 loops=1)

14. 0.128 0.128 ↑ 78.0 10 1

Index Scan using "PK_dbo.LegalEntities" on "LegalEntities" l4 (cost=0.28..159.63 rows=780 width=4) (actual time=0.024..0.128 rows=10 loops=1)

15. 3.782 3.782 ↑ 1.0 1 122

Index Scan using "PK_dbo.Phones" on "Phones" "d.Phone" (cost=0.29..1.91 rows=1 width=19) (actual time=0.031..0.031 rows=1 loops=122)

  • Index Cond: ("Id" = "l.Divisions.DivisionPhones"."Phone_Id")
16. 2.282 2.318 ↑ 1.0 2 122

Materialize (cost=0.00..1.03 rows=2 width=670) (actual time=0.013..0.019 rows=2 loops=122)

17. 0.036 0.036 ↑ 1.0 2 1

Seq Scan on "TypeOfPhoneRefs" "d.Phone.TypeOfPhoneRef" (cost=0.00..1.02 rows=2 width=670) (actual time=0.019..0.036 rows=2 loops=1)

Planning time : 7.592 ms
Execution time : 66.162 ms