explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IaS

Settings
# exclusive inclusive rows x rows loops node
1. 0.386 0.386 ↓ 2.0 2 1

Index Scan using geom_index on assignment_plan_shapes (cost=0.14..10.92 rows=1 width=51) (actual time=0.261..0.386 rows=2 loops=1)

  • Index Cond: (geom && '0104000020E6100000040000000101000000F374AE28258755C001A4367172E343400101000000EF71A609DB9655C0287CB60E0EE4434001010000003ACFD8976C3F56C0EDBAB722313D444001010000008C12F4177A2356C0E883656CE88A4440'::geometry)
  • Filter: ((job_id = '00DA0000000ckTHMAY7072G00005YSMElQAPa08A000001GboibIAB'::text) AND (geom && st_collect(geom, '0104000020E6100000040000000101000000F374AE28258755C001A4367172E343400101000000EF71A609DB9655C0287CB60E0EE4434001010000003ACFD8976C3F56C0EDBAB722313D444001010000008C12F4177A2356C0E883656CE88A4440'::geometry)) AND _st_intersects(geom, '0104000020E6100000040000000101000000F374AE28258755C001A4367172E343400101000000EF71A609DB9655C0287CB60E0EE4434001010000003ACFD8976C3F56C0EDBAB722313D444001010000008C12F4177A2356C0E883656CE88A4440'::geometry))
  • Rows Removed by Filter: 7
Planning time : 0.284 ms
Execution time : 1.065 ms