explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Om1S

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 9,314.844 ↓ 228.0 684 1

Gather Merge (cost=203,458.31..203,458.67 rows=3 width=54) (actual time=9,105.607..9,314.844 rows=684 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
2. 2.504 36,399.904 ↓ 171.0 171 4

Sort (cost=202,458.27..202,458.28 rows=1 width=54) (actual time=9,099.970..9,099.976 rows=171 loops=4)

  • Sort Key: dl.dl_licno
  • Sort Method: quicksort Memory: 47kB
  • Worker 0: Sort Method: quicksort Memory: 48kB
  • Worker 1: Sort Method: quicksort Memory: 47kB
  • Worker 2: Sort Method: quicksort Memory: 46kB
3. 19.967 36,397.400 ↓ 171.0 171 4

Nested Loop (cost=156,972.60..202,458.26 rows=1 width=54) (actual time=5,922.143..9,099.350 rows=171 loops=4)

4. 25,857.908 31,159.668 ↓ 10.0 42,079 4

Parallel Bitmap Heap Scan on biolic bl (cost=156,972.03..183,161.30 rows=4,218 width=53) (actual time=5,486.612..7,789.917 rows=42,079 loops=4)

  • Recheck Cond: (((bio_swd_full_name)::text ~~ '%KANT%'::text) AND ((bio_nat_name)::text ~~ '%KUMAR%'::text))
  • Rows Removed by Index Recheck: 155938
  • Heap Blocks: exact=183569
5. 69.513 5,301.760 ↓ 0.0 0 1

BitmapAnd (cost=156,972.03..156,972.03 rows=13,075 width=0) (actual time=5,301.760..5,301.760 rows=0 loops=1)

6. 771.223 771.223 ↓ 9.6 1,039,868 1

Bitmap Index Scan on biolic_bio_swd_full_name_gin_trgm_idx (cost=0.00..1,596.43 rows=108,057 width=0) (actual time=771.223..771.223 rows=1,039,868 loops=1)

  • Index Cond: ((bio_swd_full_name)::text ~~ '%KANT%'::text)
7. 4,461.024 4,461.024 ↓ 1.3 24,212,678 1

Bitmap Index Scan on biolic_bio_nat_name_gin_trgm_idx (cost=0.00..155,368.81 rows=18,782,509 width=0) (actual time=4,461.024..4,461.024 rows=24,212,678 loops=1)

  • Index Cond: ((bio_nat_name)::text ~~ '%KUMAR%'::text)
8. 5,217.765 5,217.765 ↓ 0.0 0 168,315

Index Scan using uki_dl_bioid on dlicense dl (cost=0.57..4.57 rows=1 width=37) (actual time=0.031..0.031 rows=0 loops=168,315)

  • Index Cond: ((dl_bioid)::text = (bl.bio_bio_id)::text)
  • Filter: ((dl_state_cd = 'UP'::bpchar) AND (btrim((dl_rtocode)::text) = 'UP33'::text))
  • Rows Removed by Filter: 1
Planning time : 0.494 ms
Execution time : 9,314.967 ms