explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3Krn

Settings
# exclusive inclusive rows x rows loops node
1. 196.912 527.177 ↓ 1.0 194,045 1

Hash Join (cost=1.52..49,503.80 rows=190,418 width=84) (actual time=0.159..527.177 rows=194,045 loops=1)

  • Hash Cond: (entity_has_override.id_country = brand_1.id_country)
2. 330.235 330.235 ↓ 1.0 1,143,821 1

Index Scan using country_entity_has_override_gid_idx on entity_has_override (cost=0.43..44,385.23 rows=1,142,508 width=84) (actual time=0.098..330.235 rows=1,143,821 loops=1)

  • Index Cond: (subltree((gid_entity)::ltree, 0, 2) = 'movie.movie'::ltree)
3. 0.004 0.030 ↑ 1.0 1 1

Hash (cost=1.07..1.07 rows=1 width=4) (actual time=0.030..0.030 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
4. 0.026 0.026 ↑ 1.0 1 1

Seq Scan on brand brand_1 (cost=0.00..1.07 rows=1 width=4) (actual time=0.024..0.026 rows=1 loops=1)

  • Filter: (id = 'AD'::bpchar)
  • Rows Removed by Filter: 5
Planning time : 1.871 ms
Execution time : 534.223 ms