explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4XQw

Settings
# exclusive inclusive rows x rows loops node
1. 23,904.674 47,801.335 ↑ 2,187.0 10 1

Gather (cost=26,487.69..28,893.39 rows=21,870 width=452) (actual time=47,797.400..47,801.335 rows=10 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
  • Single Copy: true
2. 2.643 23,896.661 ↑ 2,187.0 10 1 / 2

HashAggregate (cost=25,487.69..25,706.39 rows=21,870 width=452) (actual time=47,793.200..47,793.322 rows=10 loops=1)

  • Group Key: ct.micro_task_id, mt.meta_data
3. 0.745 23,894.018 ↑ 14.1 1,547 1 / 2

Hash Join (cost=5,024.89..25,378.34 rows=21,870 width=452) (actual time=42.973..47,788.037 rows=1,547 loops=1)

  • Hash Cond: (ct.micro_task_id = mt.id)
4. 23,871.952 23,871.952 ↑ 14.1 1,547 1 / 2

Index Scan using cache_table_processed_index on cache_table ct (cost=0.57..20,296.59 rows=21,870 width=16) (actual time=0.032..47,743.904 rows=1,547 loops=1)

  • Index Cond: (processed = 2)
5. 12.098 21.322 ↑ 1.1 30,702 1 / 2

Hash (cost=4,609.70..4,609.70 rows=33,170 width=452) (actual time=42.642..42.643 rows=30,702 loops=1)

  • Buckets: 65,536 Batches: 1 Memory Usage: 15,028kB
6. 9.224 9.224 ↑ 1.1 30,702 1 / 2

Seq Scan on micro_tasks mt (cost=0.00..4,609.70 rows=33,170 width=452) (actual time=0.018..18.448 rows=30,702 loops=1)