explain.depesz.com

PostgreSQL's explain analyze made readable

Result: StKo

Settings
# exclusive inclusive rows x rows loops node
1. 17.425 937.507 ↑ 1.2 620 1

Sort (cost=768.11..770.04 rows=772 width=705) (actual time=931.579..937.507 rows=620 loops=1)

  • Sort Key: l4."Id", "l.Divisions.DivisionPhones"."Division_Id
  • Sort Method: quicksort Memory: 189kB
2. 19.453 920.082 ↑ 1.2 620 1

Hash Join (cost=171.64..731.08 rows=772 width=705) (actual time=193.114..920.082 rows=620 loops=1)

  • Hash Cond: ("d.Phone"."TypeOfPhoneRefId" = "d.Phone.TypeOfPhoneRef"."Id")
3. 365.551 900.522 ↑ 1.2 620 1

Hash Join (cost=170.59..723.72 rows=772 width=35) (actual time=191.943..900.522 rows=620 loops=1)

  • Hash Cond: ("d.Phone"."Id" = "l.Divisions.DivisionPhones"."Phone_Id")
4. 343.446 343.446 ↑ 1.0 27,084 1

Seq Scan on "Phones" "d.Phone" (cost=0.00..443.84 rows=27,084 width=19) (actual time=0.017..343.446 rows=27,084 loops=1)

5. 11.264 191.525 ↑ 1.2 620 1

Hash (cost=160.94..160.94 rows=772 width=16) (actual time=191.517..191.525 rows=620 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 38kB
6. 24.186 180.261 ↑ 1.2 620 1

Hash Join (cost=134.94..160.94 rows=772 width=16) (actual time=142.863..180.261 rows=620 loops=1)

  • Hash Cond: ("l.Divisions3"."Id" = "l.Divisions.DivisionPhones"."Division_Id")
7. 27.866 139.239 ↑ 1.0 731 1

HashAggregate (cost=118.00..125.31 rows=731 width=8) (actual time=125.975..139.239 rows=731 loops=1)

  • Group Key: "l.Divisions3"."Id", l4."Id
8. 29.974 111.373 ↑ 1.0 731 1

Hash Join (cost=67.10..114.34 rows=731 width=8) (actual time=66.721..111.373 rows=731 loops=1)

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

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

10. 12.530 66.590 ↑ 1.0 780 1

Hash (cost=57.35..57.35 rows=780 width=4) (actual time=66.582..66.590 rows=780 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 36kB
11. 32.133 54.060 ↑ 1.0 780 1

HashAggregate (cost=41.75..49.55 rows=780 width=4) (actual time=37.692..54.060 rows=780 loops=1)

  • Group Key: l4."Id
12. 21.927 21.927 ↑ 1.0 780 1

Seq Scan on "LegalEntities" l4 (cost=0.00..39.80 rows=780 width=4) (actual time=0.021..21.927 rows=780 loops=1)

13. 8.613 16.836 ↑ 1.0 620 1

Hash (cost=9.20..9.20 rows=620 width=8) (actual time=16.827..16.836 rows=620 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 33kB
14. 8.223 8.223 ↑ 1.0 620 1

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

15. 0.050 0.107 ↑ 1.0 2 1

Hash (cost=1.02..1.02 rows=2 width=670) (actual time=0.100..0.107 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
16. 0.057 0.057 ↑ 1.0 2 1

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

Planning time : 51.457 ms
Execution time : 952.633 ms