explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ivov

Settings
# exclusive inclusive rows x rows loops node
1. 3,567.737 16,657.862 ↓ 1.6 7,592,173 1

WindowAgg (cost=1,099,021.76..1,214,946.83 rows=4,637,003 width=13) (actual time=11,246.866..16,657.862 rows=7,592,173 loops=1)

2. 8,565.934 13,090.125 ↓ 1.6 7,592,173 1

Sort (cost=1,099,021.76..1,110,614.27 rows=4,637,003 width=12) (actual time=11,246.852..13,090.125 rows=7,592,173 loops=1)

  • Sort Key: detectable_id, captured_at
  • Sort Method: external merge Disk: 207824kB
3. 4,524.191 4,524.191 ↓ 1.6 7,592,173 1

Index Scan using detectionlog_captured_at_index on detectionlog (cost=0.57..427,101.14 rows=4,637,003 width=12) (actual time=379.356..4,524.191 rows=7,592,173 loops=1)

  • Index Cond: ((captured_at >= (now() - '1 mon'::interval)) AND (captured_at <= now()))
  • Filter: (camera_id = 63)
  • Rows Removed by Filter: 4579794
Planning time : 0.178 ms
Execution time : 16,950.451 ms