explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lGRV : temp table less orphans deletion

Settings
# exclusive inclusive rows x rows loops node
1. 3.298 54.020 ↓ 0.0 0 1

Delete on fact_paths fp (cost=3,138.38..5,778.74 rows=3,080 width=12) (actual time=54.020..54.020 rows=0 loops=1)

2. 2.656 50.722 ↓ 1.7 5,344 1

Hash Anti Join (cost=3,138.38..5,778.74 rows=3,080 width=12) (actual time=46.266..50.722 rows=5,344 loops=1)

  • Hash Cond: (fp.path = tmp_live_paths.path)
3. 2.219 2.219 ↑ 1.0 6,161 1

Seq Scan on fact_paths fp (cost=0.00..287.61 rows=6,161 width=106) (actual time=0.011..2.219 rows=6,161 loops=1)

4. 26.536 45.847 ↓ 1.2 122,513 1

Hash (cost=1,824.28..1,824.28 rows=105,128 width=38) (actual time=45.847..45.847 rows=122,513 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 7960kB
5. 19.311 19.311 ↓ 1.2 122,513 1

Seq Scan on tmp_live_paths (cost=0.00..1,824.28 rows=105,128 width=38) (actual time=0.012..19.311 rows=122,513 loops=1)