explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BvFq : Optimization for: Optimization for: plan #DOdM; plan #KAL0

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.050 78,861.441 ↑ 1.0 1 1

Unique (cost=72,907.39..72,907.41 rows=1 width=176) (actual time=78,861.393..78,861.441 rows=1 loops=1)

2. 0.041 78,861.391 ↓ 3.0 3 1

Sort (cost=72,907.39..72,907.40 rows=1 width=176) (actual time=78,861.390..78,861.391 rows=3 loops=1)

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

Nested Loop (cost=0.57..72,907.38 rows=1 width=176) (actual time=64,744.340..78,861.350 rows=3 loops=1)

  • Join Filter: ((s."TenantId" = d."TenantId") AND (l."DescriptionId" = d."Id"))
  • Rows Removed by Join Filter: 385
4. 0.027 78,861.075 ↓ 3.0 3 1

Nested Loop (cost=0.57..72,894.13 rows=1 width=182) (actual time=64,744.307..78,861.075 rows=3 loops=1)

  • Join Filter: ((s."TenantId" = l0."TenantId") AND (l."LanguageId" = l0."Id"))
  • Rows Removed by Join Filter: 66
5. 0.332 78,861.000 ↓ 8.0 24 1

Nested Loop (cost=0.57..72,892.78 rows=3 width=182) (actual time=64,744.223..78,861.000 rows=24 loops=1)

  • Join Filter: (n."Id" = n1."NodeId")
  • Rows Removed by Join Filter: 2,352
6. 0.036 78,860.452 ↓ 8.0 24 1

Nested Loop (cost=0.57..72,885.08 rows=3 width=198) (actual time=64,744.155..78,860.452 rows=24 loops=1)

  • Join Filter: (n."NodeTypeId" = n0."Id")
  • Rows Removed by Join Filter: 48
7. 0.873 78,860.344 ↓ 8.0 24 1

Nested Loop (cost=0.57..72,883.71 rows=3 width=198) (actual time=64,744.076..78,860.344 rows=24 loops=1)

  • Join Filter: (i."NodeId" = n."Id")
  • Rows Removed by Join Filter: 2,904
8. 0.562 78,859.183 ↓ 48.0 144 1

Nested Loop (cost=0.57..72,879.68 rows=3 width=174) (actual time=1.237..78,859.183 rows=144 loops=1)

  • Join Filter: (i0."Id" = i."InstrumentationId")
  • Rows Removed by Join Filter: 2,496
9. 0.137 78,858.381 ↓ 40.0 120 1

Nested Loop (cost=0.57..72,877.42 rows=3 width=174) (actual time=1.139..78,858.381 rows=120 loops=1)

10. 0.124 0.439 ↓ 15.0 15 1

Nested Loop (cost=0.14..15.52 rows=1 width=158) (actual time=0.143..0.439 rows=15 loops=1)

  • Join Filter: ((i1."Name")::text = (s."StatusName")::text)
  • Rows Removed by Join Filter: 90
11. 0.103 0.255 ↓ 5.0 5 1

Nested Loop (cost=0.14..14.04 rows=1 width=252) (actual time=0.121..0.255 rows=5 loops=1)

  • Join Filter: (i0."StatusId" = i1."Id")
  • Rows Removed by Join Filter: 53
12. 0.102 0.102 ↓ 5.0 5 1

Index Scan using "Instrumentation_View_IDX" on "Instrumentation" i0 (cost=0.14..12.50 rows=1 width=142) (actual time=0.084..0.102 rows=5 loops=1)

  • Filter: ("ParentId" = 0)
  • Rows Removed by Filter: 16
13. 0.050 0.050 ↑ 2.0 12 5

Seq Scan on "InstrumentationStatus" i1 (cost=0.00..1.24 rows=24 width=126) (actual time=0.009..0.010 rows=12 loops=5)

14. 0.060 0.060 ↑ 1.0 21 5

Seq Scan on "Statuses" s (cost=0.00..1.21 rows=21 width=242) (actual time=0.005..0.012 rows=21 loops=5)

15. 78,857.805 78,857.805 ↑ 2.6 8 15

Index Scan using "LanguageDescription_IX_TenantId" on "LanguageDescription" l (cost=0.43..72,861.69 rows=21 width=32) (actual time=0.477..5,257.187 rows=8 loops=15)

  • Index Cond: ("TenantId" = s."TenantId")
  • Filter: (s."LanguageDescriptionId" = "CommonId")
  • Rows Removed by Filter: 2,767,093
16. 0.156 0.240 ↑ 1.0 22 120

Materialize (cost=0.00..1.33 rows=22 width=16) (actual time=0.001..0.002 rows=22 loops=120)

17. 0.084 0.084 ↑ 1.0 22 1

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

18. 0.164 0.288 ↓ 1.4 20 144

Materialize (cost=0.00..3.44 rows=14 width=24) (actual time=0.000..0.002 rows=20 loops=144)

19. 0.124 0.124 ↓ 1.7 24 1

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

  • Filter: (("TenantId" = 2) AND ("ProjectId" = 2))
  • Rows Removed by Filter: 67
20. 0.007 0.072 ↓ 3.0 3 24

Materialize (cost=0.00..1.33 rows=1 width=16) (actual time=0.003..0.003 rows=3 loops=24)

21. 0.065 0.065 ↓ 3.0 3 1

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

  • Filter: ("IsArea" = 1)
  • Rows Removed by Filter: 17
22. 0.155 0.216 ↑ 1.0 99 24

Materialize (cost=0.00..3.49 rows=99 width=8) (actual time=0.002..0.009 rows=99 loops=24)

23. 0.061 0.061 ↑ 1.0 99 1

Seq Scan on "NodeSpecification" n1 (cost=0.00..2.99 rows=99 width=8) (actual time=0.034..0.061 rows=99 loops=1)

24. 0.011 0.048 ↓ 3.0 3 24

Materialize (cost=0.00..1.30 rows=1 width=16) (actual time=0.002..0.002 rows=3 loops=24)

25. 0.037 0.037 ↓ 3.0 3 1

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

  • Filter: ("LocalId" = 1,031)
  • Rows Removed by Filter: 21
26. 0.159 0.159 ↑ 2.9 129 3

Seq Scan on "Description" d (cost=0.00..7.70 rows=370 width=38) (actual time=0.022..0.053 rows=129 loops=3)