explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6DqS

Settings
# exclusive inclusive rows x rows loops node
1. 36.935 36.935 ↓ 1,287.0 1,287 1

Seq Scan on patches patch (cost=0.00..172,435.30 rows=1 width=22) (actual time=3.717..36.935 rows=1,287 loops=1)

  • Filter: st_intersects('0102000020E61000000B000000D55E44DB31074E40DDB419A721263E40761C3F541A074E40703E75AC52263E4065ABCB2901074E40A9143B1A87263E40718DCF64FF064E40723788D68A263E40D55E44DB31074E40DDB419A721263E400569C6A2E9064E40A988D349B6263E400569C6A2E9064E40A988D349B6263E40C6FA062637084E404B901150E1303E40C6FA062637084E404B901150E1303E40DA58897956084E40A1D80A9A96303E40DA58897956084E40A1D80A9A96303E40'::geometry, st_geomfromewkb(pc_envelopeasbinary(pa)))
  • Rows Removed by Filter: 5577
  • Functions: 2
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 0.299 ms, Inlining 0.000 ms, Optimization 0.124 ms, Emission 1.635 ms, Total 2.058 ms
Execution time : 37.317 ms