explain.depesz.com

PostgreSQL's explain analyze made readable

Result: D7Zk

Settings
# exclusive inclusive rows x rows loops node
1. 20.739 32.701 ↓ 45,058.0 45,058 1

Hash Full Join (cost=771.96..3,260.23 rows=1 width=96) (actual time=7.451..32.701 rows=45,058 loops=1)

  • Hash Cond: (c_1.generatedpk = e_1.generatedpk)
  • Filter: ((e_1.generatedpk IS NULL) OR (e_1.deleted = '0'::numeric) OR (e_1.deleted IS NULL))
  • Rows Removed by Filter: 16,665
2. 4.652 4.652 ↑ 1.0 61,723 1

Seq Scan on cdl_bmap_mapping c_1 (cost=0.00..2,326.23 rows=61,723 width=42) (actual time=0.005..4.652 rows=61,723 loops=1)

3. 3.601 7.310 ↑ 1.0 16,665 1

Hash (cost=563.65..563.65 rows=16,665 width=53) (actual time=7.310..7.310 rows=16,665 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,661kB
4. 3.709 3.709 ↑ 1.0 16,665 1

Seq Scan on cdl_bmap_mappinge e_1 (cost=0.00..563.65 rows=16,665 width=53) (actual time=0.011..3.709 rows=16,665 loops=1)

Planning time : 0.549 ms