explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jndf

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 55,605.793 ↑ 1.0 1 1

Aggregate (cost=518,917.60..518,917.61 rows=1 width=40) (actual time=55,605.793..55,605.793 rows=1 loops=1)

2.          

CTE hash_list

3. 0.002 55,605.783 ↓ 0.0 0 1

Limit (cost=518,909.11..518,909.12 rows=1 width=7) (actual time=55,605.783..55,605.783 rows=0 loops=1)

4. 0.000 55,605.781 ↓ 0.0 0 1

Unique (cost=518,909.11..518,909.12 rows=1 width=7) (actual time=55,605.781..55,605.781 rows=0 loops=1)

5. 0.000 55,605.781 ↓ 0.0 0 1

Sort (cost=518,909.11..518,909.12 rows=1 width=7) (actual time=55,605.781..55,605.781 rows=0 loops=1)

  • Sort Key: include.hash
  • Sort Method: quicksort Memory: 25kB
6. 1,334.472 56,887.825 ↓ 0.0 0 1

Gather (cost=249,158.51..518,909.10 rows=1 width=7) (actual time=55,605.745..56,887.825 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
7. 23,857.090 55,553.353 ↓ 0.0 0 3 / 3

Parallel Hash Anti Join (cost=248,158.51..517,909.00 rows=1 width=7) (actual time=55,553.341..55,553.353 rows=0 loops=3)

  • Hash Cond: ((include.hash)::text = (exclude.hash)::text)
8. 10,964.108 10,964.108 ↑ 1.2 4,251,758 3 / 3

Parallel Seq Scan on include_test include (cost=0.00..160,964.10 rows=5,314,673 width=7) (actual time=0.028..10,964.108 rows=4,251,758 loops=3)

  • Filter: ((segment IS NULL) AND (location_group IS NULL) AND ((include_exclude)::text = 'include'::text) AND ((segment_type)::text = 'foot_gh'::text))
9. 9,079.069 20,732.155 ↑ 1.2 4,251,758 3 / 3

Parallel Hash (cost=160,964.10..160,964.10 rows=5,314,673 width=7) (actual time=20,732.155..20,732.155 rows=4,251,758 loops=3)

  • Buckets: 131,072 Batches: 256 Memory Usage: 3,008kB
10. 11,653.086 11,653.086 ↑ 1.2 4,251,758 3 / 3

Parallel Seq Scan on exclude_test exclude (cost=0.00..160,964.10 rows=5,314,673 width=7) (actual time=0.028..11,653.086 rows=4,251,758 loops=3)

  • Filter: ((segment IS NULL) AND (location_group IS NULL) AND ((include_exclude)::text = 'exclude'::text) AND ((segment_type)::text = 'foot_gh'::text))
11. 0.001 55,605.785 ↓ 0.0 0 1

Nested Loop (cost=0.43..8.47 rows=1 width=4) (actual time=55,605.785..55,605.785 rows=0 loops=1)

12. 55,605.784 55,605.784 ↓ 0.0 0 1

CTE Scan on hash_list h (cost=0.00..0.02 rows=1 width=50) (actual time=55,605.784..55,605.784 rows=0 loops=1)

13. 0.000 0.000 ↓ 0.0 0

Index Scan using gis_public_nt_geohash_uu_pk on nt_geohash_uu idx (cost=0.43..8.45 rows=1 width=11) (never executed)

  • Index Cond: ((geohash)::text = (h.hash)::text)
Planning time : 0.992 ms
Execution time : 56,888.060 ms