explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WUXP

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

Limit (cost=5.48..5.48 rows=1 width=92) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=5.48..5.56 rows=30 width=92) (actual rows= loops=)

  • Sort Key: (uniform())
3. 0.000 0.000 ↓ 0.0

Subquery Scan on quebec (cost=0.42..5.33 rows=30 width=92) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Limit (cost=0.42..4.96 rows=30 width=84) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Scan using golf on four (cost=0.42..12,169.73 rows=80,518 width=84) (actual rows= loops=)

  • Filter: (mike AND ((lima)::text = 'victor'::text))