explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rRYn

Settings
# exclusive inclusive rows x rows loops node
1. 125,464.244 125,464.244 ↑ 19.2 4 1

Index Scan using transmission_log_requested_at_idx on transmission_log (cost=0.00..621,695.77 rows=77 width=648) (actual time=8,011.476..125,464.244 rows=4 loops=1)

  • Index Cond: (requested_at > '2019-01-14 00:00:00'::timestamp without time zone)
  • Filter: ((request_text)::text ~~ '%5000581%'::text)