explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0Z2H

Settings
# exclusive inclusive rows x rows loops node
1. 39.400 10,807.662 ↓ 1.6 24,745 1

Nested Loop (cost=198,565.51..1,646,278.43 rows=15,236 width=173) (actual time=910.293..10,807.662 rows=24,745 loops=1)

2. 463.341 1,637.357 ↓ 1.6 24,745 1

Hash Join (cost=198,565.08..268,827.19 rows=15,236 width=76) (actual time=910.243..1,637.357 rows=24,745 loops=1)

  • Hash Cond: (cvp.place_description_version_id = v.id)
3. 264.944 264.944 ↑ 1.0 3,046,229 1

Seq Scan on place_description_current_version_pointer cvp (cost=0.00..62,263.16 rows=3,047,216 width=16) (actual time=0.007..264.944 rows=3,046,229 loops=1)

4. 7.906 909.072 ↓ 1.1 25,708 1

Hash (cost=198,269.16..198,269.16 rows=23,674 width=68) (actual time=909.072..909.072 rows=25,708 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 2,659kB
5. 4.285 901.166 ↓ 1.1 25,708 1

Gather (cost=1,000.00..198,269.16 rows=23,674 width=68) (actual time=0.964..901.166 rows=25,708 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
6. 896.881 896.881 ↑ 1.2 8,569 3 / 3

Parallel Seq Scan on place_description_version v (cost=0.00..194,901.76 rows=9,864 width=68) (actual time=0.673..896.881 rows=8,569 loops=3)

  • Filter: (lower((name)::text) ~~ 'subway%'::text)
  • Rows Removed by Filter: 1,565,309
7. 9,056.670 9,056.670 ↑ 1.0 1 24,745

Index Scan using place_description_pkey on place_description e (cost=0.43..0.52 rows=1 width=73) (actual time=0.366..0.366 rows=1 loops=24,745)

  • Index Cond: (id = cvp.place_description_id)
8.          

SubPlan (for Nested Loop)

9. 24.745 74.235 ↑ 1.0 1 24,745

Aggregate (cost=89.88..89.89 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=24,745)

10. 49.490 49.490 ↓ 0.0 0 24,745

Index Only Scan using place_description_match_ux1 on place_description_match m (cost=0.43..89.76 rows=47 width=8) (actual time=0.002..0.002 rows=0 loops=24,745)

  • Index Cond: (place_description_version_id = v.id)
  • Heap Fetches: 51
Planning time : 0.568 ms
Execution time : 10,810.124 ms