explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vkBK

Settings
# exclusive inclusive rows x rows loops node
1. 69.293 31,121.532 ↑ 1.0 1 1

Aggregate (cost=1,062,371.23..1,062,371.24 rows=1 width=8) (actual time=31,121.531..31,121.532 rows=1 loops=1)

2. 24,935.520 31,052.239 ↓ 1.2 971,169 1

Bitmap Heap Scan on c_b_pty party0_ (cost=292,212.29..1,060,386.60 rows=793,852 width=15) (actual time=6,339.353..31,052.239 rows=971,169 loops=1)

  • Filter: (((frst_nm)::text ~~ 'R%'::text) AND ((lst_nm)::text ~~ 'R%'::text) AND (hub_state_ind = '1'::numeric))
  • Rows Removed by Filter: 85403596
  • Heap Blocks: exact=460265 lossy=2058410
3. 279.727 6,116.719 ↓ 0.0 0 1

BitmapAnd (cost=292,212.29..292,212.29 rows=792,808 width=0) (actual time=6,116.718..6,116.719 rows=0 loops=1)

4. 2,828.338 2,828.338 ↑ 1.0 9,385,015 1

Bitmap Index Scan on test_index_ln (cost=0.00..125,343.59 rows=9,429,222 width=0) (actual time=2,828.338..2,828.338 rows=9,385,015 loops=1)

  • Index Cond: (((lst_nm)::text ~>=~ 'R'::text) AND ((lst_nm)::text ~<~ 'S'::text))
5. 3,008.654 3,008.654 ↓ 1.0 12,762,096 1

Bitmap Index Scan on test_index_fn (cost=0.00..166,471.52 rows=12,705,355 width=0) (actual time=3,008.654..3,008.654 rows=12,762,096 loops=1)

  • Index Cond: (((frst_nm)::text ~>=~ 'R'::text) AND ((frst_nm)::text ~<~ 'S'::text))
Planning time : 3.479 ms
Execution time : 31,142.710 ms