explain.depesz.com

PostgreSQL's explain analyze made readable

Result: V3MI

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

Insert on scale_data (cost=0.01..900,000.31 rows=9,000,000 width=96) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Subquery Scan on "*SELECT*" (cost=0.01..900,000.31 rows=9,000,000 width=96) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.01..742,500.31 rows=9,000,000 width=16) (actual rows= loops=)

  • Join Filter: (gen.gen <= (sections.sections * 3000))
4. 0.000 0.000 ↓ 0.0

Function Scan on generate_series sections (cost=0.00..0.30 rows=30 width=4) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Function Scan on generate_series gen (cost=0.00..9,000.00 rows=900,000 width=4) (actual rows= loops=)