explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uog3

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

Limit (cost=37,125.930..37,126.000 rows=30 width=2,848) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=37,125.930..37,155.010 rows=11,633 width=2,848) (actual rows= loops=)

  • Sort Key: quebec DESC oscar_quebec papa
3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on lima (cost=358.190..36,782.350 rows=11,633 width=2,848) (actual rows= loops=)

  • Recheck Cond: (yankee five NULL)
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on oscar_mike (cost=0.000..355.280 rows=11,633 width=0) (actual rows= loops=)

  • Index Cond: (yankee five NULL)