explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lmRM

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=10.78..54.03 rows=41 width=516) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Join (cost=10.64..46.50 rows=41 width=4) (actual rows= loops=)

  • Hash Cond: (cattoys.cat_id = cats.id)
3. 0.000 0.000 ↓ 0.0

Seq Scan on cattoys (cost=0.00..30.40 rows=2,040 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

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

5. 0.000 0.000 ↓ 0.0

Seq Scan on cats (cost=0.00..10.62 rows=1 width=4) (actual rows= loops=)

  • Filter: ((breed)::text = 'siamese'::text)
6. 0.000 0.000 ↓ 0.0

Index Scan using toys_pkey on toys (cost=0.14..0.18 rows=1 width=520) (actual rows= loops=)

  • Index Cond: (id = cattoys.toy_id)