explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uZK3

Settings
# exclusive inclusive rows x rows loops node
1. 0.173 80,713.091 ↓ 20.0 100 1

Limit (cost=58,487.17..58,487.19 rows=5 width=8) (actual time=80,712.892..80,713.091 rows=100 loops=1)

2. 0.022 80,712.918 ↓ 20.0 100 1

Group (cost=58,487.17..58,487.19 rows=5 width=8) (actual time=80,712.891..80,712.918 rows=100 loops=1)

  • Group Key: v.representative_id
3. 8.144 80,712.896 ↓ 25.0 100 1

Sort (cost=58,487.17..58,487.18 rows=4 width=8) (actual time=80,712.888..80,712.896 rows=100 loops=1)

  • Sort Key: v.representative_id
  • Sort Method: quicksort Memory: 1,907kB
4. 481.519 80,704.752 ↓ 6,072.0 24,288 1

Gather (cost=58,486.72..58,487.13 rows=4 width=8) (actual time=79,830.299..80,704.752 rows=24,288 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 1.760 80,223.233 ↓ 4,048.0 8,096 3 / 3

Group (cost=57,486.72..57,486.73 rows=2 width=8) (actual time=80,220.879..80,223.233 rows=8,096 loops=3)

  • Group Key: v.representative_id
6. 9.869 80,221.473 ↓ 4,048.0 8,096 3 / 3

Sort (cost=57,486.72..57,486.72 rows=2 width=8) (actual time=80,220.878..80,221.473 rows=8,096 loops=3)

  • Sort Key: v.representative_id
  • Sort Method: quicksort Memory: 575kB
7. 18.818 80,211.604 ↓ 4,048.0 8,096 3 / 3

Nested Loop (cost=9.90..57,486.71 rows=2 width=8) (actual time=3,007.300..80,211.604 rows=8,096 loops=3)

8. 17.036 70,121.362 ↓ 4,048.0 8,096 3 / 3

Nested Loop (cost=9.47..57,473.34 rows=2 width=16) (actual time=3,002.770..70,121.362 rows=8,096 loops=3)

9. 763.459 58,195.110 ↓ 4,048.0 8,096 3 / 3

Nested Loop (cost=9.04..57,459.58 rows=2 width=24) (actual time=2,999.972..58,195.110 rows=8,096 loops=3)

10. 798.833 18,466.355 ↓ 762.1 906,170 3 / 3

Nested Loop (cost=8.61..56,721.55 rows=1,189 width=8) (actual time=52.704..18,466.355 rows=906,170 loops=3)

11. 292.881 450.298 ↓ 751.4 906,170 3 / 3

Hash Join (cost=8.18..56,124.82 rows=1,206 width=8) (actual time=44.127..450.298 rows=906,170 loops=3)

  • Hash Cond: (e.data_source_id = ds.id)
12. 150.335 150.335 ↑ 1.3 1,015,926 3 / 3

Parallel Seq Scan on place_description e (cost=0.00..52,715.11 rows=1,290,711 width=16) (actual time=0.005..150.335 rows=1,015,926 loops=3)

13. 0.006 7.082 ↑ 1.0 1 3 / 3

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
14. 7.076 7.076 ↑ 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=7.075..7.076 rows=1 loops=3)

  • Index Cond: ((name)::text = 'SAFEGRAPH'::text)
15. 17,217.224 17,217.224 ↑ 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.49 rows=1 width=16) (actual time=0.019..0.019 rows=1 loops=2,718,509)

  • Index Cond: (place_description_id = e.id)
16. 38,965.296 38,965.296 ↓ 0.0 0 2,718,509 / 3

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

  • Index Cond: (id = cvp.place_description_version_id)
  • Filter: ((confidence >= 0.1) AND ((name)::text ~~* '%sport%'::text))
  • Rows Removed by Filter: 1
17. 11,909.216 11,909.216 ↑ 1.0 1 24,288 / 3

Index Only Scan using address_pkey on address a (cost=0.43..6.88 rows=1 width=8) (actual time=1.471..1.471 rows=1 loops=24,288)

  • Index Cond: (id = v.address_id)
  • Heap Fetches: 8,154
18. 10,071.424 10,071.424 ↑ 1.0 1 24,288 / 3

Index Only Scan using geocode_pkey on geocode g (cost=0.43..6.68 rows=1 width=8) (actual time=1.244..1.244 rows=1 loops=24,288)

  • Index Cond: (id = v.geocode_id)
  • Heap Fetches: 8,154
Planning time : 101.844 ms