explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fG2A

Settings
# exclusive inclusive rows x rows loops node
1. 1.641 7.052 ↑ 1.0 1 1

Hash Join (cost=214.56..387.69 rows=1 width=76) (actual time=7.052..7.052 rows=1 loops=1)

  • Hash Cond: (outer_bid.created_at = (max(bid.created_at)))
  • -> Seq Scan on bid outer_bid (cost=0.00..154.59 rows=7059 width=68) (actual time=0.024..0.6
2. 5.411 5.411 ↑ 1.0 1 1

Hash (cost=214.55..214.55 rows=1 width=8) (actual time=5.411..5.411 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • -> Aggregate (cost=214.53..214.54 rows=1 width=8) (actual time=5.408..5.408 rows=1 lo
  • -> Hash Join (cost=23.65..196.88 rows=7059 width=8) (actual time=0.443..4.546 r
  • Hash Cond: (bid.conversation_uuid = conversation.uuid)
  • -> Seq Scan on bid (cost=0.00..154.59 rows=7059 width=24) (actual time=0.
  • -> Hash (cost=14.83..14.83 rows=706 width=16) (actual time=0.424..0.425 r
  • Buckets: 1024 Batches: 1 Memory Usage: 42kB
  • -> Seq Scan on conversation (cost=0.00..14.83 rows=706 width=16) (a
  • Filter: (ad_id = 0)