explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2i5L : For Chris

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

Aggregate (cost=835.27..835.28 rows=1 width=32) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=28.92..826.92 rows=1,113 width=10) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Seq Scan on products (cost=0.00..2.25 rows=1 width=14) (actual rows= loops=)

  • Filter: (product_id = 1)
4. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on line_items (cost=28.92..813.54 rows=1,113 width=12) (actual rows= loops=)

  • Recheck Cond: (product_id = 1)
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on li_product (cost=0.00..28.64 rows=1,113 width=0) (actual rows= loops=)

  • Index Cond: (product_id = 1)