explain.depesz.com

PostgreSQL's explain analyze made readable

Result: V89O

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 489.556 ↓ 15.0 15 1

Limit (cost=43,750.10..43,750.11 rows=1 width=8) (actual time=489.552..489.556 rows=15 loops=1)

2. 0.003 489.554 ↓ 15.0 15 1

Group (cost=43,750.10..43,750.11 rows=1 width=8) (actual time=489.551..489.554 rows=15 loops=1)

  • Group Key: v.representative_id
3. 0.000 489.551 ↓ 7.5 15 1

Sort (cost=43,750.10..43,750.10 rows=2 width=8) (actual time=489.551..489.551 rows=15 loops=1)

  • Sort Key: v.representative_id
  • Sort Method: quicksort Memory: 25kB
4. 15.936 489.606 ↓ 7.5 15 1

Gather (cost=43,749.88..43,750.09 rows=2 width=8) (actual time=489.532..489.606 rows=15 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 0.004 473.670 ↓ 5.0 5 3 / 3

Group (cost=42,749.88..42,749.89 rows=1 width=8) (actual time=473.667..473.670 rows=5 loops=3)

  • Group Key: v.representative_id
6. 0.024 473.666 ↓ 5.0 5 3 / 3

Sort (cost=42,749.88..42,749.88 rows=1 width=8) (actual time=473.665..473.666 rows=5 loops=3)

  • Sort Key: v.representative_id
  • Sort Method: quicksort Memory: 25kB
7. 0.017 473.642 ↓ 5.0 5 3 / 3

Nested Loop (cost=1,197.84..42,749.87 rows=1 width=8) (actual time=150.553..473.642 rows=5 loops=3)

8. 0.019 473.575 ↓ 5.0 5 3 / 3

Nested Loop (cost=1,197.41..42,741.48 rows=1 width=16) (actual time=150.531..473.575 rows=5 loops=3)

9. 0.035 473.496 ↓ 5.0 5 3 / 3

Hash Join (cost=1,196.98..42,733.08 rows=1 width=24) (actual time=150.501..473.496 rows=5 loops=3)

  • Hash Cond: (e.data_source_id = ds.id)
10. 0.032 473.443 ↑ 13.2 6 3 / 3

Nested Loop (cost=1,188.80..42,724.69 rows=79 width=32) (actual time=95.484..473.443 rows=6 loops=3)

11. 252.290 473.339 ↑ 13.2 6 3 / 3

Hash Join (cost=1,188.37..42,684.10 rows=79 width=32) (actual time=95.464..473.339 rows=6 loops=3)

  • Hash Cond: (cvp.place_description_version_id = v.id)
12. 209.454 209.454 ↑ 1.3 1,015,926 3 / 3

Parallel Seq Scan on place_description_current_version_pointer cvp (cost=0.00..38,157.00 rows=1,271,900 width=16) (actual time=0.006..209.454 rows=1,015,926 loops=3)

13. 0.008 11.595 ↑ 13.9 21 3 / 3

Hash (cost=1,184.72..1,184.72 rows=292 width=32) (actual time=11.594..11.595 rows=21 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
14. 0.091 11.587 ↑ 13.9 21 3 / 3

Bitmap Heap Scan on place_description_version v (cost=58.26..1,184.72 rows=292 width=32) (actual time=11.519..11.587 rows=21 loops=3)

  • Recheck Cond: ((name)::text ~~* 'pias%'::text)
  • Rows Removed by Index Recheck: 5
  • Filter: (confidence >= '0'::numeric)
  • Heap Blocks: exact=26
15. 11.496 11.496 ↑ 11.2 26 3 / 3

Bitmap Index Scan on place_description_version_trigram_ix5 (cost=0.00..58.19 rows=292 width=0) (actual time=11.496..11.496 rows=26 loops=3)

  • Index Cond: ((name)::text ~~* 'pias%'::text)
16. 0.072 0.072 ↑ 1.0 1 18 / 3

Index Scan using place_description_pkey on place_description e (cost=0.43..0.51 rows=1 width=16) (actual time=0.012..0.012 rows=1 loops=18)

  • Index Cond: (id = cvp.place_description_id)
17. 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
18. 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)
19. 0.060 0.060 ↑ 1.0 1 15 / 3

Index Only Scan using address_pkey on address a (cost=0.43..8.39 rows=1 width=8) (actual time=0.012..0.012 rows=1 loops=15)

  • Index Cond: (id = v.address_id)
  • Heap Fetches: 4
20. 0.050 0.050 ↑ 1.0 1 15 / 3

Index Only Scan using geocode_pkey on geocode g (cost=0.43..8.39 rows=1 width=8) (actual time=0.010..0.010 rows=1 loops=15)

  • Index Cond: (id = v.geocode_id)
  • Heap Fetches: 4
Planning time : 1.525 ms
Execution time : 489.703 ms