explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4oCR

Settings
# exclusive inclusive rows x rows loops node
1. 1,128.083 3,268.254 ↑ 1.0 480,311 1

Hash Join (cost=16,662.11..400,481.85 rows=483,510 width=3,460) (actual time=182.906..3,268.254 rows=480,311 loops=1)

  • Hash Cond: (docdeu.nit = nits.nit)
2. 1,959.722 1,959.722 ↑ 1.0 483,510 1

Index Scan using i_docdeu_nit on docdeu (cost=0.42..370,463.17 rows=483,510 width=3,248) (actual time=0.050..1,959.722 rows=483,510 loops=1)

3. 63.522 180.449 ↑ 1.0 230,475 1

Hash (cost=13,780.75..13,780.75 rows=230,475 width=8) (actual time=180.448..180.449 rows=230,475 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 11051kB
4. 116.927 116.927 ↑ 1.0 230,475 1

Seq Scan on nits (cost=0.00..13,780.75 rows=230,475 width=8) (actual time=0.033..116.927 rows=230,475 loops=1)

Planning time : 0.520 ms
Execution time : 3,305.855 ms