explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JdiUM

Settings
# exclusive inclusive rows x rows loops node
1. 212.114 1,674.360 ↑ 1.0 224,068 1

Hash Join (cost=273,934.01..294,104.82 rows=224,069 width=15) (actual time=1,422.088..1,674.360 rows=224,068 loops=1)

  • Hash Cond: (t_vetrino.id_caso = t_caso.id_caso)
2. 41.145 41.145 ↑ 1.0 224,069 1

Seq Scan on t_vetrino (cost=0.00..6,433.69 rows=224,069 width=7) (actual time=0.004..41.145 rows=224,069 loops=1)

3. 378.938 1,421.101 ↑ 1.0 1,708,440 1

Hash (cost=244,230.56..244,230.56 rows=1,708,756 width=16) (actual time=1,421.101..1,421.101 rows=1,708,440 loops=1)

  • Buckets: 262144 Batches: 2 Memory Usage: 41783kB
4. 1,042.163 1,042.163 ↑ 1.0 1,708,440 1

Seq Scan on t_caso (cost=0.00..244,230.56 rows=1,708,756 width=16) (actual time=0.003..1,042.163 rows=1,708,440 loops=1)

Total runtime : 1,685.401 ms