explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vY3s : 1

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 0.216 ↑ 1.0 32 1

Limit (cost=0.56..53.77 rows=32 width=698) (actual time=0.032..0.216 rows=32 loops=1)

  • Output: posts.id, posts.category_id, posts.created_at, posts.author_id, posts.title, posts.body, posts.price, posts.region_id, posts.images, posts.contacts, posts.options, posts.published, posts.sold, posts.views, posts.old_type, posts.old_id, posts.risen_at, regions_1.id, regions_1.parent_id, regions_1.name, regions_1.published, regions_1.tree_id, regions_1.lft, regions_1.rgt, regions_1.level, posts.created_at
  • Buffers: shared hit=94
2. 0.027 0.206 ↑ 3,865.3 32 1

Nested Loop Left Join (cost=0.56..205,661.10 rows=123,689 width=698) (actual time=0.031..0.206 rows=32 loops=1)

  • Output: posts.id, posts.category_id, posts.created_at, posts.author_id, posts.title, posts.body, posts.price, posts.region_id, posts.images, posts.contacts, posts.options, posts.published, posts.sold, posts.views, posts.old_type, posts.old_id, posts.risen_at, regions_1.id, regions_1.parent_id, regions_1.name, regions_1.published, regions_1.tree_id, regions_1.lft, regions_1.rgt, regions_1.level, posts.created_at
  • Inner Unique: true
  • Buffers: shared hit=94
3. 0.115 0.115 ↑ 3,865.3 32 1

Index Scan using ix_board_posts_created_at on board.posts (cost=0.42..185,878.74 rows=123,689 width=648) (actual time=0.022..0.115 rows=32 loops=1)

  • Output: posts.id, posts.category_id, posts.created_at, posts.author_id, posts.title, posts.body, posts.price, posts.region_id, posts.images, posts.contacts, posts.options, posts.published, posts.sold, posts.views, posts.old_type, posts.old_id, posts.risen_at
  • Filter: (posts.published AND (posts.category_id = ANY ('{6,5,10,11,2,3,4,12,13,17,14,37,18,16,9,23,19,24,25,26,45,27,28,29,46,47,30,31,21,38,39,40,41,42,43,44,49,7,48,51,52,50,8,32,22,34,56,57,54,15,1,55,58,59,33,35,20,36,53,60,67,74,78,75,79,76,80,68,69,70,71,61,62,63,64,73,77,65,66,72,81}'::integer[])))
  • Rows Removed by Filter: 6
  • Buffers: shared hit=30
4. 0.064 0.064 ↑ 1.0 1 32

Index Scan using regions_pkey on board.regions regions_1 (cost=0.14..0.16 rows=1 width=42) (actual time=0.002..0.002 rows=1 loops=32)

  • Output: regions_1.id, regions_1.parent_id, regions_1.name, regions_1.published, regions_1.tree_id, regions_1.lft, regions_1.rgt, regions_1.level
  • Index Cond: (regions_1.id = posts.region_id)
  • Buffers: shared hit=64
Planning time : 0.712 ms
Execution time : 0.315 ms