explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Xns

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

CTE Scan on cte (cost=53,713.00..72,375.44 rows=497,665 width=280) (actual rows= loops=)

2.          

CTE cte

3. 0.000 0.000 ↓ 0.0

Recursive Union (cost=0.00..53,713.00 rows=497,665 width=1,632) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on community_versions (cost=0.00..3,898.42 rows=14,495 width=1,632) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

WorkTable Scan on cte cte_1 (cost=0.00..3,986.13 rows=48,317 width=184) (actual rows= loops=)

  • Filter: ((row_index + 1) < array_length)