explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ouzO

Settings
# exclusive inclusive rows x rows loops node
1. 0.764 4.568 ↑ 1.0 1 1

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

  • Hash Cond: (outer_bid.created_at = (max(bid.created_at)))
2. 0.509 0.509 ↑ 1.0 7,059 1

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

3. 0.004 3.295 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
4. 0.481 3.291 ↑ 1.0 1 1

Aggregate (cost=214.53..214.54 rows=1 width=8) (actual time=3.291..3.291 rows=1 loops=1)

5. 2.029 2.810 ↑ 1.0 7,059 1

Hash Join (cost=23.65..196.88 rows=7,059 width=8) (actual time=0.232..2.810 rows=7,059 loops=1)

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

Seq Scan on bid (cost=0.00..154.59 rows=7,059 width=24) (actual time=0.005..0.560 rows=7,059 loops=1)

7. 0.108 0.221 ↑ 1.0 706 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 42kB
8. 0.113 0.113 ↑ 1.0 706 1

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

  • Filter: (ad_id = 0)