explain.depesz.com

PostgreSQL's explain analyze made readable

Result: njXb

Settings
# exclusive inclusive rows x rows loops node
1. 0.241 127,585.173 ↑ 1.0 101 1

Limit (cost=1,828,336.06..2,474,224.67 rows=101 width=32) (actual time=127,165.934..127,585.173 rows=101 loops=1)

2.          

CTE six

3. 9.809 127,169.555 ↑ 3.5 2,814 1

Gather Merge (cost=1,827,190.38..1,828,334.49 rows=9,806 width=52) (actual time=127,165.355..127,169.555 rows=2,814 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 8.690 127,159.746 ↑ 3.8 1,299 3 / 3

Sort (cost=1,826,190.35..1,826,202.61 rows=4,903 width=52) (actual time=127,159.343..127,159.746 rows=1,299 loops=3)

  • Sort Key: whiskey.quebec_seven
  • Sort Method: quicksort Memory: 236kB
  • Worker 0: Sort Method: quicksort Memory: 235kB
  • Worker 1: Sort Method: quicksort Memory: 246kB
5. 127,151.056 127,151.056 ↑ 3.3 1,487 3 / 3

Parallel Seq Scan on whiskey (cost=0.00..1,825,889.81 rows=4,903 width=52) (actual time=46.757..127,151.056 rows=1,487 loops=3)

  • Filter: (quebec_foxtrot ~* 'echo'::text)
  • Rows Removed by Filter: 39,220,044
6. 1.994 127,584.932 ↑ 48.5 101 1

Nested Loop Semi Join (cost=1.57..31,354,376.40 rows=4,903 width=32) (actual time=127,165.932..127,584.932 rows=101 loops=1)

7. 127,172.094 127,172.094 ↑ 3.5 2,814 1

CTE Scan on six papa (cost=0.00..196.12 rows=9,806 width=40) (actual time=127,165.364..127,172.094 rows=2,814 loops=1)

8. 1.473 410.844 ↓ 0.0 0 2,814

Nested Loop (cost=1.57..6,339.58 rows=120 width=16) (actual time=0.146..0.146 rows=0 loops=2,814)

  • Join Filter: (papa.quebec_seven = tango_golf.whiskey)
9. 15.004 402.402 ↓ 0.0 0 2,814

Nested Loop (cost=0.99..5,372.08 rows=116 width=16) (actual time=0.143..0.143 rows=0 loops=2,814)

10. 301.098 301.098 ↑ 74.5 6 2,814

Index Scan using five_three on tango_five juliet (cost=0.57..1,756.90 rows=447 width=37) (actual time=0.051..0.107 rows=6 loops=2,814)

  • Index Cond: (whiskey = papa.quebec_seven)
11. 86.300 86.300 ↓ 0.0 0 17,260

Index Only Scan using alpha on five_foxtrot (cost=0.42..8.09 rows=1 width=21) (actual time=0.005..0.005 rows=0 loops=17,260)

  • Index Cond: (quebec_seven = (juliet.five_foxtrot)::bytea)
  • Heap Fetches: 101
12. 6.969 6.969 ↑ 1.0 1 101

Index Only Scan using mike on uniform_sierra tango_golf (cost=0.57..8.33 rows=1 width=16) (actual time=0.069..0.069 rows=1 loops=101)

  • Index Cond: ((whiskey = juliet.whiskey) AND (uniform_quebec = juliet.uniform_quebec))
  • Heap Fetches: 101
Planning time : 5.807 ms
Execution time : 127,585.938 ms