explain.depesz.com

PostgreSQL's explain analyze made readable

Result: F4tE

Settings
# exclusive inclusive rows x rows loops node
1. 0.094 0.094 ↑ 7.5 27 1

CTE Scan on ancestors (cost=1,710.44..1,714.48 rows=202 width=64) (actual time=0.017..0.094 rows=27 loops=1)

2.          

CTE ancestors

3. 0.015 0.090 ↑ 7.5 27 1

Recursive Union (cost=0.43..1,710.44 rows=202 width=16) (actual time=0.017..0.090 rows=27 loops=1)

4. 0.019 0.019 ↑ 1.0 2 1

Index Scan using svmxc__site__c_pkey on svmxc__site__c (cost=0.43..12.89 rows=2 width=16) (actual time=0.016..0.019 rows=2 loops=1)

  • Index Cond: (id = ANY ('{00000N0,00000M0}'::text[]))
5. 0.002 0.056 ↑ 10.0 2 14

Nested Loop (cost=0.43..169.35 rows=20 width=16) (actual time=0.002..0.004 rows=2 loops=14)

6. 0.000 0.000 ↑ 10.0 2 14

WorkTable Scan on ancestors a (cost=0.00..0.40 rows=20 width=32) (actual time=0.000..0.000 rows=2 loops=14)

7. 0.054 0.054 ↑ 1.0 1 27

Index Scan using svmxc__site__c_pkey on svmxc__site__c site (cost=0.43..8.45 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=27)

  • Index Cond: (id = a.svmxc__parent__c)
Planning time : 0.135 ms