explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Hhiq

Settings
# exclusive inclusive rows x rows loops node
1. 0.162 479.068 ↑ 2.1 96 1

GroupAggregate (cost=54,434.300..54,441.770 rows=200 width=128) (actual time=478.943..479.068 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.596 478.906 ↑ 1.3 180 1

Sort (cost=54,434.300..54,434.880 rows=231 width=116) (actual time=478.900..478.906 rows=180 loops=1)

  • Sort Key: xray"two_yankee"seven1"echo_quebec"xray"two_yankee"seven2"echo_quebec"xray"two_yankee"six_four
  • Sort Method: quicksort Memory: 46kB
3. 0.010 478.310 ↑ 1.3 180 1

Append (cost=0.000..54,425.230 rows=231 width=116) (actual time=0.013..478.310 rows=180 loops=1)

4. 0.024 0.024 ↑ 2.4 96 1

Seq Scan on romeo_india (cost=0.000..12.300 rows=230 width=116) (actual time=0.012..0.024 rows=96 loops=1)

5. 0.008 478.276 ↓ 84.0 84 1

Subquery Scan on echo_seven (cost=54,411.710..54,411.780 rows=1 width=128) (actual time=476.627..478.276 rows=84 loops=1)

6. 1.595 478.268 ↓ 84.0 84 1

GroupAggregate (cost=54,411.710..54,411.770 rows=1 width=160) (actual time=476.625..478.268 rows=84 loops=1)

  • Group Key: quebec.seven1"sierra"seven2"sierra"six_four"sierra"charlie
7. 6.675 476.673 ↓ 2,790.0 2,790 1

Sort (cost=54,411.710..54,411.720 rows=1 width=141) (actual time=476.592..476.673 rows=2,790 loops=1)

  • Sort Key: quebec.seven1"sierra"seven2"sierra"six_four"sierra"charlie
  • Sort Method: quicksort Memory: 489kB
8. 428.500 469.998 ↓ 2,790.0 2,790 1

Hash Join (cost=1,732.210..54,411.700 rows=1 width=141) (actual time=14.700..469.998 rows=2,790 loops=1)

  • Hash Cond: (five.uniform"alpha_seven"uniform")
  • Join Filter: ((romeo_three.november"papa"november"alpha_two"golf_sierra"papa"golf_sierra"alpha_two"mike_papa"papa"mike_papa"alpha_two"delta"papa"delta"alpha_two"lima_india"papa"lima_india"alpha_two"lima_alpha"papa"lima_alpha"))
  • Rows Removed by Join Filter: 2495034
9. 0.000 41.438 ↓ 11.7 26,019 1

Gather (cost=1,717.030..54,263.160 rows=2,223 width=463) (actual time=12.017..41.438 rows=26,019 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
10. 36.067 41.519 ↓ 9.4 8,673 3

Nested Loop (cost=717.030..53,040.860 rows=926 width=463) (actual time=3.596..41.519 rows=8,673 loops=3)

11. 0.000 5.449 ↑ 1.3 8,673 3

Parallel Bitmap Heap Scan on mike_zulu five (cost=716.610..10,109.210 rows=11,408 width=33) (actual time=3.530..5.449 rows=8,673 loops=3)

  • Recheck Cond: (zulu" = 'six_bravo'::uuid)
  • Heap Blocks: exact=1294
12. 6.106 6.106 ↓ 2.8 76,712 1

Bitmap Index Scan on romeo_echo (cost=0.000..709.760 rows=27,379 width=0) (actual time=6.106..6.106 rows=76,712 loops=1)

  • Index Cond: (zulu" = 'six_bravo'::uuid)
13. 0.003 0.003 ↑ 1.0 1 26,019

Index Scan using whiskey on two_oscar romeo_three (cost=0.420..3.760 rows=1 width=462) (actual time=0.003..0.003 rows=1 loops=26,019)

  • Index Cond: (india"golf_yankee"india")
  • Filter: (zulu" = 'six_bravo'::uuid)
14. 0.033 0.060 ↑ 2.4 96 1

Hash (cost=12.300..12.300 rows=230 width=324) (actual time=0.060..0.060 rows=96 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 22kB
15. 0.027 0.027 ↑ 2.4 96 1

Seq Scan on romeo_india quebec (cost=0.000..12.300 rows=230 width=324) (actual time=0.006..0.027 rows=96 loops=1)