explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pPXK

Settings
# exclusive inclusive rows x rows loops node
1. 216.566 1,704.531 ↑ 1.0 224,068 1

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

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

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

3. 383.417 1,447.211 ↑ 1.0 1,708,440 1

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

  • Buckets: 262144 Batches: 2 Memory Usage: 41783kB
4. 1,063.794 1,063.794 ↑ 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,063.794 rows=1,708,440 loops=1)

Total runtime : 1,715.654 ms