explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QaCG

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

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

  • Filter: st_intersects('0102000020E61000000B000000D55E44DB31074E40DDB419A721263E40761C3F541A074E40703E75AC52263E4065ABCB2901074E40A9143B1A87263E40718DCF64FF064E40723788D68A263E40D55E44DB31074E40DDB419A721263E400569C6A2E9064E40A988D349B6263E400569C6A2E9064E40A988D349B6263E40C6FA062637084E404B901150E1303E40C6FA062637084E404B901150E1303E40DA58897956084E40A1D80A9A96303E40DA58897956084E40A1D80A9A96303E40'::geometry, st_geomfromewkb(pc_envelopeasbinary(pa)))JIT:
  • Functions: 2
  • Options: Inlining false, Optimization false, Expressions true, Deforming true