explain.depesz.com

PostgreSQL's explain analyze made readable

Result: m9vd : Optimization for: Optimization for: Optimization for: Optimization for: plan #HrkC4; plan #rBd2; plan #InBG; plan #pXHR

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.006 1.246 ↑ 7.9 7 1

Unique (cost=233.58..233.99 rows=55 width=30) (actual time=1.240..1.246 rows=7 loops=1)

2. 0.092 1.240 ↑ 7.9 7 1

Sort (cost=233.58..233.72 rows=55 width=30) (actual time=1.239..1.240 rows=7 loops=1)

  • Sort Key: s."StatusId", d."Name
  • Sort Method: quicksort Memory: 25kB
3. 0.038 1.148 ↑ 7.9 7 1

Hash Join (cost=14.13..231.99 rows=55 width=30) (actual time=0.652..1.148 rows=7 loops=1)

  • Hash Cond: (l."DescriptionId" = d."Id")
4. 0.143 0.696 ↑ 7.9 7 1

Hash Join (cost=1.80..219.52 rows=55 width=16) (actual time=0.207..0.696 rows=7 loops=1)

  • Hash Cond: (l."LanguageId" = l0."Id")
5. 0.089 0.517 ↑ 7.8 168 1

Nested Loop (cost=0.43..214.10 rows=1,309 width=24) (actual time=0.071..0.517 rows=168 loops=1)

6. 0.050 0.050 ↑ 1.0 21 1

Seq Scan on "Statuses" s (cost=0.00..1.21 rows=21 width=16) (actual time=0.042..0.050 rows=21 loops=1)

7. 0.378 0.378 ↑ 7.8 8 21

Index Scan using "LanguageDescription_IX_CommonId" on "LanguageDescription" l (cost=0.43..9.52 rows=62 width=24) (actual time=0.012..0.018 rows=8 loops=21)

  • Index Cond: ("CommonId" = s."LanguageDescriptionId")
8. 0.004 0.036 ↑ 1.0 1 1

Hash (cost=1.36..1.36 rows=1 width=8) (actual time=0.036..0.036 rows=1 loops=1)

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

Seq Scan on "Language" l0 (cost=0.00..1.36 rows=1 width=8) (actual time=0.026..0.032 rows=1 loops=1)

  • Filter: (("LocalId" = 1,031) AND ("TenantId" = 2))
  • Rows Removed by Filter: 23
10. 0.184 0.414 ↑ 1.0 370 1

Hash (cost=7.70..7.70 rows=370 width=30) (actual time=0.414..0.414 rows=370 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 32kB
11. 0.230 0.230 ↑ 1.0 370 1

Seq Scan on "Description" d (cost=0.00..7.70 rows=370 width=30) (actual time=0.028..0.230 rows=370 loops=1)