explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Fq1W

Settings
# exclusive inclusive rows x rows loops node
1. 379.476 379.476 ↓ 101.1 46,817 1

CTE Scan on dependency_tree (cost=3,839.68..3,848.95 rows=463 width=8) (actual time=1.075..379.476 rows=46,817 loops=1)

2.          

CTE dependency_tree

3. 39.951 305.073 ↓ 101.1 46,817 1

Recursive Union (cost=0.00..3,839.68 rows=463 width=41) (actual time=1.068..305.073 rows=46,817 loops=1)

4. 3.847 3.847 ↓ 1.7 5 1

Seq Scan on procedure_used_procedures p (cost=0.00..333.09 rows=3 width=41) (actual time=1.063..3.847 rows=5 loops=1)

  • Filter: (procedure_id = 1510524)
  • Rows Removed by Filter: 11762
5. 133.875 261.275 ↓ 40.7 1,872 25

Hash Join (cost=0.79..349.73 rows=46 width=41) (actual time=1.819..10.451 rows=1,872 loops=25)

  • Hash Cond: (p_1.procedure_id = dt.subprocedure_id)
6. 96.300 96.300 ↑ 1.0 11,767 25

Seq Scan on procedure_used_procedures p_1 (cost=0.00..303.67 rows=11,767 width=16) (actual time=0.004..3.852 rows=11,767 loops=25)

7. 16.825 31.100 ↓ 123.3 1,850 25

Hash (cost=0.60..0.60 rows=15 width=40) (actual time=1.244..1.244 rows=1,850 loops=25)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
8. 14.275 14.275 ↓ 123.3 1,850 25

WorkTable Scan on dependency_tree dt (cost=0.00..0.60 rows=15 width=40) (actual time=0.002..0.571 rows=1,850 loops=25)

  • Filter: (NOT cycle)
  • Rows Removed by Filter: 23