explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5uno

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

Hash Join (cost=214.560..387.690 rows=1 width=76) (actual time=7.052..7.052 rows=1 loops=1)

  • Hash Cond: (five.seven = (alpha_four(uniform.seven)))
  • -> 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.550..214.550 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: (uniform.yankee = papa.juliet)
  • -> 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: (alpha_golf = 0)