explain.depesz.com

PostgreSQL's explain analyze made readable

Result: H25Q

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

XN Limit (cost=1,000,000,010,565.83..1,000,000,010,569.83 rows=100 width=98) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

XN Window (cost=1,000,000,010,565.83..1,000,000,014,121.23 rows=88,885 width=98) (actual rows= loops=)

  • Partition: story_id
  • Order: story_id, chapter_number
3. 0.000 0.000 ↓ 0.0

XN Sort (cost=1,000,000,010,565.83..1,000,000,010,788.04 rows=88,885 width=98) (actual rows= loops=)

  • Sort Key: story_id, chapter_number
4. 0.000 0.000 ↓ 0.0

XN Network (cost=0.00..3,259.63 rows=88,885 width=98) (actual rows= loops=)

  • Distribute
5. 0.000 0.000 ↓ 0.0

XN Seq Scan on chapters ch (cost=0.00..3,259.63 rows=88,885 width=98) (actual rows= loops=)

  • Filter: (((status)::text = 'public'::text) AND (deleted_at IS NULL) AND (words_count > 0))