explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cpXj

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 4.828 ↑ 1.0 1 1

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

2. 1.671 4.825 ↑ 7,059.0 1 1

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

  • Sort Key: bid.created_at DESC
  • Sort Method: top-N heapsort Memory: 25kB
3. 2.327 3.154 ↑ 1.0 7,059 1

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

  • Hash Cond: (bid.conversation_uuid = conversation.uuid)
4. 0.559 0.559 ↑ 1.0 7,059 1

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

5. 0.140 0.268 ↑ 1.0 706 1

Hash (cost=14.83..14.83 rows=706 width=16) (actual time=0.267..0.268 rows=706 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 42kB
6. 0.128 0.128 ↑ 1.0 706 1

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

  • Filter: (ad_id = 0)