explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qvEr

Settings
# exclusive inclusive rows x rows loops node
1. 13.477 40.196 ↓ 1.7 10,341 1

Gather Merge (cost=5,231.08..5,930.05 rows=6,078 width=972) (actual time=29.016..40.196 rows=10,341 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 12.621 26.719 ↑ 1.2 5,170 2 / 2

Sort (cost=4,231.07..4,246.26 rows=6,078 width=972) (actual time=24.998..26.719 rows=5,170 loops=2)

  • Sort Key: contents.appear_at
  • Sort Method: external merge Disk: 2744kB
  • Worker 0: Sort Method: quicksort Memory: 3111kB
3. 11.958 14.098 ↑ 1.2 5,170 2 / 2

Hash Left Join (cost=61.33..1,252.08 rows=6,078 width=972) (actual time=0.395..14.098 rows=5,170 loops=2)

  • Hash Cond: (contents.id = ucc.content_id)
4. 1.786 1.786 ↑ 1.2 5,170 2 / 2

Parallel Seq Scan on contents (cost=0.00..1,174.78 rows=6,078 width=913) (actual time=0.005..1.786 rows=5,170 loops=2)

5. 0.120 0.354 ↓ 1.1 323 2 / 2

Hash (cost=57.50..57.50 rows=307 width=67) (actual time=0.354..0.354 rows=323 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 39kB
6. 0.196 0.234 ↓ 1.1 323 2 / 2

Bitmap Heap Scan on user_content_configs ucc (cost=10.66..57.50 rows=307 width=67) (actual time=0.052..0.234 rows=323 loops=2)

  • Recheck Cond: (user_id = 306)
  • Heap Blocks: exact=43
7. 0.038 0.038 ↓ 1.3 414 2 / 2

Bitmap Index Scan on index_user_content_configs_on_user_id (cost=0.00..10.58 rows=307 width=0) (actual time=0.038..0.038 rows=414 loops=2)

  • Index Cond: (user_id = 306)
Planning time : 0.313 ms
Execution time : 42.690 ms