explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aw5E

Settings
# exclusive inclusive rows x rows loops node
1. 107.173 497.473 ↑ 4.4 5,408 1

Sort (cost=14,786.33..14,845.58 rows=23,701 width=1,405) (actual time=490.017..497.473 rows=5,408 loops=1)

  • Sort Key: r."Id", a."Id", d."Id", r0."Id", r1."Id", s."Id", o."Id
  • Sort Method: external merge Disk: 2864kB
2. 1.597 390.300 ↑ 4.4 5,408 1

Hash Left Join (cost=1,454.81..4,568.94 rows=23,701 width=1,405) (actual time=383.794..390.300 rows=5,408 loops=1)

  • Hash Cond: (r."Id" = o."RegulatoryDataId")
3. 1.969 363.529 ↑ 2.6 5,408 1

Hash Left Join (cost=1,392.75..4,165.12 rows=13,966 width=1,161) (actual time=358.600..363.529 rows=5,408 loops=1)

  • Hash Cond: (r."Id" = a."RegulatoryDataId")
4. 2.013 356.344 ↑ 1.3 5,408 1

Hash Left Join (cost=874.65..3,396.85 rows=6,959 width=1,116) (actual time=353.295..356.344 rows=5,408 loops=1)

  • Hash Cond: (r."Id" = r1."RegulatoryDataId")
5. 0.712 50.490 ↓ 1.1 2,704 1

Nested Loop Left Join (cost=1.41..2,289.35 rows=2,482 width=1,024) (actual time=49.271..50.490 rows=2,704 loops=1)

6. 0.039 33.502 ↓ 1.1 52 1

Nested Loop Left Join (cost=0.98..56.39 rows=49 width=1,002) (actual time=33.455..33.502 rows=52 loops=1)

7. 0.030 14.817 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.56..5.02 rows=1 width=983) (actual time=14.815..14.817 rows=1 loops=1)

8. 0.003 0.025 ↑ 1.0 1 1

Limit (cost=0.28..2.50 rows=1 width=945) (actual time=0.024..0.025 rows=1 loops=1)

9. 0.022 0.022 ↑ 1.0 1 1

Index Scan using "PK_RegulatoryData" on "RegulatoryData" r (cost=0.28..2.50 rows=1 width=945) (actual time=0.022..0.022 rows=1 loops=1)

  • Index Cond: ("Id" = 12455)
10. 14.762 14.762 ↑ 1.0 1 1

Index Scan using "IX_Registrations_RegulatoryDataId" on "Registrations" r0 (cost=0.28..2.50 rows=1 width=38) (actual time=14.761..14.762 rows=1 loops=1)

  • Index Cond: (r."Id" = "RegulatoryDataId")
11. 18.646 18.646 ↓ 1.1 52 1

Index Scan using "IX_StateRestrictions_RegulatoryDataId" on "StateRestrictions" s (cost=0.42..50.89 rows=49 width=19) (actual time=18.635..18.646 rows=52 loops=1)

  • Index Cond: (r."Id" = "RegulatoryDataId")
12. 16.276 16.276 ↓ 1.1 52 52

Index Scan using "IX_DistributionAvailabilities_RegulatoryDataId" on "DistributionAvailabilities" d (cost=0.42..45.09 rows=48 width=22) (actual time=0.307..0.313 rows=52 loops=52)

  • Index Cond: (r."Id" = "RegulatoryDataId")
13. 9.866 303.841 ↑ 1.0 21,344 1

Hash (cost=606.44..606.44 rows=21,344 width=92) (actual time=303.841..303.841 rows=21,344 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 2810kB
14. 293.975 293.975 ↑ 1.0 21,344 1

Seq Scan on "RegulatoryLabels" r1 (cost=0.00..606.44 rows=21,344 width=92) (actual time=8.211..293.975 rows=21,344 loops=1)

15. 2.805 5.216 ↑ 1.0 14,049 1

Hash (cost=342.49..342.49 rows=14,049 width=45) (actual time=5.216..5.216 rows=14,049 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 1177kB
16. 2.411 2.411 ↑ 1.0 14,049 1

Seq Scan on "ActiveIngredients" a (cost=0.00..342.49 rows=14,049 width=45) (actual time=0.013..2.411 rows=14,049 loops=1)

17. 0.713 25.174 ↑ 1.0 1,025 1

Hash (cost=49.25..49.25 rows=1,025 width=244) (actual time=25.174..25.174 rows=1,025 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 207kB
18. 24.461 24.461 ↑ 1.0 1,025 1

Seq Scan on "OrganicSources" o (cost=0.00..49.25 rows=1,025 width=244) (actual time=10.249..24.461 rows=1,025 loops=1)

Planning time : 195.292 ms
Execution time : 500.183 ms