explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sbp

Settings
# exclusive inclusive rows x rows loops node
1. 0.691 30.895 ↑ 4.9 41 1

HashAggregate (cost=425.18..427.18 rows=200 width=68) (actual time=30.599..30.895 rows=41 loops=1)

  • Group Key: foxtrot.sierra_bravo, foxtrot.yankee
2.          

CTE foxtrot

3. 0.662 29.590 ↑ 8.1 41 1

Recursive Union (cost=4.99..416.91 rows=331 width=68) (actual time=0.261..29.590 rows=41 loops=1)

4. 0.053 0.509 ↓ 2.0 2 1

Nested Loop (cost=4.99..17.92 rows=1 width=68) (actual time=0.245..0.509 rows=2 loops=1)

5. 0.113 0.428 ↓ 2.0 2 1

Nested Loop (cost=4.85..17.76 rows=1 width=72) (actual time=0.210..0.428 rows=2 loops=1)

  • Join Filter: (three.bravo_seven = bravo_charlie.echo)
  • Rows Removed by Join Filter: 8
6. 0.053 0.229 ↓ 2.0 2 1

Nested Loop (cost=4.85..16.62 rows=1 width=76) (actual time=0.115..0.229 rows=2 loops=1)

7. 0.054 0.144 ↓ 2.0 2 1

Nested Loop (cost=4.58..15.76 rows=1 width=8) (actual time=0.078..0.144 rows=2 loops=1)

8. 0.037 0.037 ↑ 1.0 1 1

Index Scan using xray on sierra_four three (cost=0.28..8.29 rows=1 width=8) (actual time=0.022..0.037 rows=1 loops=1)

  • Index Cond: (yankee = 'lima_hotel'::name)
9. 0.034 0.053 ↑ 1.5 2 1

Bitmap Heap Scan on oscar (cost=4.30..7.44 rows=3 width=8) (actual time=0.031..0.053 rows=2 loops=1)

  • Recheck Cond: (charlie = three.echo)
  • Heap Blocks: exact=1
10. 0.019 0.019 ↑ 1.5 2 1

Bitmap Index Scan on bravo_hotel (cost=0.00..4.30 rows=3 width=0) (actual time=0.013..0.019 rows=2 loops=1)

  • Index Cond: (charlie = three.echo)
11. 0.032 0.032 ↑ 1.0 1 2

Index Scan using whiskey on sierra_four bravo_two (cost=0.28..0.86 rows=1 width=72) (actual time=0.013..0.016 rows=1 loops=2)

  • Index Cond: (echo = oscar.tango_tango)
12. 0.086 0.086 ↑ 1.2 5 2

Seq Scan on lima_foxtrot bravo_charlie (cost=0.00..1.06 rows=6 width=4) (actual time=0.011..0.043 rows=5 loops=2)

13. 0.028 0.028 ↑ 1.0 1 2

Index Only Scan using tango_kilo on lima_foxtrot golf (cost=0.13..0.15 rows=1 width=4) (actual time=0.011..0.014 rows=1 loops=2)

  • Index Cond: (echo = bravo_two.bravo_seven)
  • Heap Fetches: 2
14. 1.281 28.419 ↑ 2.5 13 3

Nested Loop (cost=0.60..39.24 rows=33 width=68) (actual time=6.188..9.473 rows=13 loops=3)

15. 13.173 26.592 ↑ 2.5 13 3

Hash Join (cost=0.33..10.86 rows=33 width=4) (actual time=6.148..8.864 rows=13 loops=3)

  • Hash Cond: (mike.charlie = alpha_alpha.sierra_bravo)
16. 12.663 12.663 ↑ 1.0 524 3

Seq Scan on oscar mike (cost=0.00..8.24 rows=524 width=8) (actual time=0.012..4.221 rows=524 loops=3)

17. 0.420 0.756 ↓ 1.4 14 3

Hash (cost=0.20..0.20 rows=10 width=4) (actual time=0.250..0.252 rows=14 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
18. 0.336 0.336 ↓ 1.4 14 3

WorkTable Scan on (cost=0.00..0.20 rows=10 width=4) (actual time=0.011..0.112 rows=14 loops=3)

19. 0.546 0.546 ↑ 1.0 1 39

Index Scan using whiskey on sierra_four alpha_oscar (cost=0.28..0.86 rows=1 width=68) (actual time=0.014..0.014 rows=1 loops=39)

  • Index Cond: (echo = mike.tango_tango)
20. 30.204 30.204 ↑ 8.1 41 1

CTE Scan on foxtrot (cost=0.00..6.62 rows=331 width=68) (actual time=0.277..30.204 rows=41 loops=1)

Planning time : 0.524 ms
Execution time : 31.490 ms