explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Hx3c

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 49.621 ↑ 6.7 3 1

Limit (cost=16,596.37..16,598.67 rows=20 width=604) (actual time=49.619..49.621 rows=3 loops=1)

2. 0.000 51.446 ↑ 315.3 3 1

Gather Merge (cost=16,596.37..16,705.16 rows=946 width=604) (actual time=49.617..51.446 rows=3 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 0.080 93.730 ↑ 473.0 2 2

Sort (cost=15,596.36..15,598.72 rows=946 width=604) (actual time=46.864..46.865 rows=2 loops=2)

  • Sort Key: (((term_translations.name)::text || ''::text))
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
4. 24.204 93.650 ↑ 473.0 2 2

Parallel Hash Join (cost=10,860.35..15,571.18 rows=946 width=604) (actual time=28.525..46.825 rows=2 loops=2)

  • Hash Cond: (terms.id = term_translations.term_id)
5. 38.178 38.178 ↑ 1.2 100,000 2

Parallel Seq Scan on terms (cost=0.00..3,526.46 rows=117,646 width=41) (actual time=0.011..19.089 rows=100,000 loops=2)

6. 0.136 31.268 ↑ 473.0 2 2

Parallel Hash (cost=10,848.53..10,848.53 rows=946 width=531) (actual time=15.633..15.634 rows=2 loops=2)

  • Buckets: 2048 Batches: 1 Memory Usage: 80kB
7. 13.156 31.132 ↑ 473.0 2 2

Parallel Bitmap Heap Scan on term_translations (cost=6,089.48..10,848.53 rows=946 width=531) (actual time=15.563..15.566 rows=2 loops=2)

  • Recheck Cond: ((lower((name)::text) ~~ '%hgty%'::text) AND ((language)::text = 'EN'::text))
  • Heap Blocks: exact=2
8. 0.005 17.976 ↓ 0.0 0 1

BitmapAnd (cost=6,089.48..6,089.48 rows=1,609 width=0) (actual time=17.976..17.976 rows=0 loops=1)

9. 4.460 4.460 ↑ 615.4 26 1

Bitmap Index Scan on term_translations_lower_name_idx (cost=0.00..1,768.00 rows=16,000 width=0) (actual time=4.459..4.460 rows=26 loops=1)

  • Index Cond: (lower((name)::text) ~~ '%hgty%'::text)
10. 13.511 13.511 ↑ 1.0 200,000 1

Bitmap Index Scan on term_translations_language_index (cost=0.00..4,320.42 rows=201,066 width=0) (actual time=13.511..13.511 rows=200,000 loops=1)

  • Index Cond: ((language)::text = 'EN'::text)