explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IFx2

Settings
# exclusive inclusive rows x rows loops node
1. 3.293 11,263.237 ↑ 1.0 100 1

Limit (cost=65,940.23..65,950.25 rows=100 width=8) (actual time=11,259.889..11,263.237 rows=100 loops=1)

2. 0.000 11,259.944 ↑ 9.5 100 1

Group (cost=65,940.23..66,035.36 rows=949 width=8) (actual time=11,259.888..11,259.944 rows=100 loops=1)

  • Group Key: v.representative_id
3. 39.721 11,263.208 ↑ 7.9 100 1

Gather Merge (cost=65,940.23..66,033.39 rows=790 width=8) (actual time=11,259.887..11,263.208 rows=100 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 0.106 11,223.487 ↓ 1.7 652 3 / 3

Group (cost=64,940.20..64,942.18 rows=395 width=8) (actual time=11,223.343..11,223.487 rows=652 loops=3)

  • Group Key: v.representative_id
5. 15.914 11,223.381 ↓ 1.7 653 3 / 3

Sort (cost=64,940.20..64,941.19 rows=395 width=8) (actual time=11,223.341..11,223.381 rows=653 loops=3)

  • Sort Key: v.representative_id
  • Sort Method: quicksort Memory: 3115kB
6. 35.075 11,207.467 ↓ 85.3 33,712 3 / 3

Nested Loop (cost=9.90..64,923.17 rows=395 width=8) (actual time=49.016..11,207.467 rows=33,712 loops=3)

7. 45.943 11,071.256 ↓ 85.3 33,712 3 / 3

Nested Loop (cost=9.47..64,707.07 rows=395 width=16) (actual time=48.992..11,071.256 rows=33,712 loops=3)

8. 539.877 10,924.177 ↓ 85.3 33,712 3 / 3

Nested Loop (cost=9.04..64,457.49 rows=395 width=24) (actual time=48.969..10,924.177 rows=33,712 loops=3)

9. 91.171 3,134.943 ↓ 764.1 906,170 3 / 3

Nested Loop (cost=8.61..63,607.57 rows=1,186 width=8) (actual time=16.208..3,134.943 rows=906,170 loops=3)

10. 212.520 325.263 ↓ 764.7 906,170 3 / 3

Hash Join (cost=8.18..63,013.57 rows=1,185 width=8) (actual time=16.193..325.263 rows=906,170 loops=3)

  • Hash Cond: (e.data_source_id = ds.id)
11. 112.725 112.725 ↑ 1.2 1,015,086 3 / 3

Parallel Seq Scan on place_description e (cost=0.00..59,665.44 rows=1,267,344 width=16) (actual time=0.005..112.725 rows=1,015,086 loops=3)

12. 0.003 0.018 ↑ 1.0 1 3 / 3

Hash (cost=8.17..8.17 rows=1 width=8) (actual time=0.018..0.018 rows=1 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
13. 0.015 0.015 ↑ 1.0 1 3 / 3

Index Scan using data_source_ux1 on data_source ds (cost=0.15..8.17 rows=1 width=8) (actual time=0.014..0.015 rows=1 loops=3)

  • Index Cond: ((name)::text = 'SAFEGRAPH'::text)
14. 2,718.509 2,718.509 ↑ 1.0 1 2,718,509 / 3

Index Scan using place_description_current_version_pointer_ux1 on place_description_current_version_pointer cvp (cost=0.43..0.50 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=2,718,509)

  • Index Cond: (place_description_id = e.id)
15. 7,249.357 7,249.357 ↓ 0.0 0 2,718,509 / 3

Index Scan using place_description_version_pkey on place_description_version v (cost=0.43..0.72 rows=1 width=32) (actual time=0.008..0.008 rows=0 loops=2,718,509)

  • Index Cond: (id = cvp.place_description_version_id)
  • Filter: ((confidence >= '0'::numeric) AND (word_similarity(lower((name)::text), 'amy''s ice cream'::text) > '0.200000000000000011'::double precision))
  • Rows Removed by Filter: 1
16. 101.136 101.136 ↑ 1.0 1 101,136 / 3

Index Only Scan using address_pkey on address a (cost=0.43..0.63 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=101,136)

  • Index Cond: (id = v.address_id)
  • Heap Fetches: 33679
17. 101.136 101.136 ↑ 1.0 1 101,136 / 3

Index Only Scan using geocode_pkey on geocode g (cost=0.43..0.55 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=101,136)

  • Index Cond: (id = v.geocode_id)
  • Heap Fetches: 33679
Planning time : 1.683 ms
Execution time : 11,263.689 ms