explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CbKi

Settings
# exclusive inclusive rows x rows loops node
1. 0.710 62.002 ↑ 15.9 41 1

Hash Join (cost=245.14..259.90 rows=652 width=68) (actual time=34.344..62.002 rows=41 loops=1)

  • Hash Cond: (foxtrot.echo = sierra_four.echo)
2.          

CTE foxtrot

3. 0.675 26.430 ↑ 15.9 41 1

Recursive Union (cost=4.29..137.13 rows=652 width=8) (actual time=0.050..26.430 rows=41 loops=1)

4. 0.035 0.057 ↑ 1.0 2 1

Bitmap Heap Scan on oscar (cost=4.29..7.42 rows=2 width=8) (actual time=0.035..0.057 rows=2 loops=1)

  • Recheck Cond: (charlie = 'five'::oid)
  • Heap Blocks: exact=1
5. 0.022 0.022 ↑ 1.0 2 1

Bitmap Index Scan on bravo (cost=0.00..4.29 rows=2 width=0) (actual time=0.015..0.022 rows=2 loops=1)

  • Index Cond: (charlie = 'five'::oid)
6. 12.816 25.698 ↑ 5.0 13 3

Hash Join (cost=0.65..11.67 rows=65 width=8) (actual time=5.783..8.566 rows=13 loops=3)

  • Hash Cond: (xray1.charlie = sierra_charlie1.echo)
7. 12.210 12.210 ↑ 1.0 524 3

Seq Scan on oscar victor (cost=0.00..8.24 rows=524 width=8) (actual time=0.015..4.070 rows=524 loops=3)

8. 0.339 0.672 ↑ 1.4 14 3

Hash (cost=0.40..0.40 rows=20 width=8) (actual time=0.222..0.224 rows=14 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
9. 0.333 0.333 ↑ 1.4 14 3

WorkTable Scan on (cost=0.00..0.40 rows=20 width=8) (actual time=0.008..0.111 rows=14 loops=3)

10. 27.033 27.033 ↑ 15.9 41 1

CTE Scan on foxtrot (cost=0.00..13.04 rows=652 width=8) (actual time=0.064..27.033 rows=41 loops=1)

11. 17.071 34.259 ↓ 1.0 2,046 1

Hash (cost=82.45..82.45 rows=2,045 width=68) (actual time=34.252..34.259 rows=2,046 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 216kB
12. 17.188 17.188 ↓ 1.0 2,046 1

Seq Scan on sierra_four (cost=0.00..82.45 rows=2,045 width=68) (actual time=0.013..17.188 rows=2,046 loops=1)

Planning time : 0.161 ms
Execution time : 62.571 ms