explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jU1

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 2,302.628 ↑ 1.0 1 1

Limit (cost=766.88..766.89 rows=1 width=20) (actual time=2,302.626..2,302.628 rows=1 loops=1)

2. 0.014 2,302.624 ↑ 1.0 1 1

Sort (cost=766.88..766.89 rows=1 width=20) (actual time=2,302.624..2,302.624 rows=1 loops=1)

  • Sort Key: creation_date DESC
  • Sort Method: top-N heapsort Memory: 25kB
3. 2,302.610 2,302.610 ↓ 4.0 4 1

Index Scan using visitors_idx0 on visitors (cost=0.56..766.87 rows=1 width=20) (actual time=0.757..2,302.610 rows=4 loops=1)

  • Index Cond: (usr_id = '1000004875703'::bigint)
  • Filter: ((NOT web_platform) AND (date(now()) = date(creation_date)))
  • Rows Removed by Filter: 6909