explain.depesz.com

PostgreSQL's explain analyze made readable

Result: i6rQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 6.133 ↑ 1.0 1 1

Limit (cost=1,442.62..1,442.63 rows=1 width=12) (actual time=6.120..6.133 rows=1 loops=1)

  • Planning time: 0.262 ms
  • Execution time: 6.163 ms
2. 0.026 6.117 ↑ 166.0 1 1

Sort (cost=1,442.62..1,443.04 rows=166 width=12) (actual time=6.117..6.117 rows=1 loops=1)

  • Sort Key: (CASE WHEN (location = 'CW'::bpchar) THEN 0 ELSE 1 END)
  • Sort Method: top-N heapsort Memory: 25kB
3. 0.135 6.091 ↑ 4.9 34 1

Bitmap Heap Scan on stock (cost=791.35..1,441.79 rows=166 width=12) (actual time=5.973..6.091 rows=34 loops=1)

  • Recheck Cond: ((upper(btrim((supplier_code)::text)) = 'EX004T'::text) AND ((supplier)::text = 'MLA'::text))
  • Heap Blocks: exact=34
4. 0.008 5.956 ↓ 0.0 0 1

BitmapAnd (cost=791.35..791.35 rows=166 width=0) (actual time=5.956..5.956 rows=0 loops=1)

5. 0.038 0.038 ↑ 81.0 34 1

Bitmap Index Scan on stock_supplier_code_upper (cost=0.00..61.09 rows=2,755 width=0) (actual time=0.038..0.038 rows=34 loops=1)

  • Index Cond: (upper(btrim((supplier_code)::text)) = 'EX004T'::text)
6. 5.910 5.910 ↓ 1.0 34,028 1

Bitmap Index Scan on stock_supplier_idx (cost=0.00..729.92 rows=33,266 width=0) (actual time=5.910..5.910 rows=34,028 loops=1)

  • Index Cond: ((supplier)::text = 'MLA'::text)