explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2RKa

Settings
# exclusive inclusive rows x rows loops node
1. 0.539 52.838 ↓ 1,841.0 1,841 1

Sort (cost=33.43..33.43 rows=1 width=30) (actual time=52.759..52.838 rows=1,841 loops=1)

  • Sort Key: morton_revert
  • Sort Method: quicksort Memory: 192kB
  • Buffers: shared hit=30058
2. 52.299 52.299 ↓ 1,841.0 1,841 1

Index Scan using patches_geometry_idx on patches patch (cost=0.15..33.42 rows=1 width=30) (actual time=0.232..52.299 rows=1,841 loops=1)

  • Index Cond: (st_geomfromewkb(pc_envelopeasbinary(pa)) && '0102000020E6100000170000003E22A64412074E40CBB9145795253E403239B5334C074E40C442AD69DE253E403E22A64412074E40CBB9145795253E40A9FB00A436094E402BC24D46952D3E40A9FB00A436094E402BC24D46952D3E40A9FB00A436094E402BC24D46952D3E40395FECBDF8084E40F5D901D7152F3E4088F6B182DF084E400DC7F319502F3E40344C6DA983084E400EBE30992A303E40A9FB00A436094E402BC24D46952D3E40C6FA062637084E404B901150E1303E40C6FA062637084E404B901150E1303E404012F6ED24084E40C498F4F752303E404012F6ED24084E40C498F4F752303E404012F6ED24084E40C498F4F752303E404012F6ED24084E40C498F4F752303E400569C6A2E9064E40A988D349B6263E40718DCF64FF064E40723788D68A263E4065ABCB2901074E40A9143B1A87263E40761C3F541A074E40703E75AC52263E400569C6A2E9064E40A988D349B6263E40793D98141F074E40A52E19C748263E40793D98141F074E40A52E19C748263E40'::geometry)
  • Filter: st_intersects('0102000020E6100000170000003E22A64412074E40CBB9145795253E403239B5334C074E40C442AD69DE253E403E22A64412074E40CBB9145795253E40A9FB00A436094E402BC24D46952D3E40A9FB00A436094E402BC24D46952D3E40A9FB00A436094E402BC24D46952D3E40395FECBDF8084E40F5D901D7152F3E4088F6B182DF084E400DC7F319502F3E40344C6DA983084E400EBE30992A303E40A9FB00A436094E402BC24D46952D3E40C6FA062637084E404B901150E1303E40C6FA062637084E404B901150E1303E404012F6ED24084E40C498F4F752303E404012F6ED24084E40C498F4F752303E404012F6ED24084E40C498F4F752303E404012F6ED24084E40C498F4F752303E400569C6A2E9064E40A988D349B6263E40718DCF64FF064E40723788D68A263E4065ABCB2901074E40A9143B1A87263E40761C3F541A074E40703E75AC52263E400569C6A2E9064E40A988D349B6263E40793D98141F074E40A52E19C748263E40793D98141F074E40A52E19C748263E40'::geometry, st_geomfromewkb(pc_envelopeasbinary(pa)))
  • Rows Removed by Filter: 5523
  • Buffers: shared hit=30058
Planning time : 0.136 ms
Execution time : 52.949 ms