explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eOCh

Settings

Optimization path:

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

Nested Loop (cost=0.00..1,263.38 rows=100,000 width=76) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..8.88 rows=500 width=43) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Seq Scan on posts (cost=0.00..1.50 rows=50 width=22) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1.15 rows=10 width=21) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on users (cost=0.00..1.10 rows=10 width=21) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..5.00 rows=200 width=33) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on comments (cost=0.00..4.00 rows=200 width=33) (actual rows= loops=)