explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XzZR

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 6.098 ↓ 0.0 0 1

Limit (cost=34.02..34.03 rows=1 width=1,835) (actual time=6.098..6.098 rows=0 loops=1)

2. 0.047 6.097 ↓ 0.0 0 1

Sort (cost=34.02..34.03 rows=1 width=1,835) (actual time=6.097..6.097 rows=0 loops=1)

  • Sort Key: jobs.id DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.001 6.050 ↓ 0.0 0 1

Nested Loop (cost=1.12..34.01 rows=1 width=1,835) (actual time=6.050..6.050 rows=0 loops=1)

4. 6.049 6.049 ↓ 0.0 0 1

Index Scan using index_jobs_on_job_spec_id_and_job_spec_type_and_created_at on jobs (cost=0.56..2.79 rows=1 width=1,314) (actual time=6.049..6.049 rows=0 loops=1)

  • Index Cond: ((job_spec_id = 2,311,071) AND ((job_spec_type)::text = 'Release'::text) AND (created_at >= '2020-09-13 15:04:32.851298'::timestamp without time zone))
  • Filter: (((state)::text <> 'finished'::text) AND ((worker_type)::text = 'HideExt'::text))
  • Rows Removed by Filter: 342
5. 0.000 0.000 ↓ 0.0 0

Index Scan using index_sessions_on_job_id on sessions (cost=0.56..31.21 rows=1 width=521) (never executed)

  • Index Cond: (job_id = jobs.id)
  • Filter: ((name)::text = ANY ('{pv38p01ls-quge10133001.ls.apple.com,pv38p01ls-zteb10110901.ls.apple.com,pv38p01ls-zteb10111001.ls.apple.com,pv38p01ls-zteb10111201.ls.apple.com,pv38p01ls-zteb10111301.ls.apple.com,pv38p01ls-zteb10111501.ls.apple.com,pv38p01ls-zteb10111601.ls.apple.com,pv38p01ls-zteb10111801.ls.apple.com,pv38p01ls-zteb10111901.ls.apple.com,pv38p01ls-zteb10112001.ls.apple.com,pv38p01ls-zteb10112101.ls.apple.com,pv38p01ls-zteb10112201.ls.apple.com,pv38p01ls-zteb10120801.ls.apple.com,pv38p01ls-zteb10120901.ls.apple.com,pv38p01ls-zteb10121001.ls.apple.com,pv38p01ls-zteb10121101.ls.apple.com,pv38p01ls-zteb10121201.ls.apple.com,pv38p01ls-zteb10121301.ls.apple.com,pv38p01ls-zteb10121401.ls.apple.com,pv38p01ls-zteb10121501.ls.apple.com,pv38p01ls-zteb10121601.ls.apple.com,pv38p01ls-zteb10121701.ls.apple.com,pv38p01ls-zteb10121801.ls.apple.com,pv38p01ls-zteb10121901.ls.apple.com,pv38p01ls-zteb10122001.ls.apple.com,pv38p01ls-zteb10122101.ls.apple.com,pv38p01ls-zteb10122201.ls.apple.com,pv38p01ls-zteb10130701.ls.apple.com,pv38p01ls-zteb10130801.ls.apple.com,pv38p01ls-zteb10130901.ls.apple.com,pv38p01ls-zteb10131001.ls.apple.com,pv38p01ls-zteb10131101.ls.apple.com,pv38p01ls-zteb10131201.ls.apple.com,pv38p01ls-zteb10131301.ls.apple.com,pv38p01ls-zteb10131401.ls.apple.com,pv38p01ls-zteb10131501.ls.apple.com,pv38p01ls-zteb10131601.ls.apple.com,pv38p01ls-zteb10131701.ls.apple.com,pv38p01ls-zteb10131801.ls.apple.com,pv38p01ls-zteb10131901.ls.apple.com,pv38p01ls-zteb10132001.ls.apple.com,pv38p01ls-zteb10132101.ls.apple.com}'::text[]))
Planning time : 4,282.599 ms
Execution time : 6.244 ms