explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qbc5

Settings
# exclusive inclusive rows x rows loops node
1. 0.814 1.813 ↓ 2.3 116 1

Sort (cost=63.32..63.45 rows=50 width=14,536) (actual time=1.503..1.813 rows=116 loops=1)

  • Sort Key: code
  • Sort Method: quicksort Memory: 30kB
2. 0.902 0.999 ↓ 2.3 116 1

Bitmap Heap Scan on potential_carrier (cost=4.80..61.91 rows=50 width=14,536) (actual time=0.160..0.999 rows=116 loops=1)

  • Filter: ((code)::text ~~* '22%'::text)
  • Heap Blocks: exact=4
3. 0.097 0.097 ↓ 2.4 118 1

Bitmap Index Scan on potential_carrier_code_as_text_index (cost=0.00..4.79 rows=50 width=0) (actual time=0.095..0.097 rows=118 loops=1)

  • Index Cond: (((code)::text ~>=~ '22'::text) AND ((code)::text ~<~ '23'::text))
Planning time : 0.507 ms
Execution time : 2.268 ms