explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bHPr

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.038 0.159 ↑ 20.5 2 1

Nested Loop (cost=10.78..54.03 rows=41 width=516) (actual time=0.146..0.159 rows=2 loops=1)

  • -> Index Scan using toys_pkey on toys (cost=0.14..0.18 rows=1 width=520) (actual time=0.013..
2. 0.087 0.121 ↑ 20.5 2 1

Hash Join (cost=10.64..46.50 rows=41 width=4) (actual time=0.114..0.121 rows=2 loops=1)

  • Hash Cond: (cattoys.cat_id = cats.id)
  • -> Seq Scan on cattoys (cost=0.00..30.40 rows=2040 width=8) (actual time=0.017..0.019 r
  • Index Cond: (id = cattoys.toy_id)
3. 0.034 0.034 ↑ 1.0 1 1

Hash (cost=10.62..10.62 rows=1 width=4) (actual time=0.034..0.034 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • -> Seq Scan on cats (cost=0.00..10.62 rows=1 width=4) (actual time=0.014..0.015 r
  • Filter: ((breed)::text = 'siamese'::text)
  • Rows Removed by Filter: 4