explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KyTL

Settings
# exclusive inclusive rows x rows loops node
1. 4.340 4.526 ↓ 0.0 0 1

Gather Merge (cost=122,069.86..122,074.29 rows=38 width=51) (actual time=3.414..4.526 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=107 dirtied=1
2. 0.024 0.186 ↓ 0.0 0 3 / 3

Sort (cost=121,069.84..121,069.88 rows=19 width=51) (actual time=0.186..0.186 rows=0 loops=3)

  • Sort Key: ti.day_num, ti.order_num
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
  • Worker 1: Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=107 dirtied=1
3. 0.040 0.162 ↓ 0.0 0 3 / 3

Hash Join (cost=12.00..121,069.43 rows=19 width=51) (actual time=0.162..0.162 rows=0 loops=3)

  • Hash Cond: (ti.timeofday_id = tl.timeofday_id)
  • Buffers: shared hit=79 dirtied=1
4. 0.017 0.034 ↓ 0.0 0 3 / 3

Hash Join (cost=8.45..121,065.62 rows=19 width=35) (actual time=0.033..0.034 rows=0 loops=3)

  • Hash Cond: (ti.template_id = t.template_id)
  • Buffers: shared hit=16 dirtied=1
  • -> Parallel Seq Scan on template_item ti (cost=0.00..111831.52 rows=3514452 width=39) (actual time=0.00
  • Buffers: shared hit=3
5. 0.017 0.017 ↓ 0.0 0 3 / 3

Hash (cost=8.44..8.44 rows=1 width=4) (actual time=0.016..0.017 rows=0 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
  • Buffers: shared hit=13 dirtied=1
  • -> Index Scan using template_class_index on template t (cost=0.42..8.44 rows=1 width=4) (actual t
  • Index Cond: (class_id = 1277605)
  • Buffers: shared hit=13 dirtied=1
6. 0.016 0.088 ↑ 1.0 31 3 / 3

Hash (cost=3.17..3.17 rows=31 width=27) (actual time=0.087..0.088 rows=31 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=6
7. 0.061 0.072 ↑ 1.0 31 3 / 3

Hash Join (cost=1.04..3.17 rows=31 width=27) (actual time=0.033..0.072 rows=31 loops=3)

  • Hash Cond: (tl.lang_id = l.lang_id)
  • Buffers: shared hit=6
  • -> Seq Scan on timeofday_lang tl (cost=0.00..1.62 rows=62 width=31) (actual time=0.008..0.022 row
  • Buffers: shared hit=3
8. 0.011 0.011 ↑ 1.0 1 3 / 3

Hash (cost=1.02..1.02 rows=1 width=4) (actual time=0.011..0.011 rows=1 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=3
  • -> Seq Scan on lang l (cost=0.00..1.02 rows=1 width=4) (actual time=0.005..0.006 rows=1 loo
  • Filter: (locale = 'en_US'::text)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=3
Planning time : 4.128 ms
Execution time : 4.630 ms