explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DftE

Settings
# exclusive inclusive rows x rows loops node
1. 0.543 4.105 ↓ 3.5 14 1

Limit (cost=11.43..24.35 rows=4 width=346) (actual time=2.862..4.105 rows=14 loops=1)

2. 0.556 3.562 ↓ 3.5 14 1

Hash Join (cost=11.43..24.35 rows=4 width=346) (actual time=2.837..3.562 rows=14 loops=1)

  • Hash Cond: ((tag.id)::text = (product_tag.tag_id)::text)
3. 1.340 1.340 ↑ 8.8 24 1

Seq Scan on tag (cost=0.00..12.10 rows=210 width=346) (actual time=1.050..1.340 rows=24 loops=1)

4. 0.209 1.666 ↓ 3.5 14 1

Hash (cost=11.38..11.38 rows=4 width=338) (actual time=1.657..1.666 rows=14 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
5. 1.457 1.457 ↓ 3.5 14 1

Seq Scan on product_tag (cost=0.00..11.38 rows=4 width=338) (actual time=1.114..1.457 rows=14 loops=1)

  • Filter: ((tag_id)::text ~~* '%seg%'::text)
  • Rows Removed by Filter: 23
Planning time : 20.133 ms
Execution time : 4.471 ms