explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RBVj

Settings
# exclusive inclusive rows x rows loops node
1. 73.790 308.412 ↓ 144.0 144 1

Hash Right Join (cost=346.09..50,688.26 rows=1 width=76) (actual time=0.536..308.412 rows=144 loops=1)

  • Hash Cond: ((b.geometry_key)::text = (c.geometry_key)::text)
  • Filter: ((CASE WHEN (b.geometry_key IS NULL) THEN 'NO'::text ELSE 'YES'::text END IS NOT NULL) AND (CASE WHEN (b.geometry_key IS NULL) THEN 'NO'::text ELSE 'YES'::text END = ANY ('{YES,NO}'::text[])))
  • Buffers: shared hit=7851
2. 129.286 234.160 ↓ 4.8 626,712 1

Unique (cost=0.42..48,681.53 rows=131,566 width=20) (actual time=0.008..234.160 rows=626,712 loops=1)

  • Buffers: shared hit=7529
3. 104.874 104.874 ↑ 1.0 829,455 1

Index Only Scan using uk_structure_season on structure_season b (cost=0.42..44,534.25 rows=829,455 width=20) (actual time=0.007..104.874 rows=829,455 loops=1)

  • Heap Fetches: 373
  • Buffers: shared hit=7529
4. 0.033 0.462 ↓ 18.0 36 1

Hash (cost=345.64..345.64 rows=2 width=4,366) (actual time=0.462..0.462 rows=36 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 83kB
  • Buffers: shared hit=258
5. 0.249 0.429 ↓ 18.0 36 1

Bitmap Heap Scan on map_geometry c (cost=5.15..345.64 rows=2 width=4,366) (actual time=0.411..0.429 rows=36 loops=1)

  • Recheck Cond: ((geom IS NOT NULL) AND (geom && '01030000000100000005000000FFFFFFDFB01A48C05296DAF771D735C0FFFFFFDFB01A48C0FB72F793FAD135C0FFFFFF1FBF1748C0FB72F793FAD135C0FFFFFF1FBF1748C05296DAF771D735C0FFFFFFDFB01A48C05296DAF771D735C0'::geome (...)
  • Filter: ((id_map IS NOT NULL) AND (id_map = 342017))
  • Rows Removed by Filter: 304
  • Heap Blocks: exact=233
  • Buffers: shared hit=258
6. 0.180 0.180 ↓ 4.0 340 1

Bitmap Index Scan on gidx_map_geometry_temp_geom (cost=0.00..5.15 rows=86 width=0) (actual time=0.180..0.180 rows=340 loops=1)

  • Index Cond: ((geom IS NOT NULL) AND (geom && '01030000000100000005000000FFFFFFDFB01A48C05296DAF771D735C0FFFFFFDFB01A48C0FB72F793FAD135C0FFFFFF1FBF1748C0FB72F793FAD135C0FFFFFF1FBF1748C05296DAF771D735C0FFFFFFDFB01A48C05296DAF771D735C0'::g (...)
  • Buffers: shared hit=25
Planning time : 0.264 ms
Execution time : 308.472 ms