#	exclusive	inclusive	rows x	rows	loops	node
1.	0.248	397,984.530	↑ 2.1	96	1	→ HashAggregate (cost=45.860..49.860 rows=200 width=128) (actual time=397,984.480..397,984.530 rows=96 loops=1) Group Key: xray"two_yankee"seven1"echo_quebec"xray"two_yankee"seven2"echo_quebec"xray"two_yankee"six_four
2.	0.029	397,984.282	↑ 1.3	174	1	→ Append (cost=0.000..42.970 rows=231 width=116) (actual time=0.126..397,984.282 rows=174 loops=1)
3.	0.147	0.147	↑ 2.4	96	1	→ Seq Scan on romeo_india (cost=0.000..12.300 rows=230 width=116) (actual time=0.106..0.147 rows=96 loops=1)
4.	0.008	397,984.106	↓ 78.0	78	1	→ Subquery Scan on echo_seven (cost=29.450..29.510 rows=1 width=128) (actual time=397,983.775..397,984.106 rows=78 loops=1)
5.	0.327	397,984.098	↓ 78.0	78	1	→ GroupAggregate (cost=29.450..29.500 rows=1 width=160) (actual time=397,983.774..397,984.098 rows=78 loops=1) Group Key: quebec.seven1"sierra"seven2"sierra"six_four"sierra"charlie
6.	2.821	397,983.771	↓ 432.0	432	1	→ Sort (cost=29.450..29.450 rows=1 width=141) (actual time=397,983.759..397,983.771 rows=432 loops=1) Sort Key: quebec.seven1"sierra"seven2"sierra"six_four"sierra"charlie Sort Method: quicksort Memory: 85kB
7.	235,974.571	397,980.950	↓ 432.0	432	1	→ Nested Loop (cost=8.870..29.440 rows=1 width=141) (actual time=301.152..397,980.950 rows=432 loops=1) Join Filter: ((romeo_three.november"papa"november"alpha"golf_sierra"papa"golf_sierra"alpha"mike"papa"mike"alpha"delta"papa"delta"alpha"lima_india"papa"lima_india"alpha"lima_alpha"papa"lima_alpha"six_tango"india"two_lima"india")) Rows Removed by Join Filter: 766,938,732
8.	377.771	381.643	↓ 183,456.0	183,456	1	→ Hash Join (cost=8.450..21.630 rows=1 width=349) (actual time=3.759..381.643 rows=183,456 loops=1) Hash Cond: (quebec.uniform"golf_yankee"uniform")
9.	0.179	0.179	↑ 2.4	96	1	→ Seq Scan on romeo_india quebec (cost=0.000..12.300 rows=230 width=324) (actual time=0.034..0.179 rows=96 loops=1)
10.	0.957	3.693	↓ 4,184.0	4,184	1	→ Hash (cost=8.440..8.440 rows=1 width=33) (actual time=3.693..3.693 rows=4,184 loops=1) Buckets: 8,192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 362kB
11.	2.736	2.736	↓ 4,184.0	4,184	1	→ Index Scan using romeo_echo on three five_hotel (cost=0.420..8.440 rows=1 width=33) (actual time=0.141..2.736 rows=4,184 loops=1) Index Cond: (zulu" = 'five_lima'::uuid)
12.	161,624.736	161,624.736	↓ 4,181.0	4,181	183,456	→ Index Scan using yankee on two_oscar romeo_three (cost=0.420..7.790 rows=1 width=462) (actual time=0.012..0.881 rows=4,181 loops=183,456) Index Cond: (zulu" = 'five_lima'::uuid)

HashAggregate  (cost=45.860..49.860 rows=200 width=128) (actual time=397984.480..397984.530 rows=96 loops=1)
    Group Key: xray"two_yankee"seven1"echo_quebec"xray"two_yankee"seven2"echo_quebec"xray"two_yankee"six_four"
  ->  Append  (cost=0.000..42.970 rows=231 width=116) (actual time=0.126..397984.282 rows=174 loops=1)
        ->  Seq Scan on romeo_india  (cost=0.000..12.300 rows=230 width=116) (actual time=0.106..0.147 rows=96 loops=1)
        ->  Subquery Scan on echo_seven  (cost=29.450..29.510 rows=1 width=128) (actual time=397983.775..397984.106 rows=78 loops=1)
              ->  GroupAggregate  (cost=29.450..29.500 rows=1 width=160) (actual time=397983.774..397984.098 rows=78 loops=1)
                      Group Key: quebec.seven1"sierra"seven2"sierra"six_four"sierra"charlie"
                    ->  Sort  (cost=29.450..29.450 rows=1 width=141) (actual time=397983.759..397983.771 rows=432 loops=1)
                            Sort Key: quebec.seven1"sierra"seven2"sierra"six_four"sierra"charlie"
                            Sort Method: quicksort  Memory: 85kB
                          ->  Nested Loop  (cost=8.870..29.440 rows=1 width=141) (actual time=301.152..397980.950 rows=432 loops=1)
                                  Join Filter: ((romeo_three.november"papa"november"alpha"golf_sierra"papa"golf_sierra"alpha"mike"papa"mike"alpha"delta"papa"delta"alpha"lima_india"papa"lima_india"alpha"lima_alpha"papa"lima_alpha"six_tango"india"two_lima"india"))
                                  Rows Removed by Join Filter: 766938732
                                ->  Hash Join  (cost=8.450..21.630 rows=1 width=349) (actual time=3.759..381.643 rows=183456 loops=1)
                                        Hash Cond: (quebec.uniform"golf_yankee"uniform")
                                      ->  Seq Scan on romeo_india quebec  (cost=0.000..12.300 rows=230 width=324) (actual time=0.034..0.179 rows=96 loops=1)
                                      ->  Hash  (cost=8.440..8.440 rows=1 width=33) (actual time=3.693..3.693 rows=4184 loops=1)
                                              Buckets: 8192 (originally 1024)  Batches: 1 (originally 1)  Memory Usage: 362kB
                                            ->  Index Scan using romeo_echo on three five_hotel  (cost=0.420..8.440 rows=1 width=33) (actual time=0.141..2.736 rows=4184 loops=1)
                                                    Index Cond: (zulu" = 'five_lima'::uuid)
                                ->  Index Scan using yankee on two_oscar romeo_three  (cost=0.420..7.790 rows=1 width=462) (actual time=0.012..0.881 rows=4181 loops=183456)
                                        Index Cond: (zulu" = 'five_lima'::uuid)

Per node type stats

node type	count	sum of times	% of query
Append	1	0.029 ms	0.0 %
GroupAggregate	1	0.327 ms	0.0 %
Hash	1	0.957 ms	0.0 %
Hash Join	1	377.771 ms	0.1 %
HashAggregate	1	0.248 ms	0.0 %
Index Scan	2	161,627.472 ms	40.6 %
Nested Loop	1	235,974.571 ms	59.3 %
Seq Scan	2	0.326 ms	0.0 %
Sort	1	2.821 ms	0.0 %
Subquery Scan	1	0.008 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
romeo_india	2	0.326 ms	0.0 %
Seq Scan	2	0.326 ms	100.0 %
three	1	2.736 ms	0.0 %
Index Scan	1	2.736 ms	100.0 %
two_oscar	1	161,624.736 ms	40.6 %
Index Scan	1	161,624.736 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: t0De

Color mode:

Visible columns:

Optimization(s) for this plan:

Per node type stats

Per table stats