psql:cits2.sql:35: NOTICE:  QUERY PLAN:

Unique  (cost=2395.17..2397.52 rows=12 width=52)
  ->  Sort  (cost=2395.17..2395.17 rows=117 width=52)
        ->  Append  (cost=1204.81..2391.15 rows=117 width=52)
                ->  Aggregate  (cost=1204.81..1228.04 rows=116 width=52)
                      ->  Group  (cost=1204.81..1210.62 rows=1161 width=52)
                            ->  Sort  (cost=1204.81..1204.81 rows=1161 width=52)
                                  ->  Hash Join  (cost=20.38..1145.68 rows=1161 width=52)
                                        ->  Seq Scan on tblcitsdialinday dd  (cost=0.00..1006.03 rows=2485 width=32)
                                        ->  Hash  (cost=18.10..18.10 rows=910 width=20)
                                              ->  Seq Scan on tblcitsddinumber dn  (cost=0.00..18.10 rows=910 width=20)
                ->  Aggregate  (cost=1163.10..1163.10 rows=1 width=40)
                      ->  Hash Join  (cost=20.38..1145.68 rows=1161 width=40)
                            ->  Seq Scan on tblcitsdialinday dd  (cost=0.00..1006.03 rows=2485 width=32)
                            ->  Hash  (cost=18.10..18.10 rows=910 width=8)
                                  ->  Seq Scan on tblcitsddinumber dn  (cost=0.00..18.10 rows=910 width=8)

EXPLAIN

psql:atn2.sql:35: NOTICE:  QUERY PLAN:

Unique  (cost=2239.48..2239.51 rows=0 width=52)
  ->  Sort  (cost=2239.48..2239.48 rows=1 width=52)
        ->  Append  (cost=1119.69..2239.47 rows=1 width=52)
                ->  Aggregate  (cost=1119.69..1119.77 rows=0 width=52)
                      ->  Group  (cost=1119.69..1119.71 rows=4 width=52)
                            ->  Sort  (cost=1119.69..1119.69 rows=4 width=52)
                                  ->  Nested Loop  (cost=0.00..1119.65 rows=4 width=52)
                                        ->  Seq Scan on tblatnnumber dn  (cost=0.00..10.03 rows=503 width=20)                                        ->  Index Scan using idxatndialinday04 on tblatndialinday dd  (cost=0.00..2.19 rows=1 width=32)
                ->  Aggregate  (cost=1119.71..1119.71 rows=1 width=40)
                      ->  Nested Loop  (cost=0.00..1119.65 rows=4 width=40)
                            ->  Seq Scan on tblatnnumber dn  (cost=0.00..10.03 rows=503 width=8)
                            ->  Index Scan using idxatndialinday04 on tblatndialinday dd  (cost=0.00..2.19 rows=1 width=32)

EXPLAIN