explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OkIh

Settings
# exclusive inclusive rows x rows loops node
1. 0.022 0.089 ↑ 20.0 1 1

Hash Join (cost=36.42..77.59 rows=20 width=292) (actual time=0.087..0.089 rows=1 loops=1)

  • Hash Cond: (cattoys.toy_id = toys.id)
  • Join Filter: (((cats.color)::text = 'red'::text) OR ((toys.color)::text = 'red'::text))
  • Rows Removed by Join Filter: 5
2. 0.022 0.040 ↑ 340.0 6 1

Hash Join (cost=18.77..54.59 rows=2,040 width=120) (actual time=0.035..0.040 rows=6 loops=1)

  • Hash Cond: (cattoys.cat_id = cats.id)
3. 0.006 0.006 ↑ 340.0 6 1

Seq Scan on cattoys (cost=0.00..30.40 rows=2,040 width=8) (actual time=0.005..0.006 rows=6 loops=1)

4. 0.004 0.012 ↑ 78.0 5 1

Hash (cost=13.90..13.90 rows=390 width=120) (actual time=0.012..0.012 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
5. 0.008 0.008 ↑ 78.0 5 1

Seq Scan on cats (cost=0.00..13.90 rows=390 width=120) (actual time=0.006..0.008 rows=5 loops=1)

6. 0.007 0.027 ↑ 56.7 6 1

Hash (cost=13.40..13.40 rows=340 width=180) (actual time=0.027..0.027 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.020 0.020 ↑ 56.7 6 1

Seq Scan on toys (cost=0.00..13.40 rows=340 width=180) (actual time=0.017..0.020 rows=6 loops=1)

Planning time : 0.494 ms
Execution time : 0.469 ms