explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uuOb

Settings
# exclusive inclusive rows x rows loops node
1. 10,756.786 14,494.028 ↑ 1.0 1,717,106 1

Sort (cost=1,059,944.25..1,064,277.11 rows=1,733,142 width=1,023) (actual time=13,579.893..14,494.028 rows=1,717,106 loops=1)

  • Sort Key: this_.isn_exame_solic, examepepbe1_.dsc_exame
  • Sort Method: external merge Disk: 388,736kB
2. 1,183.983 3,737.242 ↑ 1.0 1,717,106 1

Hash Join (cost=71.45..104,324.27 rows=1,733,142 width=1,023) (actual time=1.071..3,737.242 rows=1,717,106 loops=1)

  • Hash Cond: (this_.isn_exame_situacao = examesitua2_.isn_exame_situacao)
3. 1,947.751 2,553.251 ↑ 1.0 1,717,106 1

Hash Join (cost=70.33..80,492.46 rows=1,733,142 width=1,007) (actual time=1.057..2,553.251 rows=1,717,106 loops=1)

  • Hash Cond: (this_.isn_exame = examepepbe1_.isn_exame)
4. 604.477 604.477 ↑ 1.0 1,717,106 1

Seq Scan on t_exame_solic this_ (cost=0.00..56,591.42 rows=1,733,142 width=941) (actual time=0.022..604.477 rows=1,717,106 loops=1)

5. 0.461 1.023 ↓ 1.0 1,139 1

Hash (cost=56.26..56.26 rows=1,126 width=66) (actual time=1.023..1.023 rows=1,139 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 100kB
6. 0.562 0.562 ↓ 1.0 1,139 1

Seq Scan on t_exame examepepbe1_ (cost=0.00..56.26 rows=1,126 width=66) (actual time=0.008..0.562 rows=1,139 loops=1)

7. 0.005 0.008 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=16) (actual time=0.008..0.008 rows=5 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 1kB
8. 0.003 0.003 ↑ 1.0 5 1

Seq Scan on t_exame_situacao examesitua2_ (cost=0.00..1.05 rows=5 width=16) (actual time=0.003..0.003 rows=5 loops=1)

Total runtime : 14,809.095 ms