explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hlmz

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 0.389 ↓ 2.7 94 1

Nested Loop (cost=0.57..73.87 rows=35 width=125) (actual time=0.054..0.389 rows=94 loops=1)

2. 0.003 0.055 ↑ 1.1 16 1

Nested Loop (cost=0.28..23.84 rows=18 width=8) (actual time=0.048..0.055 rows=16 loops=1)

3. 0.034 0.034 ↑ 1.0 1 1

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

  • Filter: (((name)::text = 'M04'::text) AND ((version)::text = '2'::text))
  • Rows Removed by Filter: 261
4. 0.018 0.018 ↑ 1.2 16 1

Index Scan using tb_to_component_idx on textblock tb (cost=0.28..15.72 rows=19 width=16) (actual time=0.016..0.018 rows=16 loops=1)

  • Index Cond: (idcomponent = comp.id)
5. 0.320 0.320 ↓ 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.002..0.020 rows=6 loops=16)

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