explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5xW8

Settings
# exclusive inclusive rows x rows loops node
1. 91.693 96.564 ↓ 11.4 11,396 1

Hash Join (cost=1.20..1,380.40 rows=999 width=162) (actual time=21.658..96.564 rows=11,396 loops=1)

  • Hash Cond: (ss.catalog_id = c.id)
2. 4.696 4.696 ↑ 1.0 14,545 1

Seq Scan on sessions ss (cost=0.00..563.79 rows=14,979 width=130) (actual time=0.013..4.696 rows=14,545 loops=1)

3. 0.005 0.175 ↑ 1.0 1 1

Hash (cost=1.19..1.19 rows=1 width=16) (actual time=0.175..0.175 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
4. 0.170 0.170 ↑ 1.0 1 1

Seq Scan on catalogs c (cost=0.00..1.19 rows=1 width=16) (actual time=0.161..0.170 rows=1 loops=1)

  • Filter: (code = 'kiehls-ca'::citext)
  • Rows Removed by Filter: 14
Planning time : 4.010 ms
Execution time : 99.268 ms