explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SkJcu

Settings
# exclusive inclusive rows x rows loops node
1. 0.681 11.698 ↓ 2.8 94 1

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

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

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

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
4. 0.501 0.876 ↑ 1.1 16 1

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

  • Hash Cond: (tb.idcomponent = comp.id)
5. 0.325 0.325 ↓ 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.325 rows=4,719 loops=1)

6. 0.002 0.050 ↑ 1.0 1 1

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

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

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

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