explain.depesz.com

PostgreSQL's explain analyze made readable

Result: t0De

Settings

Optimization(s) for this plan:

# 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: 766938732
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: 8192 (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)