explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QS0H : NOT ANY

Settings
# exclusive inclusive rows x rows loops node
1. 1,746.001 6,631.448 ↑ 1.0 8 1

HashAggregate (cost=565,088.98..565,089.06 rows=8 width=16) (actual time=6,631.447..6,631.448 rows=8 loops=1)

  • Group Key: smartq_jobs_log.status
2. 2,871.721 4,885.447 ↑ 1.0 9,101,150 1

Nested Loop Semi Join (cost=0.43..519,583.23 rows=9,101,150 width=16) (actual time=0.093..4,885.447 rows=9,101,150 loops=1)

  • Join Filter: (smartq_jobs_log.job_id <> smartq_jobs.id)
  • Rows Removed by Join Filter: 2
3. 2,013.726 2,013.726 ↑ 1.0 9,101,150 1

Seq Scan on smartq_jobs_log (cost=0.00..245,616.50 rows=9,101,150 width=16) (actual time=0.025..2,013.726 rows=9,101,150 loops=1)

4. 0.000 0.000 ↑ 21,008.0 1 9,101,150

Materialize (cost=0.43..945.11 rows=21,008 width=8) (actual time=0.000..0.000 rows=1 loops=9,101,150)

5. 0.059 0.059 ↑ 10,504.0 2 1

Index Only Scan using idx_sj_user_id_cur_status on smartq_jobs (cost=0.43..840.07 rows=21,008 width=8) (actual time=0.054..0.059 rows=2 loops=1)

  • Index Cond: (user_id = 108)
  • Heap Fetches: 0