explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4281

Settings
# exclusive inclusive rows x rows loops node
1. 0.752 17,655.265 ↑ 1.0 1 1

Aggregate (cost=1,910,575.95..1,910,575.96 rows=1 width=8) (actual time=17,655.265..17,655.265 rows=1 loops=1)

2. 17,654.513 17,654.513 ↑ 1.3 1,642 1

Index Scan using driver_dispatch_dispatch_ack_at_index on driver_dispatch (cost=0.57..1,910,570.61 rows=2,136 width=0) (actual time=6,668.876..17,654.513 rows=1,642 loops=1)

  • Index Cond: (dispatch_ack_at IS NOT NULL)
  • Filter: ((inserted_at > '2018-09-25'::date) AND (driver_id = 145503))
  • Rows Removed by Filter: 30757297