explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vrf2

Settings
# exclusive inclusive rows x rows loops node
1. 0.130 3.416 ↑ 4.0 2 1

HashAggregate (cost=708,534.71..708,534.79 rows=8 width=18) (actual time=3.415..3.416 rows=2 loops=1)

  • Group Key: events.operation
2. 0.630 3.286 ↑ 587,413.9 241 1

Nested Loop (cost=249.10..700.98 rows=141,566,747 width=10) (actual time=1.391..3.286 rows=241 loops=1)

3. 0.226 1.446 ↓ 1.3 242 1

HashAggregate (cost=248.52..250.37 rows=185 width=25) (actual time=1.358..1.446 rows=242 loops=1)

  • Group Key: (((que_jobs.args -> 0) ->> 'event_id'::text))::integer
4. 1.220 1.220 ↑ 1.0 242 1

Index Only Scan using idx_que_jobs_p_key on que_jobs (cost=0.27..247.91 rows=242 width=25) (actual time=0.353..1.220 rows=242 loops=1)

  • Filter: (error_count > 0)
  • Rows Removed by Filter: 160
  • Heap Fetches: 272
5. 1.210 1.210 ↑ 1.0 1 242

Index Scan using events_pkey on events (cost=0.58..2.80 rows=1 width=14) (actual time=0.005..0.005 rows=1 loops=242)

  • Index Cond: (id = (((que_jobs.args -> 0) ->> 'event_id'::text))::integer)
Planning time : 0.425 ms
Execution time : 3.507 ms