explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fjB3

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

Limit (cost=232.18..232.18 rows=1 width=84) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=232.18..249.82 rows=7,059 width=84) (actual rows= loops=)

  • Sort Key: bid.created_at DESC
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=23.65..196.88 rows=7,059 width=84) (actual rows= loops=)

  • Hash Cond: (bid.conversation_uuid = conversation.uuid)
4. 0.000 0.000 ↓ 0.0

Seq Scan on bid (cost=0.00..154.59 rows=7,059 width=68) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=14.83..14.83 rows=706 width=16) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on conversation (cost=0.00..14.83 rows=706 width=16) (actual rows= loops=)

  • Filter: (ad_id = 0)