explain.depesz.com

PostgreSQL's explain analyze made readable

Result: M5tO

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.184 1.065 ↑ 6.2 26 1

Sort (cost=355.670..356.080 rows=161 width=50) (actual time=0.988..1.065 rows=26 loops=1)

  • Sort Key: oscar.victor, romeo_xray.quebec_seven
  • Sort Method: quicksort Memory: 27kB
2.          

CTE oscar

3. 0.040 0.412 ↑ 202.0 3 1

Recursive Union (cost=13.740..324.760 rows=606 width=20) (actual time=0.110..0.412 rows=3 loops=1)

4. 0.055 0.138 ↑ 6.0 1 1

Hash Join (cost=13.740..38.510 rows=6 width=20) (actual time=0.103..0.138 rows=1 loops=1)

  • Hash Cond: (uniform.quebec_seven = whiskey.echo)
5. 0.040 0.040 ↑ 97.3 11 1

Seq Scan on uniform (cost=0.000..20.700 rows=1,070 width=16) (actual time=0.007..0.040 rows=11 loops=1)

6. 0.019 0.043 ↑ 6.0 1 1

Hash (cost=13.670..13.670 rows=6 width=8) (actual time=0.043..0.043 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.013 0.024 ↑ 6.0 1 1

Bitmap Heap Scan on romeo_hotel whiskey (cost=4.200..13.670 rows=6 width=8) (actual time=0.021..0.024 rows=1 loops=1)

  • Recheck Cond: (charlie = 'zulu'::text)
  • Heap Blocks: exact=1
8. 0.011 0.011 ↑ 6.0 1 1

Bitmap Index Scan on bravo (cost=0.000..4.200 rows=6 width=0) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: (charlie = 'zulu'::text)
9. 0.107 0.234 ↑ 60.0 1 3

Hash Join (cost=1.950..27.410 rows=60 width=20) (actual time=0.036..0.078 rows=1 loops=3)

  • Hash Cond: (quebec_sierra.quebec_seven = kilo.xray)
10. 0.076 0.076 ↑ 97.3 11 2

Seq Scan on uniform quebec_sierra (cost=0.000..20.700 rows=1,070 width=16) (actual time=0.005..0.038 rows=11 loops=2)

11. 0.033 0.051 ↑ 60.0 1 3

Hash (cost=1.200..1.200 rows=60 width=12) (actual time=0.017..0.017 rows=1 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
12. 0.018 0.018 ↑ 60.0 1 3

WorkTable Scan on group_tree p (cost=0.000..1.200 rows=60 width=12) (actual time=0.003..0.006 rows=1 loops=3)

13. 0.108 0.881 ↑ 6.2 26 1

Hash Join (cost=2.190..25.010 rows=161 width=50) (actual time=0.469..0.881 rows=26 loops=1)

  • Hash Cond: (oscar.quebec_seven = romeo_xray.echo)
14. 0.440 0.440 ↑ 202.0 3 1

CTE Scan on oscar (cost=0.000..12.120 rows=606 width=12) (actual time=0.118..0.440 rows=3 loops=1)

15. 0.175 0.333 ↑ 1.0 53 1

Hash (cost=1.530..1.530 rows=53 width=46) (actual time=0.333..0.333 rows=53 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
16. 0.158 0.158 ↑ 1.0 53 1

Seq Scan on romeo_xray (cost=0.000..1.530 rows=53 width=46) (actual time=0.004..0.158 rows=53 loops=1)