explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Om96

Settings
# exclusive inclusive rows x rows loops node
1. 0.023 1,314.849 ↑ 1.0 10 1

Hash Right Join (cost=98,845.93..98,846.10 rows=10 width=12) (actual time=1,314.809..1,314.849 rows=10 loops=1)

  • Hash Cond: ((jc.jobstatuscode)::text = (js.jobstatuscode)::text)
  • Buffers: shared hit=21,314 read=3,231
  • I/O Timings: read=19.867
2.          

CTE jobcount

3. 0.000 1,314.802 ↑ 1.2 6 1

Finalize GroupAggregate (cost=98,842.93..98,844.71 rows=7 width=12) (actual time=1,314.780..1,314.802 rows=6 loops=1)

  • Group Key: j.jobstatuscode
  • Buffers: shared hit=21,313 read=3,231
  • I/O Timings: read=19.867
4. 9.810 1,314.857 ↓ 1.3 18 1

Gather Merge (cost=98,842.93..98,844.57 rows=14 width=12) (actual time=1,314.766..1,314.857 rows=18 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=60,102 read=11,834
  • I/O Timings: read=59.194
5. 0.034 1,305.047 ↑ 1.2 6 3 / 3

Sort (cost=97,842.91..97,842.93 rows=7 width=12) (actual time=1,305.044..1,305.047 rows=6 loops=3)

  • Sort Key: j.jobstatuscode
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
  • Worker 1: Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=60,102 read=11,834
  • I/O Timings: read=59.194
6. 160.579 1,305.013 ↑ 1.2 6 3 / 3

Partial HashAggregate (cost=97,842.74..97,842.81 rows=7 width=12) (actual time=1,305.010..1,305.013 rows=6 loops=3)

  • Group Key: j.jobstatuscode
  • Buffers: shared hit=60,086 read=11,834
  • I/O Timings: read=59.194
7. 1,144.434 1,144.434 ↑ 1.2 163,200 3 / 3

Parallel Seq Scan on job j (cost=0.00..96,837.93 rows=200,963 width=4) (actual time=13.010..1,144.434 rows=163,200 loops=3)

  • Filter: (((countrycode)::text = 'TH'::text) AND (((jobstartdatetime >= '2020-08-01 00:00:00'::timestamp without time zone) AND (jobst
  • Rows Removed by Filter: 449,035
  • Buffers: shared hit=60,086 read=11,834
  • I/O Timings: read=59.194
8. 1,314.811 1,314.811 ↑ 1.2 6 1

CTE Scan on jobcount jc (cost=0.00..0.14 rows=7 width=24) (actual time=1,314.784..1,314.811 rows=6 loops=1)

  • Buffers: shared hit=21,313 read=3,231
  • I/O Timings: read=19.867
9. 0.007 0.015 ↑ 1.0 10 1

Hash (cost=1.10..1.10 rows=10 width=4) (actual time=0.014..0.015 rows=10 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
10. 0.008 0.008 ↑ 1.0 10 1

Seq Scan on jobstatus js (cost=0.00..1.10 rows=10 width=4) (actual time=0.005..0.008 rows=10 loops=1)

  • Buffers: shared hit=1
Planning time : 0.949 ms
Execution time : 1,314.993 ms