explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4XQw

Settings
# exclusive inclusive rows x rows loops node
1. 8.013 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. 5.285 47,793.322 ↑ 2,187.0 10 1

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. 1.490 47,788.037 ↑ 14.1 1,547 1

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. 47,743.904 47,743.904 ↑ 14.1 1,547 1

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. 24.195 42.643 ↑ 1.1 30,702 1

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: 65536 Batches: 1 Memory Usage: 15028kB
6. 18.448 18.448 ↑ 1.1 30,702 1

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)