#	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)

                                                               QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------
 Delete on fact_paths fp  (cost=3138.38..5778.74 rows=3080 width=12) (actual time=54.020..54.020 rows=0 loops=1)
   ->  Hash Anti Join  (cost=3138.38..5778.74 rows=3080 width=12) (actual time=46.266..50.722 rows=5344 loops=1)
         Hash Cond: (fp.path = tmp_live_paths.path)
         ->  Seq Scan on fact_paths fp  (cost=0.00..287.61 rows=6161 width=106) (actual time=0.011..2.219 rows=6161 loops=1)
         ->  Hash  (cost=1824.28..1824.28 rows=105128 width=38) (actual time=45.847..45.847 rows=122513 loops=1)
               Buckets: 131072  Batches: 1  Memory Usage: 7960kB
               ->  Seq Scan on tmp_live_paths  (cost=0.00..1824.28 rows=105128 width=38) (actual time=0.012..19.311 rows=122513 loops=1)
 Planning time: 0.490 ms
 Execution time: 54.060 ms
(9 rows)

Per node type stats

node type	count	sum of times	% of query
Delete	1	3.298 ms	6.1 %
Hash	1	26.536 ms	49.1 %
Hash Anti Join	1	2.656 ms	4.9 %
Seq Scan	2	21.530 ms	39.9 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
fact_paths	2	5.517 ms	10.2 %
Delete	1	3.298 ms	59.8 %
Seq Scan	1	2.219 ms	40.2 %
tmp_live_paths	1	19.311 ms	35.7 %
Seq Scan	1	19.311 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lGRV : temp table less orphans deletion

Color mode:

Visible columns:

Per node type stats

Per table stats