explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YDjW5

Settings
# exclusive inclusive rows x rows loops node
1. 3,584.542 4,987.159 ↓ 1.0 7,807,125 1

Hash Left Join (cost=36.52..283,923.81 rows=7,805,781 width=642) (actual time=0.365..4,987.159 rows=7,807,125 loops=1)

  • Hash Cond: (d.typdokument_id = td.id)
2. 1,402.281 1,402.281 ↓ 1.0 7,807,125 1

Seq Scan on d_dokument d (cost=0.00..263,278.81 rows=7,805,781 width=253) (actual time=0.014..1,402.281 rows=7,807,125 loops=1)

3. 0.216 0.336 ↑ 1.0 734 1

Hash (cost=27.34..27.34 rows=734 width=389) (actual time=0.336..0.336 rows=734 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 166kB
4. 0.120 0.120 ↑ 1.0 734 1

Seq Scan on d_typdokument td (cost=0.00..27.34 rows=734 width=389) (actual time=0.007..0.120 rows=734 loops=1)

Planning time : 0.636 ms
Execution time : 5,167.155 ms