explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UaWU

Settings
# exclusive inclusive rows x rows loops node
1. 22.065 5,731.451 ↑ 259.5 97 1

Gather (cost=74,460.60..288,091.50 rows=25,173 width=24) (actual time=46.966..5,731.451 rows=97 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.096 5,709.386 ↑ 327.8 32 3 / 3

Nested Loop (cost=73,460.60..284,574.20 rows=10,489 width=24) (actual time=100.350..5,709.386 rows=32 loops=3)

3. 0.159 5,709.096 ↑ 327.8 32 3 / 3

Nested Loop (cost=73,460.17..279,118.00 rows=10,489 width=8) (actual time=100.332..5,709.096 rows=32 loops=3)

4. 16.996 5,708.484 ↑ 178.7 91 3 / 3

Hash Join (cost=73,459.74..270,021.31 rows=16,258 width=8) (actual time=100.312..5,708.484 rows=91 loops=3)

  • Hash Cond: (v.address_id = a.id)
5. 5,648.953 5,648.953 ↑ 4.3 152,651 3 / 3

Parallel Seq Scan on place_description_version v (cost=0.00..194,838.98 rows=656,222 width=16) (actual time=0.048..5,648.953 rows=152,651 loops=3)

  • Filter: (word_similarity('Dunkin Donuts'::text, (name)::text) > '0.200000000000000011'::double precision)
  • Rows Removed by Filter: 1422315
6. 1.883 42.535 ↑ 5.9 11,073 3 / 3

Hash (cost=72,643.44..72,643.44 rows=65,304 width=8) (actual time=42.535..42.535 rows=11,073 loops=3)

  • Buckets: 65536 Batches: 1 Memory Usage: 945kB
7. 9.762 40.652 ↑ 5.9 11,073 3 / 3

Bitmap Heap Scan on address a (cost=1,881.44..72,643.44 rows=65,304 width=8) (actual time=32.516..40.652 rows=11,073 loops=3)

  • Recheck Cond: (((lower((state)::text) = 'tx'::text) AND (lower((city)::text) = 'austin'::text)) OR (""left""((postal)::text, 5) = '78702'::text) OR (""left""((postal)::text, 5) = '78703'::text) OR (""left""((postal)::text, 5) = '78704'::text) OR (""left""((postal)::text, 5) = '78705'::text) OR (""left""((postal)::text, 5) = '78706'::text))
  • Heap Blocks: exact=9110
8. 0.000 30.890 ↓ 0.0 0 3 / 3

BitmapOr (cost=1,881.44..1,881.44 rows=65,961 width=0) (actual time=30.890..30.890 rows=0 loops=3)

9. 2.875 30.696 ↓ 0.0 0 3 / 3

BitmapAnd (cost=563.45..563.45 rows=66 width=0) (actual time=30.696..30.696 rows=0 loops=3)

10. 26.170 26.170 ↓ 17.4 229,545 3 / 3

Bitmap Index Scan on address_ix2 (cost=0.00..247.27 rows=13,179 width=0) (actual time=26.170..26.170 rows=229,545 loops=3)

  • Index Cond: (lower((state)::text) = 'tx'::text)
11. 1.651 1.651 ↑ 1.2 11,351 3 / 3

Bitmap Index Scan on address_ix3 (cost=0.00..283.27 rows=13,179 width=0) (actual time=1.651..1.651 rows=11,351 loops=3)

  • Index Cond: (lower((city)::text) = 'austin'::text)
12. 0.056 0.056 ↑ 24.8 532 3 / 3

Bitmap Index Scan on address_ix4 (cost=0.00..247.27 rows=13,179 width=0) (actual time=0.056..0.056 rows=532 loops=3)

  • Index Cond: (""left""((postal)::text, 5) = '78702'::text)
13. 0.033 0.033 ↑ 47.2 279 3 / 3

Bitmap Index Scan on address_ix4 (cost=0.00..247.27 rows=13,179 width=0) (actual time=0.033..0.033 rows=279 loops=3)

  • Index Cond: (""left""((postal)::text, 5) = '78703'::text)
14. 0.058 0.058 ↑ 16.0 825 3 / 3

Bitmap Index Scan on address_ix4 (cost=0.00..247.27 rows=13,179 width=0) (actual time=0.058..0.058 rows=825 loops=3)

  • Index Cond: (""left""((postal)::text, 5) = '78704'::text)
15. 0.037 0.037 ↑ 39.6 333 3 / 3

Bitmap Index Scan on address_ix4 (cost=0.00..247.27 rows=13,179 width=0) (actual time=0.037..0.037 rows=333 loops=3)

  • Index Cond: (""left""((postal)::text, 5) = '78705'::text)
16. 0.010 0.010 ↓ 0.0 0 3 / 3

Bitmap Index Scan on address_ix4 (cost=0.00..247.27 rows=13,179 width=0) (actual time=0.010..0.010 rows=0 loops=3)

  • Index Cond: (""left""((postal)::text, 5) = '78706'::text)
17. 0.453 0.453 ↓ 0.0 0 272 / 3

Index Scan using place_description_current_version_pointer_ix2 on place_description_current_version_pointer cvp (cost=0.43..0.55 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=272)

  • Index Cond: (place_description_version_id = v.id)
18. 0.194 0.194 ↑ 1.0 1 97 / 3

Index Scan using place_description_pkey on place_description e (cost=0.43..0.52 rows=1 width=24) (actual time=0.006..0.006 rows=1 loops=97)

  • Index Cond: (id = cvp.place_description_id)
Planning time : 1.120 ms
Execution time : 5,732.166 ms