explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2uKO

Settings
# exclusive inclusive rows x rows loops node
1. 1.210 4.812 ↓ 1.0 935 1

Sort (cost=1,353.03..1,355.36 rows=934 width=972) (actual time=4.624..4.812 rows=935 loops=1)

  • Sort Key: contents.appear_at
  • Sort Method: quicksort Memory: 945kB
2. 0.692 3.602 ↓ 1.0 935 1

Hash Left Join (cost=61.33..1,306.95 rows=934 width=972) (actual time=0.389..3.602 rows=935 loops=1)

  • Hash Cond: (contents.id = ucc.content_id)
3. 2.541 2.541 ↓ 1.0 935 1

Seq Scan on contents (cost=0.00..1,243.16 rows=934 width=913) (actual time=0.009..2.541 rows=935 loops=1)

  • Filter: (project_id = 279)
  • Rows Removed by Filter: 9408
4. 0.121 0.369 ↓ 1.1 323 1

Hash (cost=57.50..57.50 rows=307 width=67) (actual time=0.368..0.369 rows=323 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 39kB
5. 0.219 0.248 ↓ 1.1 323 1

Bitmap Heap Scan on user_content_configs ucc (cost=10.66..57.50 rows=307 width=67) (actual time=0.043..0.248 rows=323 loops=1)

  • Recheck Cond: (user_id = 306)
  • Heap Blocks: exact=43
6. 0.029 0.029 ↓ 1.3 414 1

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

  • Index Cond: (user_id = 306)
Planning time : 0.346 ms
Execution time : 5.033 ms