explain.depesz.com

PostgreSQL's explain analyze made readable

Result: seir

Settings
# exclusive inclusive rows x rows loops node
1. 1.167 1.167 ↑ 20.5 2 1

CTE Scan on children (cost=15.55..16.37 rows=41 width=343) (actual time=0.251..1.167 rows=2 loops=1)

2.          

CTE children

3. 0.011 1.158 ↑ 20.5 2 1

Recursive Union (cost=0.00..15.55 rows=41 width=343) (actual time=0.245..1.158 rows=2 loops=1)

4. 0.241 0.241 ↑ 1.0 1 1

Seq Scan on infotech_infotechrecord itr (cost=0.00..1.05 rows=1 width=343) (actual time=0.240..0.241 rows=1 loops=1)

  • Filter: (id = 1)
  • Rows Removed by Filter: 3
5. 0.894 0.906 ↓ 0.0 0 2

Hash Join (cost=1.09..1.37 rows=4 width=343) (actual time=0.452..0.453 rows=0 loops=2)

  • Hash Cond: (c.id = itr_1.parent_id)
6. 0.000 0.000 ↑ 10.0 1 2

WorkTable Scan on children c (cost=0.00..0.20 rows=10 width=4) (actual time=0.000..0.000 rows=1 loops=2)

7. 0.008 0.012 ↑ 4.0 1 1

Hash (cost=1.04..1.04 rows=4 width=339) (actual time=0.012..0.012 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
8. 0.004 0.004 ↑ 1.0 4 1

Seq Scan on infotech_infotechrecord itr_1 (cost=0.00..1.04 rows=4 width=339) (actual time=0.003..0.004 rows=4 loops=1)

Planning time : 19.189 ms
Execution time : 3.373 ms