explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VcDP

Settings
# exclusive inclusive rows x rows loops node
1. 0.527 0.527 ↑ 1.8 204 1

Index Scan using trip_data_25_pkey on trip_data_25 (cost=0.56..8.58 rows=366 width=28) (actual time=0.037..0.527 rows=204 loops=1)

  • Index Cond: (((medallion)::text >= '50C1AEB304'::text) AND ((medallion)::text < '50C1AEB305'::text))
  • Filter: ((medallion)::text ~~ '50C1AEB304%'::text)
Planning time : 0.211 ms
Execution time : 0.592 ms