explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iYiX

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

Index Scan using transmission_log_driver_co_num_driver_num_requested_at_idx on transmission_log (cost=0.00..340.45 rows=1 width=648) (actual time=6.021..13.272 rows=2 loops=1)

  • Index Cond: ((driver_co_num = 7) AND (driver_num = 873) AND (requested_at > '2019-01-14 09:02:11'::timestamp without time zone))
  • Filter: ((request_text)::text ~~ '%5000581%'::text)