explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AE8A

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

CTE Scan on cte (cost=53,698.01..63,648.43 rows=497,521 width=184) (actual rows= loops=)

2.          

CTE cte

3. 0.000 0.000 ↓ 0.0

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

4. 0.000 0.000 ↓ 0.0

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

5. 0.000 0.000 ↓ 0.0

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

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