explain.depesz.com

PostgreSQL's explain analyze made readable

Result: o5CW

Settings
# exclusive inclusive rows x rows loops node
1. 26.301 840.320 ↑ 1.2 620 1

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

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

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

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

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

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

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

5. 8.367 129.391 ↑ 1.2 620 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 38kB
6. 17.511 121.024 ↑ 1.2 620 1

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

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

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

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

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

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

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

10. 7.972 44.534 ↑ 1.0 780 1

Hash (cost=57.35..57.35 rows=780 width=4) (actual time=44.525..44.534 rows=780 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 36kB
11. 16.894 36.562 ↑ 1.0 780 1

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

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

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

13. 6.309 12.249 ↑ 1.0 620 1

Hash (cost=9.20..9.20 rows=620 width=8) (actual time=12.241..12.249 rows=620 loops=1)

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

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

15. 0.043 0.086 ↑ 1.0 2 1

Hash (cost=1.02..1.02 rows=2 width=670) (actual time=0.076..0.086 rows=2 loops=1)

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

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

Planning time : 1.136 ms
Execution time : 848.198 ms