explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BJaA

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 137.123 ↑ 1.0 1 1

Limit (cost=4.67..4.68 rows=1 width=852) (actual time=137.119..137.123 rows=1 loops=1)

2. 0.092 137.118 ↑ 1.0 1 1

LockRows (cost=4.67..4.68 rows=1 width=852) (actual time=137.117..137.118 rows=1 loops=1)

3. 81.807 137.026 ↓ 3.0 3 1

Sort (cost=4.67..4.67 rows=1 width=852) (actual time=137.023..137.026 rows=3 loops=1)

  • Sort Key: due_at
  • Sort Method: external sort Disk: 8000kB
4. 55.219 55.219 ↓ 9,978.0 9,978 1

Index Scan using events_started_at_idx on events (cost=0.43..4.66 rows=1 width=852) (actual time=0.017..55.219 rows=9,978 loops=1)

  • Index Cond: (started_at IS NULL)
  • Filter: ((deleted_at IS NULL) AND (due_at < now()) AND (due_at > (now() - '3 days'::interval)))
  • Rows Removed by Filter: 7
Planning time : 0.771 ms
Execution time : 139.050 ms