explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CvfW

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.026 0.958 ↓ 2.7 94 1

Nested Loop (cost=8.23..170.99 rows=35 width=125) (actual time=0.602..0.958 rows=94 loops=1)

2. 0.344 0.644 ↑ 1.1 16 1

Hash Join (cost=7.94..120.91 rows=18 width=8) (actual time=0.594..0.644 rows=16 loops=1)

  • Hash Cond: (tb.idcomponent = comp.id)
3. 0.268 0.268 ↓ 1.0 4,719 1

Seq Scan on textblock tb (cost=0.00..95.12 rows=4,712 width=16) (actual time=0.010..0.268 rows=4,719 loops=1)

4. 0.001 0.032 ↑ 1.0 1 1

Hash (cost=7.93..7.93 rows=1 width=8) (actual time=0.032..0.032 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
5. 0.031 0.031 ↑ 1.0 1 1

Seq Scan on component comp (cost=0.00..7.93 rows=1 width=8) (actual time=0.028..0.031 rows=1 loops=1)

  • Filter: (((name)::text = 'M04'::text) AND ((version)::text = '2'::text))
  • Rows Removed by Filter: 261
6. 0.288 0.288 ↓ 2.0 6 16

Index Scan using ttb_to_tb_idx on translatedtextblock ttb (cost=0.29..2.75 rows=3 width=125) (actual time=0.003..0.018 rows=6 loops=16)

  • Index Cond: (idtextblock = tb.id)
  • Filter: ((locale)::text = 'de'::text)
  • Rows Removed by Filter: 64