explain.depesz.com

PostgreSQL's explain analyze made readable

Result: A31D

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

Nested Loop (cost=0.01..25,050.03 rows=2,000,000 width=12) (actual rows= loops=)

  • Output: s1.s1, s2.s2, "*VALUES*".column1
2. 0.000 0.000 ↓ 0.0

Function Scan on pg_catalog.generate_series s2 (cost=0.00..10.00 rows=1,000 width=4) (actual rows= loops=)

  • Output: s2.s2
  • Function Call: generate_series(1, 10)
3. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..45.03 rows=2,000 width=8) (actual rows= loops=)

  • Output: s1.s1, "*VALUES*".column1
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..35.03 rows=2,000 width=8) (actual rows= loops=)

  • Output: s1.s1, "*VALUES*".column1
5. 0.000 0.000 ↓ 0.0

Function Scan on pg_catalog.generate_series s1 (cost=0.00..10.00 rows=1,000 width=4) (actual rows= loops=)

  • Output: s1.s1
  • Function Call: generate_series(1, 10)
6. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..0.04 rows=2 width=4) (actual rows= loops=)

  • Output: "*VALUES*".column1
7. 0.000 0.000 ↓ 0.0

Values Scan on "*VALUES*" (cost=0.00..0.03 rows=2 width=4) (actual rows= loops=)

  • Output: "*VALUES*".column1