explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WUkb

Settings
# exclusive inclusive rows x rows loops node
1. 0.147 672.952 ↑ 1.0 5 1

Seq Scan on country co (cost=0.00..99,489.25 rows=5 width=30) (actual time=161.458..672.952 rows=5 loops=1)

  • Filter: (abrv = ANY ('{Cz,Sk,Pl,Hu,Hr}'::bpchar[]))
  • Rows Removed by Filter: 96
2.          

SubPlan (forSeq Scan)

3. 3.985 672.035 ↑ 1.0 1 5

Aggregate (cost=19,877.76..19,877.77 rows=1 width=8) (actual time=134.407..134.407 rows=1 loops=5)

4. 668.050 668.050 ↑ 1.0 9,901 5

Seq Scan on customer cu (cost=0.00..19,853.01 rows=9,901 width=0) (actual time=0.019..133.610 rows=9,901 loops=5)

  • Filter: (countryid = co.id)
  • Rows Removed by Filter: 990100
5. 0.130 0.770 ↑ 1.0 1 5

Aggregate (cost=19.54..19.55 rows=1 width=8) (actual time=0.154..0.154 rows=1 loops=5)

6. 0.640 0.640 ↑ 1.1 9 5

Seq Scan on branch br (cost=0.00..19.51 rows=10 width=0) (actual time=0.023..0.128 rows=9 loops=5)

  • Filter: (countryid = co.id)
  • Rows Removed by Filter: 992