explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BROm

Settings
# exclusive inclusive rows x rows loops node
1. 0.062 4,420.190 ↑ 1.0 101 1

Limit (cost=0.57..338.21 rows=101 width=125) (actual time=503.719..4,420.190 rows=101 loops=1)

2. 4,420.128 4,420.128 ↑ 458.0 101 1

Index Scan using "Hack by Berge to solve perf issues 2019-09-10 FIXME!" on controller_event_log "ControllerEventLog" (cost=0.57..154,632.70 rows=46,256 width=125) (actual time=503.718..4,420.128 rows=101 loops=1)

  • Index Cond: (controller_id = 4347)
Planning time : 0.159 ms
Execution time : 4,420.246 ms