explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Y7mN

Settings
# exclusive inclusive rows x rows loops node
1. 0.674 11.515 ↓ 2.8 94 1

Hash Join (cost=121.14..3,309.53 rows=34 width=125) (actual time=1.435..11.515 rows=94 loops=1)

  • Hash Cond: (ttb.idtextblock = tb.id)
2. 10.197 10.197 ↑ 1.0 8,926 1

Seq Scan on translatedtextblock ttb (cost=0.00..3,154.45 rows=8,962 width=125) (actual time=0.017..10.197 rows=8,926 loops=1)

  • Filter: ((locale)::text = 'de'::text)
  • Rows Removed by Filter: 76696
3. 0.003 0.644 ↑ 1.1 16 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
4. 0.323 0.641 ↑ 1.1 16 1

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

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

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

6. 0.001 0.030 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.029 0.029 ↑ 1.0 1 1

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

  • Filter: (((name)::text = 'M04'::text) AND ((version)::text = '2'::text))
  • Rows Removed by Filter: 261