explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pZ4e

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 89.665 182.171 ↑ 6.2 26 1

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

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

CTE oscar

3. 0.038 0.491 ↑ 202.0 3 1

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

4. 0.066 0.252 ↑ 6.0 1 1

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

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

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

6. 0.028 0.094 ↑ 6.0 1 1

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

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

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

  • Recheck Cond: (charlie = 'zulu'::text)
  • Heap Blocks: exact=1
  • -> Bitmap Index Scan on acl_group_membership_subject_id_idx (cost=0.00..4.20 rows=6 width=0) (actual time=0.016..0.016 ro
  • Index Cond: (charlie = 'zulu'::text)
8. 0.095 0.201 ↑ 60.0 1 3

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

  • Hash Cond: (quebec_sierra.quebec_seven = kilo.xray)
9. 0.064 0.064 ↑ 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.032 rows=11 loops=2)

10. 0.024 0.042 ↑ 60.0 1 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
11. 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)

12. 0.115 92.506 ↑ 6.2 26 1

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

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

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

14. 81.555 91.781 ↑ 1.0 53 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
15. 10.226 10.226 ↑ 1.0 53 1

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