explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1vT7

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 6,422.030 ↑ 1.0 1 1

Limit (cost=54,603.71..54,603.71 rows=1 width=46) (actual time=6,422.030..6,422.030 rows=1 loops=1)

2. 4.808 6,422.028 ↑ 6,915.0 1 1

Sort (cost=54,603.71..54,621.00 rows=6,915 width=46) (actual time=6,422.028..6,422.028 rows=1 loops=1)

  • Sort Key: generated_at DESC
  • Sort Method: top-N heapsort Memory: 25kB
3. 6,417.220 6,417.220 ↓ 2.1 14,761 1

Index Scan using controller_event_log_controller_id_idx on controller_event_log cl (cost=0.56..54,569.14 rows=6,915 width=46) (actual time=0.861..6,417.220 rows=14,761 loops=1)

  • Index Cond: (controller_id = 151)
  • Filter: ((topic)::text = 'gps'::text)
  • Rows Removed by Filter: 27165