explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EcJw

Settings
# exclusive inclusive rows x rows loops node
1. 973.368 2,073.982 ↓ 1.8 1,086,760 1

Nested Loop (cost=88.51..76,250.94 rows=590,222 width=1,334) (actual time=2.016..2,073.982 rows=1,086,760 loops=1)

2. 0.104 0.104 ↑ 1.0 5 1

Index Scan using jobs_pkey on jobs ze_jobs (cost=0.43..33.95 rows=5 width=667) (actual time=0.015..0.104 rows=5 loops=1)

  • Index Cond: (id = ANY ('{4906,4975,4970,5015,5075}'::integer[]))
3. 872.835 1,100.510 ↓ 47.3 217,352 5

Bitmap Heap Scan on jobs jobs_counter (cost=88.08..15,197.40 rows=4,600 width=667) (actual time=66.875..220.102 rows=217,352 loops=5)

  • Recheck Cond: (user_id = ze_jobs.user_id)
  • Heap Blocks: exact=331002
4. 227.675 227.675 ↓ 47.3 217,352 5

Bitmap Index Scan on index_jobs_on_user_id_status (cost=0.00..86.93 rows=4,600 width=0) (actual time=45.535..45.535 rows=217,352 loops=5)

  • Index Cond: (user_id = ze_jobs.user_id)
Planning time : 69.828 ms
Execution time : 2,120.928 ms