explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HrkC4

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.005 1.008 ↑ 1.0 1 1

Unique (cost=42.84..42.86 rows=1 width=69) (actual time=1.004..1.008 rows=1 loops=1)

2. 0.027 1.003 ↓ 3.0 3 1

Sort (cost=42.84..42.85 rows=1 width=69) (actual time=1.003..1.003 rows=3 loops=1)

  • Sort Key: i0."Tag", i0."RefId", n0."RefId", s."StatusId", d."Name
  • Sort Method: quicksort Memory: 25kB
3. 0.009 0.976 ↓ 3.0 3 1

Nested Loop (cost=11.32..42.83 rows=1 width=69) (actual time=0.893..0.976 rows=3 loops=1)

  • Join Filter: (s."TenantId" = d."TenantId")
4. 0.070 0.934 ↑ 1.0 3 1

Hash Join (cost=11.05..41.92 rows=3 width=75) (actual time=0.867..0.934 rows=3 loops=1)

  • Hash Cond: ((s."TenantId" = l0."TenantId") AND (l."LanguageId" = l0."Id"))
5. 0.011 0.809 ↑ 2.6 24 1

Nested Loop (cost=9.70..40.24 rows=62 width=75) (actual time=0.748..0.809 rows=24 loops=1)

6. 0.030 0.738 ↑ 1.0 3 1

Hash Join (cost=9.27..10.59 rows=3 width=59) (actual time=0.725..0.738 rows=3 loops=1)

  • Hash Cond: ((s."StatusName")::text = (i1."Name")::text)
7. 0.045 0.045 ↑ 1.0 21 1

Seq Scan on "Statuses" s (cost=0.00..1.21 rows=21 width=36) (actual time=0.041..0.045 rows=21 loops=1)

8. 0.006 0.663 ↑ 1.0 1 1

Hash (cost=9.26..9.26 rows=1 width=44) (actual time=0.663..0.663 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
9. 0.004 0.657 ↑ 1.0 1 1

Nested Loop (cost=7.16..9.26 rows=1 width=44) (actual time=0.652..0.657 rows=1 loops=1)

  • Join Filter: (n."Id" = n1."NodeId")
10. 0.052 0.631 ↑ 1.0 1 1

Hash Join (cost=7.02..8.36 rows=1 width=60) (actual time=0.627..0.631 rows=1 loops=1)

  • Hash Cond: (i1."Id" = i0."StatusId")
11. 0.027 0.027 ↑ 1.0 24 1

Seq Scan on "InstrumentationStatus" i1 (cost=0.00..1.24 rows=24 width=17) (actual time=0.023..0.027 rows=24 loops=1)

12. 0.022 0.552 ↑ 1.0 1 1

Hash (cost=7.00..7.00 rows=1 width=59) (actual time=0.552..0.552 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
13. 0.010 0.530 ↑ 1.0 1 1

Nested Loop (cost=4.94..7.00 rows=1 width=59) (actual time=0.496..0.530 rows=1 loops=1)

14. 0.186 0.406 ↓ 6.0 6 1

Hash Join (cost=4.80..6.11 rows=1 width=40) (actual time=0.396..0.406 rows=6 loops=1)

  • Hash Cond: (i."NodeId" = n."Id")
15. 0.025 0.025 ↑ 1.0 22 1

Seq Scan on "InstrumentationNode" i (cost=0.00..1.22 rows=22 width=16) (actual time=0.021..0.025 rows=22 loops=1)

16. 0.005 0.195 ↓ 3.0 6 1

Hash (cost=4.78..4.78 rows=2 width=24) (actual time=0.195..0.195 rows=6 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
17. 0.080 0.190 ↓ 3.0 6 1

Hash Join (cost=1.36..4.78 rows=2 width=24) (actual time=0.157..0.190 rows=6 loops=1)

  • Hash Cond: (n."NodeTypeId" = n0."Id")
18. 0.065 0.065 ↓ 1.7 24 1

Seq Scan on "Node" n (cost=0.00..3.37 rows=14 width=24) (actual time=0.037..0.065 rows=24 loops=1)

  • Filter: (("TenantId" = 2) AND ("ProjectId" = 2))
  • Rows Removed by Filter: 67
19. 0.012 0.045 ↑ 1.0 3 1

Hash (cost=1.32..1.32 rows=3 width=16) (actual time=0.045..0.045 rows=3 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
20. 0.033 0.033 ↑ 1.0 3 1

Seq Scan on "NodeType" n0 (cost=0.00..1.32 rows=3 width=16) (actual time=0.026..0.033 rows=3 loops=1)

  • Filter: ("IsArea" = 1)
  • Rows Removed by Filter: 23
21. 0.114 0.114 ↓ 0.0 0 6

Index Scan using "Instrumentation_View_IDX" on "Instrumentation" i0 (cost=0.14..0.70 rows=1 width=35) (actual time=0.019..0.019 rows=0 loops=6)

  • Index Cond: ("Id" = i."InstrumentationId")
  • Filter: ("ParentId" = 0)
  • Rows Removed by Filter: 1
22. 0.022 0.022 ↑ 1.0 1 1

Index Only Scan using "NodeSpecification_IX_NodeId" on "NodeSpecification" n1 (cost=0.14..0.89 rows=1 width=8) (actual time=0.021..0.022 rows=1 loops=1)

  • Index Cond: ("NodeId" = i."NodeId")
  • Heap Fetches: 1
23. 0.060 0.060 ↑ 2.6 8 3

Index Scan using "LanguageDescription_View_Idx" on "LanguageDescription" l (cost=0.43..9.67 rows=21 width=32) (actual time=0.015..0.020 rows=8 loops=3)

  • Index Cond: ("CommonId" = s."LanguageDescriptionId")
  • Filter: (s."TenantId" = "TenantId")
24. 0.008 0.055 ↑ 1.0 3 1

Hash (cost=1.30..1.30 rows=3 width=16) (actual time=0.055..0.055 rows=3 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
25. 0.047 0.047 ↑ 1.0 3 1

Seq Scan on "Language" l0 (cost=0.00..1.30 rows=3 width=16) (actual time=0.040..0.047 rows=3 loops=1)

  • Filter: ("LocalId" = 1,031)
  • Rows Removed by Filter: 21
26. 0.033 0.033 ↑ 1.0 1 3

Index Scan using "PK_public.Description" on "Description" d (cost=0.27..0.29 rows=1 width=38) (actual time=0.011..0.011 rows=1 loops=3)

  • Index Cond: ("Id" = l."DescriptionId")
  • Filter: (l."TenantId" = "TenantId")