explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5XpI

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

Append (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

  • Subplans Removed: 6
2.          

Initplan (for Append)

3. 0.000 0.000 ↓ 0.0 1 1

Result (cost=0..0 rows=0 width=0) (actual rows=1 loops=1)

4. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on ab_a1_b2 ab_1 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

  • Filter: ((b >= $1) AND (b <= $2) AND (a < $0))
5. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on ab_a2_b2 ab_2 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

  • Filter: ((b >= $1) AND (b <= $2) AND (a < $0))
6. 0.000 0.000 ↓ 0.0 0

Seq Scan on ab_a3_b2 ab_3 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ((b >= $1) AND (b <= $2) AND (a < $0))