explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sClN

Settings
# exclusive inclusive rows x rows loops node
1. 163.182 477.680 ↓ 1.0 194,032 1

Hash Join (cost=1.52..49,599.45 rows=190,648 width=84) (actual time=0.204..477.680 rows=194,032 loops=1)

  • Hash Cond: (entity_has_override.id_country = brand_1.id_country)
2. 314.474 314.474 ↑ 1.0 1,143,744 1

Index Scan using country_entity_has_override_gid_idx on entity_has_override (cost=0.43..44,474.69 rows=1,143,889 width=84) (actual time=0.112..314.474 rows=1,143,744 loops=1)

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

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

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

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

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