explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BiU5

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 0.241 ↓ 2.0 2 1

Subquery Scan on tbl (cost=3.11..31.20 rows=1 width=77) (actual time=0.202..0.241 rows=2 loops=1)

  • Filter: ((tbl.dayp ->> 'day'::text) ~~* 'TUESDAY'::text)
  • Rows Removed by Filter: 2
2. 0.049 0.233 ↑ 225.0 4 1

Hash Join (cost=3.11..17.70 rows=900 width=45) (actual time=0.199..0.233 rows=4 loops=1)

  • Hash Cond: ((unnest(r.idpromos)) = p.id)
3.          

Initplan (for Hash Join)

4. 0.012 0.012 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=0) (actual time=0.012..0.012 rows=1 loops=1)

5. 0.019 0.019 ↑ 50.0 2 1

Index Scan using recetas_pkey on recetas r (cost=0.28..8.79 rows=100 width=25) (actual time=0.018..0.019 rows=2 loops=1)

  • Index Cond: (id = 764)
6. 0.006 0.153 ↓ 1.2 11 1

Hash (cost=2.70..2.70 rows=9 width=45) (actual time=0.153..0.153 rows=11 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 7kB
7. 0.147 0.147 ↓ 1.2 11 1

Seq Scan on promociones p (cost=0.00..2.70 rows=9 width=45) (actual time=0.031..0.147 rows=11 loops=1)

  • Filter: ((activo ~~* 'A'::text) AND (("position"((datos ->> 'promotionDays'::text), $0) > 0) OR (((datos ->> 'promotionDays'::text))::text ~~* 'ALLDAYS'::text)))
  • Rows Removed by Filter: 4
Planning time : 0.248 ms
Execution time : 0.293 ms