explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SeTp

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

Limit (cost=1,126.42..1,126.45 rows=10 width=149) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=1,126.40..1,129.57 rows=1,270 width=149) (actual rows= loops=)

  • Sort Key: deck_hotness_index.hotness DESC
3. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=91.57..1,079.90 rows=1,270 width=149) (actual rows= loops=)

  • Hash Cond: (deck.author_id = account.id)
4. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=67.16..99.63 rows=1,270 width=94) (actual rows= loops=)

  • Hash Cond: (deck_hotness_index.deck_id = deck.id)
5. 0.000 0.000 ↓ 0.0

Seq Scan on deck_hotness_index (cost=0.00..28.83 rows=1,383 width=8) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=51.29..51.29 rows=1,270 width=90) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on deck (cost=0.00..51.29 rows=1,270 width=90) (actual rows= loops=)

  • Filter: (modified > '2019-10-01 12:00:00'::timestamp without time zone)
8. 0.000 0.000 ↓ 0.0

Hash (cost=15.85..15.85 rows=685 width=19) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on account (cost=0.00..15.85 rows=685 width=19) (actual rows= loops=)